Mysql uses a trigger to synchronize two tables

Mysql uses triggers to synchronize two tables. Currently, the test is successful locally. Www.2cto.com assume that two local databases, a and B, and a have table table1 (id, val) and B have table table2 (id, val). Assume that you want to update data in table 1, synchronously update data in table 2. Code: DELIMITER $ CREATE/* [DEFINER = {user | CURRENT_USER}] */TRIGGER 'A '. 'trigger name' before update on 'A '. 'table1' for each row beginif new. id! = Old. id then update 'B '. 'table2' SET 'B '. 'table2 '. id = new. id WHERE 'B '. 'table2 '. val = old. val; end if; END $ DELIMITER, so I found another mysql management tool, SQLyog. This tool is good. For java writing, you can create a trigger on the interface, and then copy the code to phpmyadmin to run it successfully! SQLyog: http://www.webyog.com/en/downloads.php#sqlyog