最新 SQL综合实验一（下附完整脚本）(5)

values ('9607039','40711',85,80,88) insert xxx_grade

values ('9907002','10715',83,90,86) insert xxx_grade

values ('9801055','20111',78,60,65) insert xxx_grade

values ('9902006','10218',75,63,52) insert xxx_grade

values ('9704001','30423',80,81,85) insert xxx_grade

values ('9603001','40331',67,72,70) insert xxx_grade

values ('9606005','40625',83,85,84) insert xxx_grade

values ('9803011','20314',76,76,76) insert xxx__grade

values ('9908088','10811',82,92,89) insert xxx_grade

values ('9608066','30819',78,84,82) insert xxx_grade

values ('9907002','10712',90,96,97) insert xxx_grade

values ('9801055','20115',80,82,87) insert xxx_grade

values ('9902006','10222',85,91,79) insert xxx_grade

values ('9704001','30412',78,87,80) insert xxx_grade

values ('9603001','40316',66,71,73) insert xxx_grade

values ('9606005','40612',70,78,60) insert xxx_grade

values ('9803011','20328',90,88,87) insert xxx_grade

values ('9908088','10812',80,67,83) insert xxx_grade

values ('9608066','30832',95,92,93) insert xxx_grade

values ('9908088','10101',80,82,87) go

3.02

update xxx_student

set 学号='19'+substring(学号,1,4)+'10'+substring(学号,5,7) go

3.03

insert xxx_student

values('20131060178','杨杰波','532932199406030514','云南','A609' ,'15096914835','国家励志奖学金','无','1994-6-4') go

insert xxx_grade

values ('20131060178','20801',88,81,95) go

insert xxx_grade

values ('20131060178','11001',86,88,98) go

insert xxx_grade

values ('20131060178','11101',86,89,97) go

3.04

select 学号,姓名,籍贯,家庭住址,奖励 from xxx_student

where 籍贯='云南'or 家庭住址 like '江岸小区%4单元'