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

3 votes162 views1 answer
Sql print all names that start with a given letter
SQL
0 vote199 views1 answer
SQL joins in python
SQL
0 vote154 views1 answer
How to select all fieldsin a soql query
SQL
0 vote155 views1 answer
Change date format in oracle query
SQL
0 vote154 views1 answer
Oracle create table auto generated primary key
SQL
0 vote169 views1 answer
Postgres - Login and connect as default user
SQL
0 vote145 views1 answer
Psql check if value in array
SQL
1 vote157 views2 answers
Snowflake alter column data type
SQL
5 votes199 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
10 votes154 views4 answers
Sql pagination
SQL