Home > DeveloperSection > Interviews > What are HEAP tables in MySQL?

Posted on    February-10-2014 12:01 AM

 MYSQL MYSQL 
Ratings:
 1 Answer(s)
  1132  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Points:3910
Posted on    February-10-2014 1:00 AM

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.


Don't want to miss updates? Please click the below button!

Follow MindStick