-- 求高手解答如何创建年龄段约束、默认约束、以及外键约束
drop database if exists StudentDB;
create database StudentDB;
use StudentDB;
create table StudentInfo
(
StuName varchar(8) not null,
StuNo char(6) not null,
StuSex char(2) not null,
StuAge tinyint not null,
StuSeat tinyint not null,
StuAddress varchar(50),
constraint PK_StudentInfo_StuSeat primary key (StuNo),
constraint CK_StudentInfo_StuSex check(StuSex in('男','女'))
-- constraint CK_StudentInfo_StuNo check(StuNo like 's253[0-9][0-9]'),
-- constraint CK_StudentInfo_StuAge check(StuAge < 40 and StuAge > 15),
-- constraint CK_StudentInfo_StuSeat check(StuSeat < 30 and StuSeat > 0)
-- constraint DF_StudentInfo_StuAddress default '地址不详'
);
-- 加入测试数据
insert into StudentInfo values('张秋丽','s25301','女',18,1,'北京海淀'),
('李斯文','s25303','男',22,2,'北京海淀'),
('李文才','s25302','男',85,3,'地址不详'),
('欧阳俊雄','s25304','男',28,4,'新疆'),
('梅超风','s25318','女',23,5,'');
use StudentDB;
create table StudentMarks
(
ExamNo char(7) not null,
StuNo char(6) not null,
WrittenE
