Page 1 of 1

temporary tables / mysql

Posted: Mon May 11, 2009 5:58 am
by kevin_zer0
hello there 8O
i have a question about temporary tables in mysql
i want to know if i have a query in my php code that makes mysql create a temporary table each time , what happens if two or three (or more!) users execute that code simultaneously ? i mean what happens to my mysql tables ? will there be an error saying 'table name already exist' ?
please help
thank you :mrgreen:

Re: temporary tables / mysql

Posted: Thu May 14, 2009 3:55 pm
by Darhazer
No, there won't be such error. The temporary table will exist only for the current connection, so another connection can use the same name. Think like each connection is a separate namespace

Re: temporary tables / mysql

Posted: Sat May 23, 2009 12:19 am
by kevin_zer0
thank you dear 'Darhazer' :) you solved my problem