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 the latest version of mysql?
What are the advantages of mysql in comparison to oracle?
How do I disconnect mysql workbench?
How can you filter the duplicate data while retrieving records from the table?
What is difference between mysql_connect and mysql_pconnect?
What are the functions in mysql?
What is save point in mysql?
What is view? How can you create and drop view in mysql?
how to display nth highest salary from a table in a mysql query? : Mysql dba
How to set mysql variable in php?
What is an index? How can an index be declared in mysql?
How does mysql store data?
What is pdo connection?
Write a query to fetch common records between two tables using mysql?
What is mysql ndb?
