What Are Heap Tables In Mysql?

1.	What Are Heap Tables In Mysql?
Answer» HEAP tables are in-memory. They are usually used for high-speed temporary storage. No TEXT or BLOB fields are allowed within HEAP tables. You can only use the COMPARISON operators = and <=>. HEAP tables do not SUPPORT AUTO_INCREMENT. INDEXES must be NOT NULL. HEAP tables are in-memory. They are usually used for high-speed temporary storage. No TEXT or BLOB fields are allowed within HEAP tables. You can only use the comparison operators = and <=>. HEAP tables do not support AUTO_INCREMENT. Indexes must be NOT NULL.

Answer»

HEAP tables are in-memory. They are usually used for high-speed temporary storage. No TEXT or
BLOB fields are allowed within HEAP tables. You can only use the COMPARISON operators = and <=>. HEAP tables do not SUPPORT AUTO_INCREMENT. INDEXES must be NOT NULL.

HEAP tables are in-memory. They are usually used for high-speed temporary storage. No TEXT or
BLOB fields are allowed within HEAP tables. You can only use the comparison operators = and <=>. HEAP tables do not support AUTO_INCREMENT. Indexes must be NOT NULL.

Discussion

No Comment Found

Related InterviewSolutions

How To Increment Dates By 1111 Mysql?
How To Create A New View In Mysql?
How To Drop An Existing View In Mysql?
How To Drop An Existing Index In Mysql?
How To Get A List Of Indexes Of An Existing Table?
How To Create A Table Index In Mvsql?
How To Rename An Existing Table In Mysql?
How To Rename An Existing Column In A Table?
How To Delete An Existing Column In A Table?
How To Add A New Column To An Existing Table In Mysql?