Temporary tables in mysql

Question: What is temporary table and how to create temporary table in mysql

Answer:

Mysql Temporary tables are special kind tables it will be deleted when the script finishes its execution

To create temporary table use the command

CREATE TEMPORARY TABLE table_name (select mail_id,answer from interview_question)

If you want to delete the temporary table means

DROP TEMPORARY TABLE IF EXISTS table_name