Ask a Question
Advertise on boostr.in
What are HEAP tables in MySQL?
Â Â 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.
Sep 13, 2013
Sep 12, 2013
to add a comment.
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please