CREATE TABLE student(
sno INT(15) NOT NULL PRIMARY KEY,
sname VARCHAR(50),
sex CHAR(2) CHECK(sex IN('男','女')),
dept VARCHAR(25),
birth DATE,
age INT(3) CHECK(age >=0 AND age <=100)
)ENGINE=INNODB DEFAULT CHARSET=utf8;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024