Due to complex query needs and the lack of subqueries in the current production version of MySQL i have to use temporary tables, but there is almost no information about the behavior of them in the "manual.pdf" documentation file of mySQL database. Does any one know where to find more information about temporary tables?. The questions i would like to answer are:
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? Regards, FB