mysql table variables

Solutions on MaxInterview for mysql table variables by the best coders in the world

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
showing results for - "mysql table variables"
Lisa
13 Aug 2017
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.