On Fri, Jun 6, 2008 at 9:25 PM, TUT - LightSpeed <[EMAIL PROTECTED]> wrote:
> > Actually they are 2 connection to 2 different databases on 2 different > hosts. > I wanted rquery results from db1 to be in a temporary table to be used in > db2. > I can go around it with some php code to create the table in db2 but > thought it could be easier just to use the temporary table created by the > query on db1. > Even if the two servers are replicating temporary tables won't be available on the second host. You might be able to use the federated engine to accomplish what you're trying to do, but I doubt it.
