Question: what are the differences between heap table and temporary table in mysql?
Answer: When creating a HEAP table in MySql, user needs to specify the TYPE as HEAP. These tables are now more commonly known as memory tables. These memory tables never have values with data type like “BLOB” or “TEXT”. ... Temporary table is that they will be deleted when the current client session terminates.