Mysql 语句报错
DROP TABLE IF EXISTS `v9_guestbook`;
CREATE TABLE `v9_guestbook` (
`gid` smallint(5) NOT NULL AUTO_INCREMENT,
`title` char(80) NOT NULL,
`content` text NOT NULL,
`reply` text NOT NULL,
`userid` mediumint(8) unsigned NOT NULL default '0',
`username` char(20) NOT NULL,
`gender` tinyint(1) unsigned NOT NULL default '0',
`head` tinyint(3) unsigned NOT NULL default '0',
`email` char(40) NOT NULL, `qq` char(15) NOT NULL,
`homepage` char(25) NOT NULL,
`hidden` tinyint(1) unsigned NOT NULL default '0',
`passed` tinyint(1) unsigned NOT NULL default '0',
`ip` char(15) NOT NULL,
`addtime` int(10) unsigned NOT NULL default '0',
`replyer` char(20) NOT NULL,
`replytime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`gid`),
KEY `hidden` (`hidden`,`gid`)
);
这段话报错是为什么呢
错误信息
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 'CREATE TABLE `v9_guestbook` (
`gid` smallint(5) NOT NULL AUTO_IN' at line 1
感觉第一段话没错啊
------解决方案--------------------
两条指令都没有问题
你是在哪里执行的?
------解决方案--------------------
測試過,正常的。
------解决方案--------------------
我这边也测试过
看截图显示成功了,难道是你的MYSQL版本太低了?