View Single Post
Old 6th November 2009, 08:55
Linusr@flanders Linusr@flanders is offline
Junior Member
Join Date: Dec 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL - a little help please


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?


Reply With Quote
Sponsored Links