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 votes351 views1 answer
Oracle run_duration average
SQL
5 votes351 views1 answer
Get table columns from sql
SQL
0 vote345 views4 answers
Mysql count table rows
SQL
0 vote368 views1 answer
Mysql record group by created date count
SQL
1 vote349 views1 answer
Join first name and last name sql
SQL
7 votes370 views1 answer
Mysql remote connection command line
SQL
0 vote350 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
16 votes358 views3 answers
Update table from another table
SQL
3 votes318 views1 answer
Sql select all
SQL
1 vote315 views1 answer
Mysql select utc time in eastern time
SQL