mysql触发器是非常重要的概念，下面为您介绍的是mysql触发器的三个状态，供您参考，希望让您对mysql触发器能够有更深的认识。
CREATE TRIGGER `user1_user2` AFTER INSERT ON `user1` FOR EACH ROW insert into user2 SELECT * from user1 order by id desc limit 1 WHERE id>=LAST_INSERT_ID() AND id <=LAST_INSERT_ID()+ROW_COUNT() CREATE TRIGGER `update_user` AFTER UPDATE ON `user1` FOR EACH ROW update user2 set name=new.user,info=new.pwd where id=old.id; CREATE TRIGGER `del_user` AFTER DELETE ON `user1` FOR EACH ROW delete from user2 where id=old.id =================复杂的insert CREATE TRIGGER `test`.`insert_user2` AFTER INSERT ON `test`.`user1` FOR EACH ROW INSERT INTO user2 SET `id` = NEW.id, `name` = NEW.user, `info` = NEW.pwd, `date2` = UNIX_TIMESTAMP( NEW.date1 ) , `enum2` = NEW.enum1 -1, `aid`=(select aid from protype where id=NEW.type_id)
以上mysql触发器的三个状态介绍。