Script:
SQL: CREATE TABLE cdb_images_sort ( id mediumint(10) unsigned NOT NULL, have char(1) NOT NULL default '0', name1 varchar(100) NOT NULL default '', name2 varchar(100) NOT NULL default '', UNIQUE KEY 'id' ('id') ) TYPE=MYISAM
Error: 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' ('id') ) TYPE=MYISAM' at line 1
Errno.: 1064
原表
CREATE TABLE cdb_images_sort (
id mediumint(10) unsigned NOT NULL,
have char(1) NOT NULL default '0',
name1 varchar(100) NOT NULL default '',
name2 varchar(100) NOT NULL default '',
UNIQUE KEY 'id' ('id')
) TYPE=MyISAM AUTO_INCREMENT=26 ; |