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版本太低了?