how to work on temporary table in mysql

 

Sure. Temporary tables were added in MySQL version 3.23. If you use an older version of MySQL than 3.23, you can't use temporary tables, but you can use heap tables. 

 

Below links are helpful to your to get better insight on "Temporary" tables.

 

 

http://stackoverflow.com/questions/5859391/create-a-temporary-table-in-a-select-statement-without-a-separate-create-table 

 

If you want more on this  you could follow the below google search:

 

 

Hope this helps!