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

What are HEAP tables in MySQL?

Question Posted / amith

1 Answers
12998 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

What is current version of mysql?

985

Can you tell few best practices to be followed for optimization in sql?

927

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2130

Is mysql server free?

938

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

1102

How to execute mysql query in php?

929

How we can get the current date in mysql?

970

Why do we use the mysql database server?

1060

What are the drivers in MySQL?

1479

What is the use of innodb in mysql?

996

What is dump in mysql?

898

What is ndb in mysql?

976

What is data in mysql?

911

What is a data directory?

956

What is difference between microsoft sql and mysql?

1007