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 vote298 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote273 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote288 views1 answer
On sql table data exists
SQL
0 vote326 views1 answer
How to check rollback status in oracle
SQL
0 vote316 views1 answer
Create user faunadb
SQL
4 votes291 views2 answers
Oracle unlock user
SQL
0 vote294 views1 answer
Automated psql csv export script on windows
SQL
7 votes280 views3 answers
Restore postgres database from sql file
SQL
2 votes302 views2 answers
Postgres trigger insert into another table
SQL
5 votes280 views3 answers
Day of week postgresql
SQL