语句
CREATE TABLE 'test'(
'id' int( 10 ) NOT NULL AUTO_INCREMENT ,
'uid' varchar(10) NOT NULL default '0',
'regdate' date NOT NULL ,
'remark' text,
PRIMARY KEY ('id')) ENGINE = innodb default CHARSET = gbk AUTO_INCREMENT =5;
可能是mysql版本问题吧,把所有的单引号去掉就不出错了
正确写法:
CREATE TABLE test(
id int( 10 ) NOT NULL AUTO_INCREMENT ,
uid varchar(10) NOT NULL default 0,
regdate date NOT NULL ,
remark text,
PRIMARY KEY (id)) ENGINE = innodb default CHARSET = gbk AUTO_INCREMENT =5