MySQL报错,求指教!
create table e_employee(
eid int(8) auto_increment primary key,
ename varchar(128) not null,
eage int(6),
eno int(16) not null,
teleno int(128) not null,
desc varchar(128),
salary double(64,3) not null,
departno int(8),
foreign key(departno) references d_department(dID)
);
以上是我的建表语句,报错信息如下:
You have an error in you SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc varchar(128),salary double(64,3) not null, departno int(8),foreign key(de' at line 7
[解决办法]
desc 是保留关键词
[解决办法]
语法错误,用了desc,desc是查询表结构的关键字