What are Heap tables?

Answer Posted / hrindows@gmail.com

Heap tables are in-memory tables used for high-speed temporary storage. But, TEXT or BLOB fields are not allowed within them. They also do not support AUTO INCREMENT.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How set mysql root password?

494


How do I start mysql database?

480


What are the technical features of MySQL?

583


How do I install mysql workbench?

484


What is longblob in mysql?

528






How do I start mysql from command line?

513


How to rename an existing table in mysql?

540


What is full form of xampp?

547


What is the use of mysqli_fetch_array?

484


How many rows mysql can handle?

518


What is difference between group by and order by clause?

548


What is full text indexing in mysql?

477


What is a mysql model?

501


How can you change the name of any existing table by using the sql statement?

517


how to display nth highest salary from a table in a mysql query? : Mysql dba

578