MySQL
keyboard_arrow_down 295 guides
chevron_leftGeneral table Cookbook
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
auto_stories new
settings
Removing a temporary table in MySQL
schedule Mar 5, 2023
Last updated local_offer
Tags MySQL
tocTable of Contents
expand_more Check out the interactive map of data science
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
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!