mySql:
drop Trigger 'newChapter';
create trigger 'newChapter' after insert on 'xh_book' for each row 具体被触发的sql语句
如:下面两个触发器,一个insert触发,一个delete触发。
DROP TRIGGER `newChapterInsert`;
DROP TRIGGER `newChapterDelete`;
CREATE TRIGGER `newChapterInsert` AFTER INSERT ON `xh_book` FOR EACH ROW
begin
update xh_info set CONTENT=(select max(chapter) from xh_book)
where UID=1000
end;
CREATE TRIGGER `newChapterDelete` AFTER DELETE ON `xh_book` FOR EACH ROW
begin
update xh_info set CONTENT=(select max(chapter) from xh_book)
where UID=1000
end;