Question

请问下面的代码哪错了？？

CREATE TABLE `message`(
`id` tinyint(1) NOT NULL auto_increment,
`user` varchar(25) NOT NULL,
`title` varchar(50) NOT NULL,
`content` tinytext NOT NULL,
`lastdate` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=innodb default CHARSET =gbk AUTO_INCREMENT;
提示的错误是
#1064 - 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 '' at line 8

Answer 1

CREATE TABLE `message`(
`id` tinyint(1) NOT NULL auto_increment,
`user` varchar(25) NOT NULL,
`title` varchar(50) NOT NULL,
`content` tinytext NOT NULL,
`lastdate` date NOT NULL,
PRIMARY KEY (`id`)
)

用标准sql，门上面这些就可以了，其他的不需要。mysql不是很熟悉，你再看看自增长字段是不是那么写

Answer 2

最后的AUTO_INCREMENT 去掉吧。

追问

还是不对啊？？