Mysql table variables

CREATE PROCEDURE my_proc () 
BEGIN

CREATE TEMPORARY TABLE TempTable (myid int, myfield varchar(100)); 
INSERT INTO TempTable SELECT tblid, tblfield FROM Table1; 
...
-- Temporary tables in MySQL only exist for the duration of the connection 
-- and only for the connected user, unlike MSSQL where they persist across 
-- sessions and connections.

Source: stackoverflow.com

Similar codes

0 vote341 views1 answer
Group by two columns postgres
SQL
0 vote333 views1 answer
How many rows affected in sqllite
SQL
0 vote315 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote343 views1 answer
Top frequency in sql server
SQL
0 vote336 views1 answer
Mysql subdate
SQL
22 votes370 views4 answers
Date format mysql
SQL
1 vote338 views1 answer
Right outer vs left outer join
SQL
1 vote321 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote322 views1 answer
Call procedure in wordpress
SQL
4 votes353 views2 answers
Float postgres
SQL