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

3 votes201 views1 answer
Query less than datetime sql
SQL
0 vote161 views1 answer
Drop database using terminal postgres
SQL
2 votes158 views1 answer
Oracle to_char number format percentage
SQL
3 votes200 views3 answers
Restart mysql mac
SQL
0 vote148 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote143 views1 answer
Mysql money value
SQL
0 vote148 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote158 views1 answer
Oracle cpu metric
SQL
0 vote157 views1 answer
Postgres can integer fields be negative
SQL
6 votes158 views3 answers
Commit in sql
SQL