数据库第七次作业-更新数据

目录

一、更新教师表中所有记录，将津贴改为2000

二、更新教师表中教师号在T5到T8之间的记录，将津贴改为1500

三、更新授课表中周数为8的记录，将教师号改为T7，课程号改为C1

四、更新课程表中课时数不在45，50中的记录，将课时数改为25

五、更新教师表中工资不等于3000并且津贴不为空的记录，将津贴改为1000

六、更新授课表中教室号在J102，Y104，Y303，J301中的记录，将周数改为14，课程号改为C5

七、更新教师表中工资等于2000并且岗位津贴大于等于1000的记录，将津贴改为500

八、更新课程表中带课程名称以字母“M”开头并且课程名称中有“L”字母的记录，将课时数改为78

九、更新授课表中教室在Y栋2楼的记录，将课程号改为C8，教师号改为T10

---

一、更新教师表中所有记录，将津贴改为2000

update teacher set
comm = 2000;

二、更新教师表中教师号在T5到T8之间的记录，将津贴改为1500

update teacher set
comm = 1500
where no between "t5" and "t8";

三、更新授课表中周数为8的记录，将教师号改为T7，课程号改为C1

update guochangsheng_school_teaching set
course_no = "c1",
teacher_no = "t7"
where week=8;

四、更新课程表中课时数不在45，50中的记录，将课时数改为25

update guochangsheng_course set
class_hours = 25
where class_hours !=45 and class_hours !=50;

五、更新教师表中工资不等于3000并且津贴不为空的记录，将津贴改为1000

update teacher set
comm = 1000
where sal !=3000 and comm is not null;

六、更新授课表中教室号在J102，Y104，Y303，J301中的记录，将周数改为14，课程号改为C5

update guochangsheng_school_teaching set
week = 14,
course_no = "c5"
where class_num="j102" or class_num="y104" or class_num="y303" or class_num="j301";

七、更新教师表中工资等于2000并且岗位津贴大于等于1000的记录，将津贴改为500

update teacher set
comm = 500
where sal = 2000 and comm >=1000;

八、更新课程表中带课程名称以字母“M”开头并且课程名称中有“L”字母的记录，将课时数改为78

 update guochangsheng_course set
 class_hours = 78
 where name like "m%l%";

九、更新授课表中教室在Y栋2楼的记录，将课程号改为C8，教师号改为T10

 update guochangsheng_school_teaching set
 course_no = "c8",
 teacher_no = "t10"
 where class_num like "y2%";