HEAP tables are in-memory. They are usually used for high- speed temporary

What are HEAP tables in MySQL?

Question Posted / amith

1 Answers
12984 Views
I also Faced
E-Mail Answers

Answer Posted / amith

HEAP tables are in-memory. They are usually used for high-
speed temporary storage. No TEXT or BLOB fields are allowed
within HEAP tables.

we can only use the comparison operators = and <=>. HEAP
tables do not support AUTO_INCREMENT. Indexes must be NOT
NULL.

Is This Answer Correct ?

15 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I view mysql logs?

889

How do I install mysql workbench?

911

How do I save in mysql?

970

Do you need a license for mysql?

943

What is mysql architecture?

1010

How do I change mysql password?

1022

Does mysql use sql?

897

How can you export the table as an xml file in mysql?

890

How to filter data from a mysql database table with php?

905

What are the different mysql database engines?

1164

What is the maximum size of table in mysql?

1030

How to write optimized query in mysql?

990

What is a delimiter in mysql?

1034

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4676

Is mysql owned by oracle?

1019