meclasschar16
ot
ullsemailvarchar20（2）、teacher表
9
fcreatetableteachert
ochar5
ot
ullprimarykeyt
amevarchar10
ot
ulldepartvarchar8
ot
ullTsexchar2
ot
ullTbirthdatetimeprofchar6
3、course表createtablecoursec
ochar5
ot
ullprimarykeyc
amevarchar10
ot
ullt
ochar5
ot
ullforeig
keyt
orefere
cescourset
o（4）、score表createtablescores
ochar8
ot
ullc
ochar5
ot
ulldegreefloat
ot
ullforeig
keys
orefere
cescourset
oforeig
keyc
orefere
cescourset
o2向表中添加记录
10
f（1）、向学生信息表中添加i
serti
tostude
tvalues05c1201王一女
19860918信计052wa
gyi126comi
serti
tostude
tvalues05c1202王二男
19861018信计051wa
ger126comi
serti
tostude
tvalues05c1203王三女
19860605信计052wa
gsa
126comi
serti
tostude
tvalues05c1204王四男
19870103数学051wa
gsi126comi
serti
tostude
tvalues05c1205王五男
19860825信计052wa
gwu126comi
serti
tostude
tvalues05c1206万一女
19870211信计052wa
yi126comi
serti
tostude
tvalues05c1207万二男
19860307信计051wa
er126comi
serti
tostude
tvalues05c1208杨一男
19860808信计052ya
gyi126comi
serti
tostude
tvalues05c1209杨二女
19851123数学051ya
ger126comi
serti
tostude
tvalues05c1210杨三男
19861230数学051ya
gsa
126comi
serti
tostude
tvalues05c1211杨四女
11
f19860426信计051ya
gsi126comi
serti
tostude
tvalues05c1212于一男
19860716信计051yuyi126comi
serti
tostude
tvalues05c1213于二男
19860619信计052yuer126comi
serti
tostude
tvalues05c1214于三女
19870312信计052yusa
126com………………查看记录Selectfromstude
t
（2）、向教师表中添加i
serti
toteachervalues056杨过计算机系男197345教授i
serti
toteachervalues032黄蓉计算机系女1975121副教授
12
fi
serti
toteachervalues113小龙女管理系女197533副教授i
serti
toteachervalues214欧阳锋英语系男197455教授i
serti
toteachervalues302萧峰理学院男197055教授i
serti
toteachervalues322胡一刀理学院男197655教授查看记录Selectfromteacher
（3）、向课程表中添加数据i
serti
tocoursevalues01数据库032i
serti
tocoursevalues02信息论基础302i
serti
tocoursevalues03英语214i
serti
tocourser