查看所有触发器 show TRIGGERS
DELIMITER ;;
CREATE
TRIGGER `trigger1触发器名` BEFORE UPDATE ON `触发器所在表名` FOR EACH ROW insert into
templete (old) values (NEW.bz)
;;
DELIMITER
;
DELIMITER
;;
CREATE
TRIGGER `trigger1触发器名`
AFTER UPDATE ON `触发器所在表名`
FOR EACH ROW insert into templete (old) values (Old.bz)
;;
DELIMITER ;
原文：http://www.cnblogs.com/wystudio/p/3714490.html