情况:一张表仅有2个外键,更新这张表的时候利用触发器更新对应外键的表的字段加1
代码:
create trigger goods_tirgger_insert after insert on favorites
for each row
begin
update goodsinfo set collectNum=collectNum+1 where goodsinfo.id=new.goodId;
end
情况:删除这张表中的一行,对应外键的字段减1
代码:
create trigger goods_tirgger_delete after delete on favorites
for each row
begin
update goodsinfo set collectNum=collectNum-1 where goodsinfo.id=old.goodId;
end