数据库实验报告：实验五.docx

文档介绍：数据库实验报告：实验五
实验五：
实验过程：
（学号：95030，姓名：李莉，年龄：18）
insert into student(Sno,Sname,Sage) value

数据库实验报告：实验五
实验五：
实验过程：
（学号：95030，姓名：李莉，年龄：18）
insert into student(Sno,Sname,Sage) values('95030','李莉',18);
（95030，1）
insert into sc(Sno,Cno) values('08001','007');

update student set Sage=20 where Sdept='cs';

update student set Sage=0 where Sdept='ma';
5. 把低于总平均成绩的女同学成绩提高5分
update sc set Grade=Grade+5 where grade75;

delete from sc where sno='95030';

delete from sc where grade is null;



delete from sc where sno = (select sno from student where sname='张那');
delete from sc where sno in (select sno from student where sdept='ma');

delete from sc where sno in (select sno from sc where grade80);
select sno,sname,ssex into xtu from student where sno in (select sno from sc group by sno having min(grade)>80);

select sno+cno as newline into xdu from sc;

update student set sage=sage+1;
实验五：
实验过程：
（学号：950