需求:bookCollect表中发生insert后bookEntity表中的bookCollect列自增一,<pre name="code" class="sql">bookCollect表中发生delete后bookEntity表中的bookCollect列自减一。
trigger1:
begin
update wor_book
set BookCollect=BookCollect+1
where BookId=new.BookId;
end
trigger2:
begin
update wor_book
set BookCollect=BookCollect-1
where BookId=old.BookId;
end