SQL: CREATE TABLE [Table]tradelog ( tid mediumint(8) unsigned NOT NULL, pid int(10) unsigned NOT NULL, orderid varchar(32) NOT NULL, tradeno varchar(32) NOT NULL, `subject` varchar(100) NOT NULL, price decimal(8,2) NOT NULL, quality tinyint(1) unsigned NOT NULL DEFAULT '0', itemtype tinyint(1) NOT NULL DEFAULT '0', number smallint(5) unsigned NOT NULL DEFAULT '0', tax decimal(6,2) unsigned NOT NULL DEFAULT '0.00', locus varchar(100) ENGINE=MYISAM DEFAULT CHARSET=gbk
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 'ENGINE=MYISAM DEFAULT CHARSET=gbk' at line 1
Errno.: 1064
出现这种情况,通常应该捡查哪些操作呢?先谢谢各位大哥 |