MYSQL Temporary tables is the functionality provided by various RDBMS. This is used to create temporary tables which provide same funtionalities as of regular tables such as SELECT, UPDATE, INSERT, DELETE options but for the current logged in session only.

Temporary tables acts very useful when we need to operate some operation on temporary data for temporary cases. As we know temporary tables only exist for the current logged in session in database so you will not find you temporary table once you log out and login again.




If you want to add more comments to the article or you see any thing incorrect please write a comment below and we will surely get back to you.



Trending Articles


Incorrect table definition there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

Web Server vs Application Server Difference Explained

Infix To Postfix Conversion Using Stack in Javascript

SQL Overview

Binary Search Tree Insert node Implementation in Javascript

Evaluate Postfix Expressions Using Stack In Javascript

Linked List Size or Count in Javascript

MYSQL Dump - How to take mysql dump or export mysql data