mysql
create table student (
sno int (20) no null ,
sname varchar (60) no null,
sex varchar (2) no null ,
dept varchar (18) no null ,
birth date() no null,
age int (10) no null check (age > '0' and age check (sex = 男 or sex = 女),
check (dept = '信息系' or dept = '计算机科学系' or dept = '数学系' or dept = '管理系' or dept = '中文系' or dept = '外语系' or dept = '法学系'),
unique (sno)
);
错误:::
query : create table student ( sno int (20) no null , sname varchar (60) no null, sex varchar (2) no null , dept varcha...
error code : 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 'no null ,
sname varchar (60) no null,
sex varchar (2) no null ,
dept' at line 2
execution time : 00:00:00:000
transfer time : 00:00:00:000
total time : 00:00:00:000
这个错误怎么改???求大神指导,在线等~~~~