在mysql(版本:5.0.18-nt)上运行以下语句报错 Create table ever_user
(
Uid char(40) not null,
Pwd char(40) not null,
Info char(100) not null,
Eassy int not null,
Totaltime char(14) not null,
Reads int not null,
If_new_info int not null,
Constraint pk_ever_user primary key (Uid)
);
错误信息:
ERROR 1064 (42000): 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 'Reads
int not null,
If_new_info int not null,
Constraint pk_ever_user primary ke' at line 8请问那里有语法错误?
(
Uid char(40) not null,
Pwd char(40) not null,
Info char(100) not null,
Eassy int not null,
Totaltime char(14) not null,
Reads int not null,
If_new_info int not null,
Constraint pk_ever_user primary key (Uid)
);
错误信息:
ERROR 1064 (42000): 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 'Reads
int not null,
If_new_info int not null,
Constraint pk_ever_user primary ke' at line 8请问那里有语法错误?
要么用`Reads`
过来了!
Create table ever_user
(
Uid char(40) not null,
Pwd char(40) not null,
Info char(100) not null,
Eassy int not null,
Totaltime char(14) not null,
Reads_xiaoyu int not null,
If_new_info int not null,
Constraint pk_ever_user primary key (Uid)
); 这样就过去了,你的Reads字段改了就可以过来了,【reads】保留字!
(
Uid char(40) not null,
Pwd char(40) not null,
Info char(100) not null,
Eassy int not null,
Totaltime char(14) not null,
Reads int not null, #修改Reads为其他名称
If_new_info int not null,
Constraint pk_ever_user primary key (Uid)
);