MySQL trigger for data synchronization learning

Tag: where AC TPS varchar implements new logs event trigger log

Trigger implementation: (Increment, delete, change operation Event trigger data one-way synchronization)
Database triggers tutorial: https://www.cnblogs.com/phpper/p/7587031.html
Sync Code:

DELIMITER $DROP TRIGGER IF EXISTS insertdata; CREATE TRIGGER InsertData after INSERT on Repair.user for each rowbegindeclare S1 INT ( One);D eclare S2 VARCHAR ( -); 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 ( One);D eclare S2 VARCHAR ( -); 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 ( One);D eclare S2 VARCHAR ( -); SET S1=old.id; SET S2=Old.name;delete from Sale.user WHERE ID=S1; END $

MySQL trigger for data synchronization learning