Call Us : +91-8376986802 (Viber, WhatsApp)

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.

Leave a Reply