MySQL - a little help please

[Linusr@flanders]

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!!

Thor

[iInspire]

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

[btomasik]

How about a cronjob bash script?