HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Programming/Scripts (http://www.howtoforge.com/forums/forumdisplay.php?f=7)
-   -   MySQL - a little help please (http://www.howtoforge.com/forums/showthread.php?t=40747)

Linusr@flanders 6th November 2009 08:55

MySQL - a little help please
 
Hi,

I hope this is the right spot for this question, if not, sorry...

My project uses mySQL, of course. There are several databases in the system, each has a members table that is identical to the ones in the others. Members are checked as active of non-active (money). Now, opposed to editing every members table in every database, I'd like to adopt the following approach: house the members table in a separate database, edit that and have the update "seep" through to the databases, a likely-like the "other" db server where you'd link tables between databases. I heard the term "confederated" tables.

Any ideas where to get info, some how to and some examples?

Thanks!!:D

Thor

iInspire 12th November 2009 10:50

Im not sure with MySQL, but i think there ia way to do it in Oracle ...\\but not sure

btomasik 30th November 2009 05:05

How about a cronjob bash script?


All times are GMT +2. The time now is 20:38.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.