《sql 数据库上机实验四》.doc

实SQL 数据更新 目的： 掌握SQL的常用操作，熟练应用。 内容： 应用操作；熟练综合应用； -----实验四sql 的数据更新 insert into student(sno,sname,sage)values(95030,李莉,18) insert into sc(sno,cno)values(95030,1) update student1 set sage=20 where sdept=IS update sc1 set grade=0 where sno in(select sno from student1 where sdept=MA) update sc set grade=grade+5 where sno in(select student.sno from student,sc where ssex=女 group by student.sno,grade having gradeAVG(grade)) update sc set grade=grade*1.05 where cno=2 and grade75 update sc set grade=grade*1.04 where cno=2 and grade75 delete from student1 where sno=95030 delete from sc1 where grade is null delete from sc1 where sno in(select sno from student1 where sname=张娜) delete from sc1 where grade60 delete from sc1 where sno in(select sno from student1 where sdept=MA) delete from course1 where cno not in(select cno from sc1,course1 where sc1.cno=course1.cno) create table stu(sno char(8),sname char(8),ssex char(4)) insert into stu(sno,sname,ssex) select sno,sname,ssex from student where sno in(select sno from sc where sno not in(select sno from sc where grade is null) group by sno having min(grade)=80) create table sdeptgrade(sdept char(4),avggrade char(2)) insert into sdeptgrade(sdept,avggrade) select sdept,AVG(grade) from sc,student group by sdept