MySQL achieves data synchronization between two tables, and mysql achieves data synchronization between two tables.

MySQL achieves data synchronization between two tables, and mysql achieves data synchronization between two tables.

Mysql uses a trigger to synchronize two tables. For more information, see.

There are two tables A and B. You must insert A record into Table A and A record into Table B at the same time, insert A record to B and insert A record to. The two tables have different structures and need to correspond several fields. You can use the following trigger.

Trigger for table:

Beginset @ disable = 1; if @ disable = 1 and not exists (SELECT 1 FROM tableB where ID = new. ID) then insert into tableB (ID, corresponding to field 1) values (new. ID, new. corresponding Field 1); end if; set @ disable = 0; end

Table B triggers:

Beginset @ disable = 1; if @ disable = 1 and not exists (SELECT 1 FROM tableA where ID = new. ID) then insert into tableA (ID, corresponding to field 1) values (new. ID, new. corresponding Field 1); end if; set @ disable = 0; end

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.