数据库插入数据表的脚本

大家可以下载下面已经制作好了的脚本 也可以复制下面代码自己复制到新建查询里面去

sql插入数据表的脚本

use students
go                      --这里表示 使用students这个表执行下面的代码
insert areaInfo(areaId,areaName) values('5800','市直属')
insert areaInfo(areaId,areaName) values('5801','船山区')
insert areaInfo(areaId,areaName) values('5802','安居区')
insert areaInfo(areaId,areaName) values('5803','射洪县')
insert areaInfo(areaId,areaName) values('5804','蓬溪县')
insert areaInfo(areaId,areaName) values('5805','大英县')

insert schoolInfo(schId,schName,areaId) values('000001','遂宁中学','5800')
insert schoolInfo(schId,schName,areaId) values('000002','遂宁一中','5801')
insert schoolInfo(schId,schName,areaId) values('000003','遂宁二中','5801')
insert schoolInfo(schId,schName,areaId) values('000004','遂宁四中','5801')
insert schoolInfo(schId,schName,areaId) values('000005','安居育才中学','5802')
insert schoolInfo(schId,schName,areaId) values('000006','西眉中学','5802')

insert stuInfo(schId,stuIdentity,stuName,stuPwd,classId,stuSex,applyNum,examNum,stuId)
 values('000002','510902199701010001','陈虹','123456','01','女','5000000001','5000000001','20160001')
insert stuInfo(schId,stuIdentity,stuName,stuPwd,classId,stuSex,applyNum,examNum,stuId)
 values('000002','510902199801010002','刘林','123456','01','男','5000000002','5000000002','20160002')
insert stuInfo(schId,stuIdentity,stuName,stuPwd,classId,stuSex,applyNum,examNum,stuId)
 values('000002','510902199811010002','张志','123456','01','男','5000000003','5000000003','20160003')
insert stuInfo(schId,stuIdentity,stuName,stuPwd,classId,stuSex,applyNum,examNum,stuId)
 values('000002','510902199601010002','吴遥','123456','02','女','5000000004','5000000004','20160004')
insert stuInfo(schId,stuIdentity,stuName,stuPwd,classId,stuSex,applyNum,examNum,stuId)
 values('000002','510902199612120002','李群','123456','02','女','5000000005','5000000005','20160005')
insert stuInfo(schId,stuIdentity,stuName,stuPwd,classId,stuSex,applyNum,examNum,stuId)
 values('000003','511902199712121002','陈慧','123456','01','女','5000000006','5000000006','20160006')
insert stuInfo(schId,stuIdentity,stuName,stuPwd,classId,stuSex,applyNum,examNum,stuId)
 values('000003','511902199710111002','曹元','123456','01','男','5000000007','5000000007','20160007')
insert stuInfo(schId,stuIdentity,stuName,stuPwd,classId,stuSex,applyNum,examNum,stuId)
 values('000003','511902199810111002','朱文','123456','02','男','5000000008','5000000008','20160008')



insert stuScores(stuIdentity,schId,Yw,Sx,Yy,Wl,Hx) values('510902199701010001','000002',87,98,65,78,90)
insert stuScores(stuIdentity,schId,Yw,Sx,Yy,Wl,Hx) values('510902199801010002','000002',81,78,95,78,80)
insert stuScores(stuIdentity,schId,Yw,Sx,Yy,Wl,Hx) values('510902199811010002','000002',77,91,75,68,98)
insert stuScores(stuIdentity,schId,Yw,Sx,Yy,Wl,Hx) values('510902199601010002','000002',96,68,75,74,80)
insert stuScores(stuIdentity,schId,Yw,Sx,Yy,Wl,Hx) values('510902199612120002','000002',87,98,74,85,79)
insert stuScores(stuIdentity,schId,Yw,Sx,Yy,Wl,Hx) values('511902199712121002','000003',89,83,69,70,93)
insert stuScores(stuIdentity,schId,Yw,Sx,Yy,Wl,Hx) values('511902199710111002','000003',76,98,68,89,75)
insert stuScores(stuIdentity,schId,Yw,Sx,Yy,Wl,Hx) values('511902199810111002','000003',83,78,85,88,70)