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

8 votes247 views1 answer
Oracle search code in packages
SQL
1 vote245 views1 answer
Spring postgresql reset auto increment to 0
SQL
-1 vote269 views2 answers
Sql search all tables for attributes
SQL
0 vote264 views1 answer
The fetch keyword oracle
SQL
0 vote227 views1 answer
Opensuse start MySQL
SQL
0 vote271 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote226 views1 answer
SQL Server format datetime
SQL
-2 votes238 views1 answer
Group functions in sql
SQL
0 vote267 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote226 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL