mysql的不同数据库的两表双向触发器

跟着哥哥学魔法

于 2020-08-01 14:57:44 发布

阅读量428

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql

本文链接：https://blog.csdn.net/qq_40948117/article/details/107730993

-- 两表双向增加触发器

delimiter //
-- DROP TRIGGER IF EXISTS admin_insert
CREATE TRIGGER admin_insert AFTER INSERT ON hotmine.admin FOR EACH ROW
BEGIN
   IF NOT EXISTS ( SELECT * FROM hotmine_new.admin WHERE hotmine_new.admin.id = new.id ) THEN
           INSERT INTO hotmine_new.admin ( hotmine_new.admin.`user`, hotmine_new.admin.`password` )
       VALUES
           (new.`user`,new.`password`);
   END IF;
END//
delimiter;

delimiter //
CREATE TRIGGER admin_new_insert AFTER INSERT ON hotmine_new.admin FOR EACH ROW
BEGIN
   IF NOT EXISTS ( SELECT * FROM hotmine.admin WHERE hotmine.admin.id = new.id ) THEN
           INSERT INTO hotmine.admin ( hotmine.admin.`user`, hotmine.admin.`password` )
       VALUES
           (new.`user`,new.`password`);
   END IF;

最低0.47元/天解锁文章