What are HEAP tables in MySQL?
- 1 Answers
- 12315 Views
- I also Faced
- E-Mail Answers
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 is mysql slow query?
Does mysql use tcp or udp?
What is the difference between mysql_fetch_array() and ysql_fetch_object() ?
How do I install mysql?
What are triggers mysql?
What are federated tables?
How do you change a password for an existing user via mysqladmin?
how we will Show selected records sorted in an ascending (asc) or descending (desc).
What is text in mysql?
What is procedural api?
How many rows can mysql hold?
How do I free up space in mysql?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
