North34
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Downloads
Gallery
Store
Posts posted by North34
-
-
Hi :)
So I am doing the PHP and MySQL-course in the studioweb-course. And I am using Xampp on a Mac, so the fields in my SQL version does not look exactly like they do in the video.
I am currently at the video "PHPMyAdmin and Basic MySQL: part 2".
When I write in the value of " INSERT INTO people (name) VALUES ('Stefan’); " around 2.55 into the video, I get the message: " INSERT INTO people (name) VALUES ('Stefan’);
#1366 - Incorrect integer value: 'Stefan' for column `DATABAS2`.`people`.`name` at row 1 ".
Any idea on what that means and how to solve it? And why is it showing up in my video and not in the lesson?
Best regards
SQL video: "#1366 - Incorrect integer value: ERROR"
in StudioWeb
Posted · Edited by North34
It worked when I did it today. Changed from INT to Varchar.
But another thing. In the next lesson I was trying to insert an UPDATE-statement. But for some reason this will return:
SQL query: Copy
UPDATE people
SET name = ”Jimmy the Frog”
WHERE id = 3
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'the Frog”
WHERE id = 3' at line 2
I don't know why that happens but this is a screenshot of the options I had picked before I pasted the UPDATE statement: