创建触发器

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;