At 23:00 +0000 3/4/03, Mamatha Balasubramanian wrote:
>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
You can create multiple temporary tables, but they must have different
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.