MySQL triggers to implement data synchronization of two tables _mysql

MySQL implements synchronization of two tables through triggers
Currently, the local test was successful.
Suppose there is a table table2 (ID, val) under table table1 (ID, Val) under the local two databases A and b,a.
Suppose you want the data to be updated in the Table1, and the data in Table2 is synchronized.
Code:
DELIMITER $$
CREATE
/*[definer = {User | Current_User}]*/
TRIGGER ' a '. ' Trigger name ' before UPDATE
On ' a '. ' Table1 '
For each ROW BEGIN
IF new.id!=old.id THEN
UPDATE ' B '. ' Table2 ' SET ' B '. ' Table2 '. Id=new.id WHERE ' b '. ' Table2 '. Val=old.val;
End IF;
end$$
DELIMITER;
Find a lot of code online, in the Phpadmin run is not successful, always syntax error, phpMyAdmin can not be visualized to create triggers, so find another MySQL management tool, SQLyog. This tool is better, Java write, you can create triggers through the interface, and then the code to phpMyAdmin to run, success!