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 ~~~