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