數據庫 db1 和 數據庫 db2 處于同一個數據庫連接下，分別擁有表 table1 和 table2，兩個表結構一致

現將 db1.table1 下的改動更新到 db2.table2，以下觸發(fā)器是在 db1 下創(chuàng)建的

1. 插入同步

   drop trigger if exists after_table1_insert
   delimiter $$
   create trigger after_table1_insert
   after insert
   on table1
   for each row
   begin
   insert into db2.table2 select * from table1 where id = new.id;
   end$$
   delimiter ;
   

2. 更新同步

   drop trigger if exists after_table1_update
   delimiter $$
   create trigger after_table1_update
   after update
   on table1
   for each row
   begin
   delete from db2.table2 where id = new.id;
   insert into db2.table2 select * from table1 where id = new.id;
   end$$
   delimiter ;
   

3. 刪除同步

   drop trigger if exists after_table1_delete
   delimiter $$
   create trigger after_table1_delete
   after delete
   on table1
   for each row
   begin
   delete from db2.table2 where id = old.id;
   end$$
   delimiter ;
   

擴展鏈接

觸發(fā)器創(chuàng)建語法： https://dev.mysql.com/doc/refman/8.0/en/create-trigger.html

觸發(fā)器創(chuàng)建示例： https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html