#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2013
    Posts
    1
    Rep Power
    0

    Mysql UDF login to remote mysql


    I have a need to query both the local and remote servers and union the results as a view. Is it possible to do this with a UDF? Basically the end result that I want is:

    Select * from table
    union
    remote_query(Select * from table)

    I don't need to pass remote server info this will be somewhat static during a migration period.

    TIA, Jeff
  2. #2
  3. No Profile Picture
    Lost in code
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2004
    Posts
    8,317
    Rep Power
    7170
    I could be wrong, but I'm pretty sure the answer is no.
    PHP FAQ

    Originally Posted by Spad
    Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around

IMN logo majestic logo threadwatch logo seochat tools logo