Create Temporary Table
A temporary table is a transient table that exists for the duration of a database session. Temporary tables are automatically dropped at the end of a session or transaction. CREATE TEMPORARY TABLE temp_table_name(column_list ); **A Temporary table is only visible to the session that created it. In other words, it is invisible to other sessions. … Create Temporary Table