This article is half-done without your Comment! *** Please share your thoughts via Comment ***
I already shared a article on HEAP Table. I discussed Memory Storage Engine of MySQL.
After discussing this topic, there is a confusion.
What is the difference between Temporary Table and Memory Table?
The main difference is, Temporary Table is only for running current session.
Once the session completed its execution, Temporary Table will discard from memory.
You cannot use Temporary Table for multiple sessions.
As we previously discussed, that Memory Table can hold data for across all running sessions and connections.
Temporary Table stores all data and table definition in an interim disk file.
Memory Table stores all data into Memory and stores table definition into .frm disk file.
Temporary Table can also store all data into memory, but for that, you have to create a Temporary Table using Memory Engine.