On Thu, 25 Sep 2003 02:26:28 -0600 [EMAIL PROTECTED] wrote: > 1) What happens if two (or more) users create a temporary table with the > same name at the same time? > 2) If i don't drop the tables, when are the tables droped by the server? > 3) what are the memory and or performance issues of temporary tables? > 4) Can i use session based temporary tables?
http://www.mysql.com/doc/en/CREATE_TABLE.html The temporary table is visible only to the current connection, and will be deleted automatically when the connection is closed. This means that two different connections can both use the same temporary table name without conflicting with each other or with an existing table of the same name. (The existing table is hidden until the temporary table is deleted.) From MySQL 4.0.2 on, you must have the CREATE TEMPORARY TABLES privilege to be able to create temporary tables. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
