MySQL CREATE TABLE syntax error
I am trying to create an sql table but don't know What's wrong here? My
SQL syntax is as follows:
CREATE TABLE '__admin'('id' int NOT NULL AUTO_INCREMENT PRIMARY KEY,
'name' VARCHAR(32) NOT NULL, 'password' VARCHAR(32) NOT
NULL)ENGINE=MYISAM;
I get an error message saying:
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 ''id' int NOT
NULL AUTO_INCREMENT PRIMARY KEY, 'name' VARCHAR(32) NOT NULL, 'pass' at
line 1
Need a quick help please? Thanks
No comments:
Post a Comment