Temporary Table on MySQL

[aas1611]

Does anybody know how to create a temp table on MySQL without creating it on the database?

in MS SQL it has something like:

select ...
into #T1 -- this is a temp table
from ...

then, I want to call this #T1 later on the same query window.

Is there an equal command in MySQL?

Please help!

 

[TonyGroves]

You could use:
[tt]
CREATE TEMPORARY TABLE temptbl AS
SELECT ...
[/tt]
The table will be created in memory and dropped when the connection ends.

 

[ericbrunson]

Temporary tables also have the benefit of being in an isolated namespace. So multiple users in the same database can create temp tables of the same name at the same time without interfering with each other.