创建触发器(trigger)

90 阅读 0 评论 60 点赞

我是靠谱客的博主典雅小伙，最近开发中收集的这篇文章主要介绍创建触发器(trigger)，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

创建触发器

DROP TRIGGER IF EXISTS `ins_table_name`;
DELIMITER ;;
CREATE TRIGGER `ins_table_name` AFTER INSERT ON `table_name` FOR EACH ROW begin
insert into table_name_record select *, 'insert', 0 from table_name where id = new.id;
end
;;
DELIMITER ;
DROP TRIGGER IF EXISTS `upd_table_name`;
DELIMITER ;;
CREATE TRIGGER `upd_table_name` AFTER UPDATE ON `table_name` FOR EACH ROW begin
insert into table_name_record select *, 'update', 0 from table_name where id = new.id;
end
;;
DELIMITER ;
DROP TRIGGER IF EXISTS `del_table_name`;
DELIMITER ;;
CREATE TRIGGER `del_table_name` BEFORE DELETE ON `table_name` FOR EACH ROW begin
insert into table_name_record select *, 'delete', 0 from table_name where id = old.id;
end
;;