错误
SQL 查询:
/* MySQL Data Transfer Source Host: localhost Source Database: huochedingpiaoxr Target Host: localhost Target Database: huochedingpiaoxr */ USE huochedingpiaoxr;-- ----------------------------
-- Table structure for allusers
CREATE TABLE allusers
(
id
INT( 11 ) NOT NULL AUTO_INCREMENT ,username
VARCHAR( 50 ) DEFAULT NULL ,pwd
VARCHAR( 50 ) DEFAULT NULL ,cx
VARCHAR( 50 ) DEFAULT '普通管理员',addtime
TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
PRIMARY KEY ( id
)
) ENGINE = INNODB AUTO_INCREMENT =9 DEFAULT CHARSET = gb2312;
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 'CREATE TABLE allusers
(id
int(11) NOT NULL AUTO_INCREMENT,username
' at line 13