/*插入双向触发*/
- DELIMITER //
- CREATE TRIGGER tr_Insert_user1
- AFTER INSERT ON user1
- FOR EACH ROW
- BEGIN
- -- 检查当前 环境,避免递归.
- IF @disable_trigger IS NULL THEN
- -- 设置禁用触发器标志.
- SET @disable_trigger = 1;
- -- 插入目标表
- insert into user2(ue_name,ue_phone,ue_password) values(new.name,new.phone,new.password);
- -- 恢复禁用触发器标志.
- SET @disable_trigger = NULL;
- END IF;
- END;
- //
- DELIMITER ;
-
- DELIMITER //
- CREATE TRIGGER tr_Insert_user2
- AFTER INSERT ON user2
- FOR EACH ROW
- BEGIN
- -- 检查当前 环境,避免递归.
- IF @disable_trigger IS NULL THEN
- -- 设置禁用触发器标志.
- SET @disable_trigger = 1;
- -- 插入目标表
- insert into user1(name,phone,password) values(new.ue_name,new.ue_phone,new.ue_password);
- -- 恢复禁用触发器标志.
- SET @disable_trigger = NULL;
- END IF;
- END;
- //
- DELIMITER ;
复制代码
/*删除双向触发*/- DELIMITER //
- CREATE TRIGGER tr_Delete_user1
- AFTER DELETE ON user1
- FOR EACH ROW
- BEGIN
- -- 检查当前 环境,避免递归.
- IF @disable_trigger IS NULL THEN
- -- 设置禁用触发器标志.
- SET @disable_trigger = 1;
- -- 删除目标表
- delete from user2 where id=old.id;
- -- 恢复禁用触发器标志.
- SET @disable_trigger = NULL;
- END IF;
- END;
- //
- DELIMITER ;
-
- DELIMITER //
- CREATE TRIGGER tr_Delete_user2
- AFTER DELETE ON user2
- FOR EACH ROW
- BEGIN
- -- 检查当前 环境,避免递归.
- IF @disable_trigger IS NULL THEN
- -- 设置禁用触发器标志.
- SET @disable_trigger = 1;
- -- 删除目标表
- delete from user1 where id=old.id;
- -- 恢复禁用触发器标志.
- SET @disable_trigger = NULL;
- END IF;
- END;
- //
- DELIMITER ;
复制代码
/*更新双向触发*/- DELIMITER //
- CREATE TRIGGER tr_Update_user1
- AFTER UPDATE ON user1
- FOR EACH ROW
- BEGIN
- -- 检查当前 环境,避免递归.
- IF @disable_trigger IS NULL THEN
- -- 设置禁用触发器标志.
- SET @disable_trigger = 1;
- -- 更新目标表
- update user2 set ue_name=NEW.name,ue_phone=NEW.phone,ue_password=NEW.password where id=OLD.id;
- -- 恢复禁用触发器标志.
- SET @disable_trigger = NULL;
- END IF;
- END;
- //
- DELIMITER ;
-
- DELIMITER //
- CREATE TRIGGER tr_Update_user2
- AFTER UPDATE ON user2
- FOR EACH ROW
- BEGIN
- -- 检查当前 环境,避免递归.
- IF @disable_trigger IS NULL THEN
- -- 设置禁用触发器标志.
- SET @disable_trigger = 1;
- -- 更新目标表
- update user1 set name=NEW.ue_name,phone=NEW.ue_phone,password=NEW.ue_password where id=OLD.id;
- -- 恢复禁用触发器标志.
- SET @disable_trigger = NULL;
- END IF;
- END;
- //
- DELIMITER ;
复制代码 |
|
|