mysql数据库建表失败_MYSQL数据库建表出错!!!

错误SQL查询:CREATETABLE'bbs'('cardID'SMALLINT(5)NOTNULLAUTO_INCREMENT,'poster'VARCHAR(50)NOTNULL,'posttime'DATETIMENOTNULL,'title'VARCHAR(100)NOTNULL,'content'TEXTNOTNULL...

错误SQL 查询:CREATE TABLE 'bbs'(

'cardID'SMALLINT( 5 ) NOT NULL AUTO_INCREMENT ,

'poster'VARCHAR( 50 ) NOT NULL ,

'posttime'DATETIME NOT NULL ,

'title'VARCHAR( 100 ) NOT NULL ,

'content'TEXT NOT NULL ,

'repID'SMALLINT( 5 ) DEFAULT NULL ,

'lastReptime'DATETIME DEFAULT NULL ,

'repNum'INT( 11 ) DEFAULT '0',

'conNum'INT( 11 ) DEFAULT '0',

'subjectID'SMALLINT( 5 ) NOT NULL DEFAULT '1',

'IP'VARCHAR( 50 ) DEFAULT NULL ,

PRIMARY KEY ( 'cardID' )) ENGINE = MYISAM AUTO_INCREMENT =61 DEFAULT CHARSET = Latin1MySQL 返回:#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 ''bbs' (

'cardID' smallint(5) NOT NULL auto_increment,

'poster' varchar(50) NOT' at line 1

请问问题出在哪?

展开

表情包
插入表情
评论将由博主筛选后显示,对所有人可见 | 还能输入1000个字符
相关推荐
©️2020 CSDN 皮肤主题: 数字20 设计师:CSDN官方博客 返回首页