mysql 客户端版本: 5.0.45_新手 SQL查询语句出错,MYSQL服务器版本: 5.0.45-community-nt-log.这是个论坛发帖的数据库,求大虾指点.....

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

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 = Latin1

MySQL 返回：

====================系统报错情况========================

#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 NU' at line 1

展开