1.更新教师表中所有记录,将津贴改为2000
update teacher set comm=2000;
2.更新教师表中教师号在T5到T8之间的记录,将津贴改为1500
update teacher set comm=1500 where no between"t5"and"t8";
3.更新授课表中周数为8的记录,将教师号改为T7,课程号改为C1
update school_teaching s
1.更新教师表中所有记录,将津贴改为2000
update teacher set comm=2000;
2.更新教师表中教师号在T5到T8之间的记录,将津贴改为1500
update teacher set comm=1500 where no between"t5"and"t8";
3.更新授课表中周数为8的记录,将教师号改为T7,课程号改为C1
update school_teaching s