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
I have this problem
I connect to 2 database servers in the same script
If I create a temp table on one, won't be able on the other
$db1 = db_connect1();
$db2 = db_connect2();
$query = CREATE TEMPORARY TABLE temp_table SELECT ..;
$result = mysql_query($query,$db1) or
On Fri, Jun 6, 2008 at 2:28 PM, TUT - LightSpeed [EMAIL PROTECTED] wrote:
I have this problem
I connect to 2 database servers in the same script
If I create a temp table on one, won't be able on the other
$db1 = db_connect1();
$db2 = db_connect2();
I get error that temp_table doesn't
to create the table in db2 but thought
it could be easier just to use the temporary table created by the query on
db1.
Thanks
--
From: Omni Adams [EMAIL PROTECTED]
Sent: Friday, June 06, 2008 7:32 PM
To: mysql@lists.mysql.com
Subject: Re: Temp table