Temporary tables could be very useful to keep temporary data. Temporary tables option is available in MySQL version 3.23 and above.
Temporary table will be automatically destroyed when the session ends or connection is closed. The user can also drop temporary table.
Same temporary table name can b...
Drop Temporary Table is used to delete the temporary table which you are created in your current session.
DROP TEMPORARY TABLE tempTable1
DROP TEMPORARY TABLE IF EXISTS tempTable1
Use IF EXISTS to prevent an error occurring for tables that may not exist
