MySQL temp table

MySQL temp table: Generally used for stored procedures, temporary presence, after use of the system automatically cleared, efficiency than the normal table faster.
Useful: Use temporal tables for data that is repeatedly required for the lookup of the table.

--Create a temporary tableCREATE Temporary TABLE IF  not EXISTSeval_processevaldetail_tmp (StudentIDVARCHAR( -) not NULL, TotalbadgecountINT)--to add an index to a staging tableCREATE INDEXEval_processevaldetail_tmp_stuid oneval_processevaldetail_tmp (StudentID);--Delete temporary tableDROP TABLE IF EXISTSeval_processevaldetail_tmp;--Clear temporary table dataTRUNCATE TABLEeval_processevaldetail_tmp;

MySQL temp table