数据库（管理触发器）

1.创建触发器tr1，当更新表的cno列时，对应sc表中的cno也要随之改变，并验证
create trigger tr1
after update on course for each row
begin
if new.cno != old.cno then
update sc
set cno = new.cno
where cno = old.cno;
end if;
end //
2.创建触发器tr2，当购买商品时，你的余额会相应减少，并验证；
create trigger tr2
after insert on perchase for each row
begin
update captital
set balance = balance - new.mount * (select price
from goods
where gid = new.gid)
where cid = new.cid;
end //
3.创建触发器tr3，当删除学生表记录时，对应sc表中的该同学记录也被删除，并验证；
create trigger tr3
after delete on student for each row
begin
delete from sc
where sno = old.sno;
end //
4.查看你所创建的触发器；
5.删除触发器tr1。
drop trigger tr1//