What are HEAP tables in MySQL?
Answer / 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 |
what are the different tables present in mysql? : Mysql dba
Is mysql port 3306 tcp or udp?
Can you tell which of the following where clauses is faster?
What is the maximum size of mysql database?
What is not null in mysql?
Explain GRANT command in MySQL.
what is collation? how many types of installations in sql server?
Is mysql a scripting language?
What are date and time data types in mysql?
How do I select a table in mysql?
Can foreign key have duplicate values?
What is triggers and how it can be used in mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)