Tables that are present in memory is known as HEAP tables. When you create a heap table in MySQL, you should need to specify the TYPE as HEAP. These tables are commonly known as memory tables. They are used for high-speed storage on a temporary basis. They do not allow BLOB or TEXT fields.

In MySQL, a “heap table” is another term for an in-memory table or a temporary table. It’s a table type that’s stored in memory rather than on disk, making it faster for certain operations. Heap tables are commonly used for storing temporary data that doesn’t need to be persisted beyond the current session or for optimizing specific queries. They’re typically created using the MEMORY storage engine in MySQL.