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 vote300 views1 answer
Order child below the parent in mysqli
SQL
13 votes260 views5 answers
Oracle list tables
SQL
0 vote309 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote278 views1 answer
Running query in redshift
SQL
0 vote280 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote310 views1 answer
How to pass list as parameter in SQL query
SQL
3 votes272 views3 answers
Your password does not satisfy the current policy requirements
SQL
11 votes304 views3 answers
Python sqlite3 create table if not exists
SQL
21 votes285 views4 answers
Add column mssql
SQL
5 votes303 views1 answer
Sql integer to serial
SQL