Jump to content

Archived

This topic is now archived and is closed to further replies.

phporcaffeine

MySQL Relation Question

Recommended Posts

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 instance

First 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.

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.