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

How do I disconnect mysql workbench?

0 Answers  


Can you save your connection settings to a conf file?

1 Answers  


Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

0 Answers  


What is mysqli_free_result?

0 Answers  


Explain the storage engines in mysql?

0 Answers  






What does mysql workbench do?

0 Answers  


What is database clustering in mysql?

0 Answers  


Is mysqli secure?

0 Answers  


Is sqlite faster than mysql?

0 Answers  


What is the use of mysqli_fetch_array?

0 Answers  


How to calculate expressions with sql statements?

0 Answers  


How can you make a database as your current database?

0 Answers  


Categories