I am using MySQL Server 5.1. I am practicing the exercise in Kirupa. I create a database - kirupa, and a table - users. I add the following in the query:
CREATE TABLE users (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(70),
location VARCHAR(20),
date DATE NOT NULL
);
I have this error:
Error 1064 (42000): You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right
syntax to use near’“Granville barnett”,location=“Bradford”,date=CURDATE()'at line2
after adding this:
INSERT INTO users SET
name=”Granville Barnett”,
location=”Bradford”,
date=CURDATE();
What goes wrong ?
