- 修改student表,将cs系姓名为“李咏”的学生姓名为“李勇”;
use student
update student
set sname='李勇'
where sdept='CS' and sname='李咏'
- 将学号为“200515010”的学生信息重新设置为“王丹丹、女、20、MA”;
use student
update student
set sname='王丹丹',ssex='女',sage=20,sdept='MA'
where sno='200515010'
- 修改course表,将“数据处理”的学分改为3学分;
use student
update course
set ccredit=3
where cname='数据处理'
- 修改CS表,将选修课程“1”的同学成绩加5分;
use student
update sc
set grade=grade +5
where cno=1
- 删除数据表student中无专业的学生记录;
DELETE FROM student
WHERE sdept IS NULL
- 删除数据表course中学分低于1学分的课程信息;
DELETE
FROM course
WHERE ccredit<1