mysql增删改触发器

最新推荐文章于 2024-01-29 21:45:00 发布

西门吹雪的峥嵘岁月

最新推荐文章于 2024-01-29 21:45:00 发布

阅读量4.9k

点赞数

分类专栏： mysql 文章标签： mysql sql trigger

本文链接：https://blog.csdn.net/qq_41734645/article/details/105806095

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

update

DROP TRIGGER IF EXISTS `student_update`;
CREATE TRIGGER `student_update` AFTER UPDATE ON `ff_students`
 FOR EACH ROW BEGIN
INSERT INTO ff_triggers(type,item_id,createtime) VALUES('student',new.sid,unix_timestamp(now()));
END

insert

DROP TRIGGER IF EXISTS `student_insert`;
CREATE TRIGGER `student_insert` AFTER INSERT ON `ff_students`
 FOR EACH ROW BEGIN
INSERT INTO ff_triggers(type,item_id,createtime) VALUES('student',new.sid,unix_timestamp(now()));
END

delete

DROP TRIGGER IF EXISTS `student_delete`;
CREATE TRIGGER `student_delete` BEFORE DELETE ON `ff_students`
 FOR EACH ROW BEGIN
INSERT INTO ff_triggers(type,item_id,createtime) VALUES('student',old.sid,unix_timestamp(now()));
END