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

11 votes287 views1 answer
Oracle view source
SQL
0 vote288 views1 answer
Tsql delete all rows
SQL
1 vote280 views3 answers
How to update column name in psql
SQL
12 votes271 views2 answers
Delete entries in postgresql
SQL
1 vote260 views1 answer
Nested if in mysql
SQL
2 votes287 views1 answer
Sql OR
SQL
0 vote272 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
8 votes264 views1 answer
Insert a select statement into a table
SQL
2 votes279 views1 answer
How to insert string variable into sqlite database
SQL
8 votes284 views3 answers
Alter user root mysql
SQL