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
using primary can we relate two table, with out foreign key?
Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba
What happens if you no create privilege in a database?
How to update info already in a table and delete a row(s) from a table.
Is mysql same as mariadb?
Is mysql query case sensitive?
How to include character strings in sql statements?
What are the 3 main types of search queries?
Where is mysql installed on linux?
How to check server status with 'mysqladmin'?
What is a deterministic function?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
What is mysql server used for?
Can you tell how to find the number of rows in a resultset using php?
Is oracle better than mysql?
