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
What is auto increment in mysql?
What is a storage engine?
What's the latest version of mysql?
How we can get distinct columns values in mysql?
What is a mysql server?
What is the difference between timestamp and datetime in mysql?
How do I download mysql?
What is difference between mysql and mysql server?
Can we write procedure in mysql?
What is relational database in mysql?
What are the other commands to know the structure of a table using mysql commands except explain command?
How to check if a record exists in a mysql database php?
How do I delete a table in mysql workbench?
What is procedural api?
can you elaborate on blob and text in mysql? : Mysql dba
