填空题
MySQL数据程序设计
题号 #2322280
假设之前创建的KC表没有设置外键级联策略,设置触发器,实现在KC表中修改课程ID号时,可自动修改课程在xs_kc上的课程ID号
Create trigger trigger_update( )on( ) for each row
( )
参考答案
暂无
答案解析
Create trigger trigger_update after update on kc for each row
update xs_kc set xs_kc.kno=new.kno where xs_kc.kno=old.kno;
update xs_kc set xs_kc.kno=new.kno where xs_kc.kno=old.kno;
你可能感兴趣的试题
A.alter event e_test disable
B.alter event e_test drop
C.alter event e_test enable
D.alter event e_test delete