Organizational Research By

Surprising Reserch Topic

What are HEAP tables in MySQL?


  1.     HEAP tables are in-memory. They are usually used for high-speed temporary storage.
  2.     No TEXT or BLOB fields are allowed within HEAP tables.
  3.     You can only use the comparison operators = and ‹=›.
  4.     HEAP tables do not support AUTO_INCREMENT.
  5.     Indexes must be NOT NULL.
asked Sep 13, 2013 in PHP by rajesh
edited Sep 12, 2013
0 votes
24 views



Related Hot Questions



Government Jobs Opening


...