Saturday, June 30, 2018

php - Syntax error creating mysql database tables

CREATE TABLE items (

'itemnumber' int(10) NOT NULL AUTO_INCREMENT,
'itemname' varchar(255),
'slot' varchar(255),
'level' varchar(255),
'class' varchar(255),
'white1' varchar(255),
'white2' varchar(255),
'white3' varchar(255),
'purple1' varchar(255),
'purple2' varchar(255),

'purple3' varchar(255),
'id1' varchar(255),
'id2' varchar(255),
'id3' varchar(255),
'green1' varchar(255),
'green2' varchar(255),
'green3' varchar(255),
'icon' varchar(255),
'dateadded' varchar(255),
PRIMARY KEY ('itemnumber')

) ENGINE=MyISAM;


returns the following:




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 ''itemnumber' int(10) NOT NULL AUTO_INCREMENT,
'itemname' varchar(255),
'slot' va' at line 2


No comments:

Post a Comment

plot explanation - Why did Peaches' mom hang on the tree? - Movies & TV

In the middle of the movie Ice Age: Continental Drift Peaches' mom asked Peaches to go to sleep. Then, she hung on the tree. This parti...