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 do I view mysql logs?
How do I install mysql workbench?
How do I save in mysql?
Do you need a license for mysql?
What is mysql architecture?
How do I change mysql password?
Does mysql use sql?
How can you export the table as an xml file in mysql?
How to filter data from a mysql database table with php?
What are the different mysql database engines?
What is the maximum size of table in mysql?
How to write optimized query in mysql?
What is a delimiter in mysql?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
Is mysql owned by oracle?