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
How can you validate emails using a single query?
Is mysql free for commercial use?
How would you get the current date in mysql?
What is csv?
Is mysql relational?
How do we use % when performing a search query?
What is RMS Migrations
What are the three types of queries?
How to drop an existing table in mysql?
Is there a free version of mysql?
explain GROUPBY & HAVING clause with examples.
Write command to import an mysql file?
Write a query to retrieve a hundred books starting from 20th.
How do I tune a mysql query?
How many columns can a table have?
