What are Heap tables?
- 1 Answers
- 837 Views
- I also Faced
- E-Mail Answers
Heap tables are in-memory tables used for high-speed temporary storage. But, TEXT or BLOB fields are not allowed within them. They also do not support AUTO INCREMENT.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is current version of mysql?
How can we run batch mode in mysql?
Why is mysql popular?
How can we find out which auto increment was assigned on Last insert?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
How to delete an existing column in a table?
How we get sum of column.
What is mysql routine?
How many ways we can we find the current date using MySQL?
What is the difference between mysql_fetch_array() and ysql_fetch_object() ?
How can we repair a MySQL table?
-
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)
