《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
显示全部