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
这个错误怎么改？？？求大神指导，在线等~~~~
