Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

What are HEAP tables in MySQL?

Nice?Vote!

1 Answer

Nice?Vote!
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.
answered 1 year ago by R (19,530 points)

Related questions