MySQL - a little help please

Discussion in 'Programming/Scripts' started by Linusr@flanders, Nov 6, 2009.

  1. Linusr@flanders

    Linusr@flanders New Member

    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
     
  2. iInspire

    iInspire New Member

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

    btomasik New Member

    How about a cronjob bash script?
     

Share This Page