MySQL

295 guides

keyboard_arrow_down

Other math topics

Dagster

Pandas

NumPy

Matplotlib

PySpark

MySQL

chevron_leftGeneral table Cookbook

Showing all the fields of a table Deleting a table Showing all tables Creating a table Cloning a table Finding all tables with a specific column name Removing a temporary table Renaming a table Creating a temporary table Restoring a table from an sql file Backing up a table

check_circle

Mark as learned

thumb_up

thumb_down

chat_bubble_outline

Comment

auto_stories Bi-column layout

settings

Removing a temporary table in MySQL

schedule Aug 11, 2023

Last updated

local_offer

MySQL

Tags

tocTable of Contents

expand_more

Example

mode_heat

Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!

A temporary table will automatically be dropped at the end of a session, however, you can also explicitly remove it using the following syntax:


        
        
            
                
                
                    DROP TEMPORARY TABLE table_name;

Example

To explicitly drop a temporary table called temp1:


        
        
            
                
                
                    DROP TEMPORARY TABLE temp1;
                
            
            Query OK, 0 rows affected (0.00 sec)

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!