1. 用于应用程序审计日志实例： http://www.mysqltutorial.org/create-the-first-trigger-in-mysql.aspx 2. 会员点数更新之后自动计算会员等级 ~~~ create trigger auto_degree after update on `db_user` FOR EACH ROW begin set @point=(select points from `db_user` where user_id = old.user_id); if @point>100 and @point<=300 then update `db_user` set degree=2; end if; end ~~~