How to create a unique temp table then automatically remove after the join?
778463Jun 10 2010 — edited Jun 10 2010i have many users simultaneously accessing the web apps.
my problem is on how to solve the SELECT WHERE IN('..') clause..
i've read a lot of threads that with the same option..
1) open connection and start transaction
2) create temp table
3) insert the data (batch insert)
4) do the main goal. SELECT JOIN or SELECT WHERE IN(SUBQUERY).
5) end transaction and close connection
how do I assure that the created temp table was remove/drop upon 5) ?
thanks a lot..