Question

MySQL报错#1064 - You have an error in your SQL syntax; ......

CREATE TABLE `user` (

`id` INT( 10 ) NOT NULL ,
`user` VARCHAR( 100 ) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL ,
`pwd` VARCHAR( 100 ) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL ,
`sex` VARCHAR( 100 ) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL ,
`age` INT( 3 ) NOT NULL ,
`email` VARCHAR( 100 ) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL ,
`phone` INT( 12 ) NOT NULL ,
`createtime` DATETIME NOT NULL ,
`isadmin` BOOL( 5 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM CHARACTER SET gb2312 COLLATE gb2312_chinese_ci

我懂SQL语句懂的不多，请高手帮忙指出错误

Answer 1

修改成这样
=============================
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` INT( 10 ) NOT NULL ,
`user` VARCHAR( 100 ) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL ,
`pwd` VARCHAR( 100 ) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL ,
`sex` VARCHAR( 100 ) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL ,
`age` INT( 3 ) NOT NULL ,
`email` VARCHAR( 100 ) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL ,
`phone` INT( 12 ) NOT NULL ,
`createtime` DATETIME NOT NULL ,
`isadmin` BOOL NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
==============
提示`isadmin` BOOL( 5 ) NOT NULL ,错误
原因BOOL 是TINYINT(1)的同义词。0值被视为假。非0值视为真
也就是说，bool只有两个值0或1,所以你的BOOL( 5 ) 不是可以这样写的
创建表的时候，你可以给个默认值给它的，如`isadmin` BOOL NOT NULL default 0,