MySql觸發器實現資料同步學習

標籤：where   AC   tps   varchar   實現   new   logs   事件觸發   log   

觸發器實現：（增、刪、改操作事件觸發資料單向同步）
資料庫觸發器教程：https://www.cnblogs.com/phpper/p/7587031.html
同步代碼：

DELIMITER $DROP TRIGGER IF EXISTS insertdata;CREATE TRIGGER insertdata AFTER INSERT ON repair.user FOR EACH ROWBEGINDECLARE s1 INT(11);DECLARE s2 VARCHAR(30);SET s1=NEW.id;SET s2=NEW.name;INSERT INTO sale.user(id,name) VALUES(s1,s2);END $DELIMITER $DROP TRIGGER IF EXISTS updatedata;CREATE TRIGGER updatedata AFTER UPDATE ON repair.user FOR EACH ROWBEGINDECLARE s1 INT(11);DECLARE s2 VARCHAR(30);SET s1=OLD.id;SET s2=NEW.name;UPDATE sale.user a SET a.name=s2 WHERE a.id=s1;END $DELIMITER $DROP TRIGGER IF EXISTS deletedata;CREATE TRIGGER deletedata AFTER DELETE ON repair.user FOR EACH ROWBEGINDECLARE s1 INT(11);DECLARE s2 VARCHAR(30);SET s1=OLD.id;SET s2=OLD.name;DELETE FROM sale.user WHERE id=s1;END $

 

MySql觸發器實現資料同步學習