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's the difference between mysql and sql server?
What are the advantages of mysql in comparison to oracle?
How do I backup mysql database on linux?
What is database engine in mysql?
Can I install mysql on mac?
What are the difference between now and current_date in mysql?
How do you rename a procedure in mysql?
What is a tinyint in mysql?
What is difference between pdo and mysqli?
How does mysql encrypt passwords?
What is an example of a delimiter?
Is mysqli secure?
Where the database is stored in mysql?
How you will Show unique records.
What is the limitation of mysql?