Mysql bidirectional correlation Trigger

Bidirectional Association triggers

//Increase delimiter// Create TriggerInsertdemo  afterInsert  onVaccine.demo forEach rowBeginif Not exists(Select *  fromWechat.demowhereWechat.demo.id=New.id) ThenINSERT  intoWechat.demo (wechat.demo. ' Name ', Wechat.demo. ' Password ')VALUES(New.name,new.password);End if; End;//delimiter;d elimiter// Create TriggerInsertdemo  afterInsert  onWechat.demo forEach rowBeginif Not exists(Select *  fromVaccine.demowhereVaccine.demo.id=New.id) ThenINSERT  intoVaccine.demo (vaccine.demo. ' Name ', Vaccine.demo. ' Password ')VALUES(New.name,new.password);End if; End;//delimiter;//DeleteCREATE TRIGGERde  afterDELETE  onVaccine.demo forEach ROWBEGINif exists(Select *  fromWechat.demowhereWechat.demo.id=Old.id) ThenDELETE  fromWechat.demoWHEREWechat.demo.id=old.id;End if;END; CREATE TRIGGERde  afterDELETE  onWechat.demo forEach ROWBEGINif exists(Select *  fromVaccine.demowhereVaccine.demo.id=Old.id) ThenDELETE  fromVaccine.demoWHEREVaccine.demo.id=old.id;End if;END;//ModifyCREATE TRIGGERup  afterUPDATE  onVaccine.demo forEach ROWBEGINif Not exists(Select *  fromWechat.demowhereWechat.demo.id=Old.id andWechat.demo. ' Name '=New.name andWechat.demo. ' Password '=New.password) ThenUpdateWechat.demoSetWechat.demo. ' Name '=New.name, Wechat.demo. ' Password '=New.passwordwhereWechat.demo.id=old.id;End if;END; CREATE TRIGGERup  afterUPDATE  onWechat.demo forEach ROWBEGINif Not exists(Select *  fromVaccine.demowhereVaccine.demo.id=New.id andVaccine.demo. ' Name '=New.name andVaccine.demo. ' Password '=New.password) ThenUpdateVaccine.demoSetVaccine.demo. ' Name '=New.name, Vaccine.demo. ' Password '=New.passwordwhereVaccine.demo.id=old.id;End if;END;

Mysql bidirectional correlation Trigger