作者:爱唱歌的郭少文_ | 来源:互联网 | 2018-04-25 07:35
CREATETABLE`student`(`sno`INT(20)NONULL,`sname`VARCHAR(60)NONULL,`sex`VARCHAR(2)NONULL,`dept`VARCHAR(18)NONULL,`birth`DATE()NONULL,`age`INT(10)NONULLCHECK(age>'0'ANDage<'100'),CHECK(s
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 <'100'),
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
这个错误怎么改???求大神指导,在线等~~~~