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 votes193 views3 answers
Python sqlite3 create table if not exists
SQL
6 votes179 views3 answers
How to delete table sqlite
SQL
6 votes190 views2 answers
How to get yesterday date in mysql
SQL
0 vote195 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote180 views3 answers
Magento 2 order delete from db
SQL
0 vote163 views1 answer
Mysql database is not starting in xampp
SQL
0 vote169 views3 answers
Between keyword sql
SQL
0 vote177 views1 answer
Get number of tables in database sql
SQL
1 vote164 views1 answer
Clear screen command in psql
SQL
8 votes171 views2 answers
Mysql query dates between two dates
SQL