DROP TRIGGER IF EXISTS `changePosition`;
DELIMITER ;;
CREATE TRIGGER `changePosition` AFTER UPDATE ON `bswork_position_info` FOR EACH ROW BEGIN
if new.id!=old.id then
insert into bswork_position_change(code,oid,nid,date) values(new.code,old.id,new.id,now());
END if;
END
;;
DELIMITER ;


【转载】原文地址：https://blog.csdn.net/xbh0127/article/details/80994928

赞一个