phporcaffeine Posted March 12, 2006 Share Posted March 12, 2006 I don't know if this REALLY IS a relational issue or not but here is the outline:2 databases on the same server/host/service instanceFirst database has a column/field that when changed (UPDATE/INSERT/DELETE) I would like a column/field in the second database to reflect that change as well.This is an easy-do with PHP I know, thats not what I am looking for though. I'm looking for som SQL magic that just "does-it", if there is such a thing. I was thinking possibly it had to do with relationships but now that I am thinking (scary) maybe a stored proceedure wich would require MySQL 5+.Any ideas are greatly appreciated. Link to comment https://forums.phpfreaks.com/topic/4785-mysql-relation-question/ Share on other sites More sharing options...
hitman6003 Posted March 12, 2006 Share Posted March 12, 2006 You could use a procedure, however I would use a trigger...[a href=\"http://dev.mysql.com/doc/refman/5.1/en/triggers.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/5.1/en/triggers.html[/a] Link to comment https://forums.phpfreaks.com/topic/4785-mysql-relation-question/#findComment-16799 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.