use stusys;
select * from course a , score b
where a.cno=b.cno;
set sql_safe_updates=0;
#(1)创建触发器
delimiter //
create trigger T_updateCourseScore after update
on course for each row
begin
#将score表的原来课程号(old.cno)修改为新的课程号(new.cno)
update score set cno=new.cno where cno=old.cno;
end //
delimiter ;
#(2)设置验证功能
select * from course;
update course set cno='4017' where cno='4002';
select * from score where cno='4017';
select * from course where cno='4017';
05-15
7495
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)