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

How can you validate emails using a single query?

672


Is mysql free for commercial use?

670


How would you get the current date in mysql?

863


What is csv?

730


Is mysql relational?

726


How do we use % when performing a search query?

728


What is RMS Migrations

2205


What are the three types of queries?

675


How to drop an existing table in mysql?

759


Is there a free version of mysql?

682


explain GROUPBY & HAVING clause with examples.

2047


Write command to import an mysql file?

730


Write a query to retrieve a hundred books starting from 20th.

1295


How do I tune a mysql query?

677


How many columns can a table have?

692