Home > Backend Development > PHP Tutorial > Mysql 话语报错

Mysql 话语报错

WBOY
Release: 2016-06-13 12:03:48
Original
912 people have browsed it

Mysql 语句报错

DROP TABLE IF EXISTS `v9_guestbook`;<br />CREATE?TABLE?`v9_guestbook`?(???<br />  `gid`?smallint(5)?NOT?NULL?AUTO_INCREMENT,???<br />  `title`?char(80)?NOT?NULL,?<br />??`content`?text?NOT?NULL,???<br />  `reply`?text?NOT?NULL,?<br />??`userid`?mediumint(8)?unsigned?NOT?NULL?default?'0',??<br />? `username`?char(20)?NOT?NULL,?<br />??`gender`?tinyint(1)?unsigned?NOT?NULL?default?'0',???<br />  `head`?tinyint(3)?unsigned?NOT?NULL?default?'0',???<br />  `email`?char(40)?NOT?NULL,???`qq`?char(15)?NOT?NULL,?<br />??`homepage`?char(25)?NOT?NULL,?<br />??`hidden`?tinyint(1)?unsigned?NOT?NULL?default?'0',?<br />??`passed`?tinyint(1)?unsigned?NOT?NULL?default?'0',???<br />  `ip`?char(15)?NOT?NULL,?<br />??`addtime`?int(10)?unsigned?NOT?NULL?default?'0',???<br />  `replyer`?char(20)?NOT?NULL,?<br />??`replytime`?int(10)?unsigned?NOT?NULL?default?'0',???<br />  PRIMARY?KEY?(`gid`),? <br />  KEY?`hidden` (`hidden`,`gid`)<br />  );
Copy after login

这段话报错是为什么呢
错误信息
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版本太低了?

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template