谁帮我看看 问题出在哪里

kgboy21

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 'BINAR
Y NOT NULL,author VARCHAR(20) CHARACTER SET gb2312 COLLATE gb2312_chinese_c' at
line 1

kider

我手打了前半句执行了下可以的：
DROP TABLE tb_tpsc;
CREATE TABLE tb_tpsc( id INT(10) NOT NULL, `tpmc` VARCHAR(30) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci  NOT NULL) ENGINE=INNODB;

你再检查检查，仔细调试下...