What are Heap tables?



What are Heap tables?..

Answer / 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

More MySQL Interview Questions

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

0 Answers  


What are the different mysql database engines?

0 Answers  


How to enter Characters as HEX Numbers?

0 Answers  


How we can get the current date in mysql?

0 Answers  


What is mysql vs sql?

0 Answers  


How does mysql clustering work?

0 Answers  


What is triggers and how it can be used in mysql?

0 Answers  


What is data type for image in mysql?

0 Answers  


How to include numeric values in sql statements?

0 Answers  


How to increment dates by 1 in mysql?

0 Answers  


Where is the myisam table stored?

0 Answers  


How to rename an existing table in mysql?

0 Answers  


Categories