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