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 vote212 views1 answer
Postgres add prefix to primary key
SQL
2 votes231 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote216 views1 answer
How to convert DateTime to VarChar SQL
SQL
3 votes204 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
1 vote230 views1 answer
Raw query must include primary key
SQL
0 vote229 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
8 votes236 views2 answers
Mysql get first x characters
SQL
5 votes229 views1 answer
Oracle list days between two dates
SQL
4 votes225 views1 answer
Force drop all tables postgres
SQL
0 vote217 views2 answers
Postgresql create role
SQL