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.

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