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

6 votes309 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote348 views2 answers
Sql auto update dupdated_at
SQL
0 vote373 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote334 views2 answers
Oracle select
SQL
0 vote339 views2 answers
Default constraint in ms sql
SQL
2 votes342 views1 answer
Sql server current date minus 5 years
SQL
0 vote333 views2 answers
Postgresql change user role grant
SQL
0 vote298 views1 answer
Oracle list dblink
SQL
0 vote332 views1 answer
Query params sql insert python f string
SQL
0 vote336 views1 answer
Mysql page segment
SQL