Mysql 雙向關聯觸發器

標籤：

雙向關聯觸發器

//增加delimiter // create trigger InsertDemoAFTER insert on vaccine.demofor each row Beginif not exists (select * from wechat.demo where wechat.demo.id = new.id) thenINSERT INTO wechat.demo(wechat.demo.`name`,wechat.demo.`password`) VALUES(new.name,new.password);end if; end;//delimiter ;delimiter // create trigger InsertDemoAFTER insert on wechat.demofor each row Beginif not exists (select * from vaccine.demo where vaccine.demo.id = new.id) thenINSERT INTO vaccine.demo(vaccine.demo.`name`,vaccine.demo.`password`) VALUES(new.name,new.password);end if; end;//delimiter ; //刪除CREATE TRIGGER deAfter DELETE ON vaccine.demoFOR EACH ROWBEGINif exists (select * from wechat.demo where wechat.demo.id = old.id) thenDELETE FROM wechat.demo WHERE wechat.demo.id= OLD.id;end if;END; CREATE TRIGGER deAfter DELETE ON wechat.demo FOR EACH ROWBEGINif exists (select * from vaccine.demo where vaccine.demo.id = old.id) thenDELETE FROM vaccine.demo WHERE vaccine.demo.id = OLD.id;end if;END;//修改CREATE TRIGGER upAfter UPDATE ON vaccine.demoFOR EACH ROWBEGINif not exists (select * from wechat.demo where wechat.demo.id = old.id and wechat.demo.`name`=new.name and wechat.demo.`password`=new.password) thenupdate wechat.demo set wechat.demo.`name`=new.name ,wechat.demo.`password`=new.password where wechat.demo.id =old.id;end if;END; CREATE TRIGGER upAfter UPDATE ON wechat.demo FOR EACH ROWBEGINif not exists (select * from vaccine.demo where vaccine.demo.id = new.id and vaccine.demo.`name`=new.name and vaccine.demo.`password`=new.password) thenupdate vaccine.demo set vaccine.demo.`name`=new.name ,vaccine.demo.`password`=new.password where vaccine.demo.id =old.id;end if;END;

 

Mysql 雙向關聯觸發器