Student(Sid,Sname,Sage,Sse*)
学生表CREATE TABLE student (
sid varchar(10) NOT NULL,
sName varchar(20) DEFAULT NULL,
sAge datetime DEFAULT ' 1980-10-12 23:12:36',
sSe* varchar(10) DEFAULT
NULL,
PRIMARY KEY (sid)
)ENGINE=InnoDB
DEFAULT
CHARSET=utf8;
Course(Cid,ame,Tid)
课程表CREATE TABLE course (
cid varchar(10) NOT NULL,
ame varchar(10) DEFAULT NULL,
tid int(20) DEFAULT NULL,
PRIMARY KEY (cid)
)ENGINE=InnoDB DEFAULT CHARSET=utf8; SC(Sid,Cid,score)
成绩表CREATE TABLE sc (
sid varchar(10) DEFAULT
...