Interested to Buy Any Domain ? << Click Here >> for more details...
What are HEAP tables in MySQL?
- 1 Answers
- 12891 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 'mysqladmin' in mysql?
How many rows can be inserted in mysql at a time?
What are the other commands to know the structure of a table using mysql commands except explain command?
What is strict mode in mysql?
What do ddl, dml, and dcl stand for?
how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me
What is definer in mysql?
Explain triggers and stored procedures?
What are some good ideas regarding user security in MySQL?
How to dump one database for backup.
How to get nth highest salary from table in a mysql?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
-
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)
