> At 23:19 +0000 3/4/03, Mamatha Balasubramanian wrote:
>>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
Probably even better to have the Drop Table at the end of the script that
used it.
>>
>>
>>
>>>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
>
>


William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061




---------------------------------------------------------------------
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

Reply via email to