1CREATE PROCEDURE my_proc ()
2BEGIN
3
4CREATE TEMPORARY TABLE TempTable (myid int, myfield varchar(100));
5INSERT INTO TempTable SELECT tblid, tblfield FROM Table1;
6...
7-- Temporary tables in MySQL only exist for the duration of the connection
8-- and only for the connected user, unlike MSSQL where they persist across
9-- sessions and connections.