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

1 vote237 views1 answer
Firebase bigquery cloud message
SQL
1 vote253 views1 answer
Postgres convert exisiting column to text
SQL
4 votes253 views1 answer
Create table if not exist in sqlite
SQL
0 vote295 views1 answer
Gcloud sql list databases
SQL
0 vote272 views1 answer
Python list from sql
SQL
1 vote244 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
0 vote264 views1 answer
Flexible search query delete table
SQL
0 vote271 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
28 votes283 views6 answers
Sql update
SQL
0 vote255 views1 answer
Oracle list user locked
SQL