MYSQL´´½¨Ô¼ÊøµÄÎÊÌâ,Çó½â

-- Çó¸ßÊÖ½â´ðÈçºÎ´´½¨ÄêÁä¶ÎÔ¼Êø¡¢Ä¬ÈÏÔ¼Êø¡¢ÒÔ¼°Íâ¼üÔ¼Êø

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,'±±¾©º£µí'),
('ÀîÎIJÅ','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