mysql通过触发器的形式同步数据库_MySQL数据库多数据库通过触发器同步问题

最新推荐文章于 2021-10-23 16:21:50 发布

熊腾浩

最新推荐文章于 2021-10-23 16:21:50 发布

阅读量123

点赞数

文章标签： mysql通过触发器的形式同步数据库

本文链接：https://blog.csdn.net/weixin_42515101/article/details/113266961

版权

自己写了一个，不会搞，老是出问题，高手支点招，谢谢啦~~有两个数据库的表filemanage的tbluser表和ishelves的admin表，我想让tbluser表变化是admin表跟着变化，不知错在那里，请高手...

自己写了一个，不会搞，老是出问题，高手支点招，谢谢啦~~有两个数据库的表 filemanage的tbluser表和ishelves的admin表，我想让tbluser表变化是admin表跟着变化，不知错在那里，请高手指教啊 tbluser：suer spwd spower ueverdata admin：suer spwd spower stel DELIMITER | CREATE TRIGGER tg_tbluser_admin_insert AFTER INSERT ON filemanage.tbluser FOR EACH ROW BEGIN INSERT INTO ishelves.admin(suser,spwd,spower) SELECT (suser,spwd,spower) FROM filemanage.tbluser WHERE filemanage.tbluser.suser=NEW.suser; END;| DELIMITER ; DELIMITER | CREATE TRIGGER tg_tbluser_admin_delete AFTER DELETE ON filemanage.tbluser FOR EACH ROW BEGIN DELETE FROM ishelves.admin WHERE filemanage.tbluser.suser=OLD.suser; END; | DELIMITER ; DELIMITER | CREATE TRIGGER tg_tbluser_admin_update AFTER UPDATE ON filemanage.tbluser FOR EACH ROW BEGIN DELETE FROM ishelves.admin WHERE ishelves.admin.suser=OLD.suser; INSERT INTO ishelves.admin SELECT (suser,spwd,spower,stel) FROM mother WHERE filemanage.tbluser.suser = OLD.suser; END; | DELIMITER ; 如果高手不愿意看代码给个多数据库之间使用触发器的实例也可以，问题解决后还可以追加100分！急需解决！多谢啦~~~

展开