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

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.