What are HEAP tables in MySQL?

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 mysql url?

473


Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

510


Which command is used to view the content of the table in mysql?

490


What is mysql connector used for?

510


How do you shutdown a mysql database?

492






Is mysql case-sensitive?

488


What is the latest mysql version?

468


How do I import database through command line?

494


Is mysql deprecated?

458


How do I find mysql database?

480


How many rows can a mysql table hold?

497


What are slow queries?

474


If we use sum function in mysql, does it return sum of that row or for that column?

524


What can I do with mysql?

498


What are the technical features of MySQL?

577