Thank you once again.
I have a web-interface that does search on a given text and I would have a script that creates a temporary table. So according to you, in my script, I just to need
create a temporary table and not have to worry about another client using the same web interface (and thereby using the same program). Can you please elaborate a little more on this?
Sure.
You are incorrect. :-)
That is, you're making an assumption that cannot necessarily be made. If you can guarantee that the web script will establish a new connection, and the connection will terminate when the script ends, you can indeed do what you describe above.
But you *cannot* do that if you're running your script in an environment that uses persistent connections that may be used by successive instances of the script. PHP persistent connections fall into this class, for example. Several requests might be served by the same instance of the web server process, and you don't know that one request won't be getting the connection used by a previous request. In that case, the connection won't have closed, and the TEMPORARY table won't have disappeared.
You can guard against this by issuing this query before creating the TEMPORARY table:
DROP TABLE IF EXISTS tbl_name
Thanks, Mamatha
From: Paul DuBois <[EMAIL PROTECTED]>
To: "Mamatha Balasubramanian" <[EMAIL PROTECTED]>,[EMAIL PROTECTED]
Subject: Re: Temporary Tables
Date: Tue, 4 Mar 2003 17:06:30 -0600
At 23:00 +0000 3/4/03, Mamatha Balasubramanian wrote:Hi, I would like to know how MySQL handles multiple temporary tables?
1. Can multiple temporary tables be created at the same time?
2. If so, how does MySQL differentiate them - do we need to explicitly give them different names inorder to identify them or does MySQL provide a timestamp (or use some other means) to identify the tables?
You can create multiple temporary tables, but they must have different names.
A TEMPORARY table can have the same name as a non-TEMPORARY table. The non-TEMPORARY table is hidden to the client that creates the TEMPORARY table as long as the TEMPORARY table exists. A second TEMPORARY table with the same name cannot be created.
This is on a connection-specific basis. Two clients each can create a TEMPORARY table with the same name. Only the table created by a given client is visible to that client.
I use MySQL 4.0.7 on Red Hat.
Thanks, Mamatha
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
