mysql 中 使用constraint 出错

作者: linuxydy 2011-11-17 21:47:44
create table Teachers
( Tno char(9) ,
Tname char(10)
CONSTRAINT C1 NOT NULL,
Tjob char(20),
Tsalary int ,
CONSTRAINT TeacherKey primary key (Tno)
);

我这样 创建 一个 表
结果 显示
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 'Tjob is not null
)' at line 7


各位大仙 怎么办 呢 求救

相关资讯