Interested to Buy Any Domain ? << Click Here >> for more details...
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 move the master database
How to enter boolean values in sql statements?
What causes mysql too many connections?
What is the command used to create a database using php and mysql?
What is a longblob?
Explain the difference between mysql_fetch_array(), mysql_fetch_object()?
What are triggers in mysql?
Should I use pdo or mysqli?
How can you calculate the sum of any column of a table?
How to enter binary numbers in sql statements?
What is the difference between truncate and delete?
Can you tell what are various ways to create an index?
How do I change global variables in mysql?
How to calculate the difference between two time values?
What is mysql workbench used for?
