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

2 votes160 views1 answer
Sql OR
SQL
6 votes131 views4 answers
Delete table sqlite
SQL
0 vote210 views1 answer
Trigger
SQL
0 vote134 views1 answer
Sql show all users
SQL
0 vote130 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote133 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote139 views1 answer
Kill a pid redshift
SQL
0 vote170 views1 answer
Mysql trigger to delete old data
SQL
18 votes155 views6 answers
Laravel form validation
SQL
0 vote134 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL