Hi Omni,
Thanks for the reply.
I know it couldn't be possible. I just wanted to hear opinions.
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.
Thanks
--------------------------------------------------
From: "Omni Adams" <[EMAIL PROTECTED]>
Sent: Friday, June 06, 2008 7:32 PM
To: <mysql@lists.mysql.com>
Subject: Re: Temp table on multiple connections
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 exist on db2
How can it be possible to use it on db2 queries ?
Temporary tables are locked down to just the current connection, so you
really can't. If you really need to use two connections to the same
database, you could create a regular table with a unique name every time
and
share it.
But why do you need two separate connections? Can you not do it in one?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
