What are HEAP tables in MySQL?
- 1 Answers
- 12497 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 |
Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.
In PHPmysql language how can we update our previous information.when update form open then we get our previous information in textbox,checkbox,selct,radio button.How can we show the information in checkbox,select menu,radio button which is available in database?
Is SET Command is SQL Statement..?
What is prepare statement in mysql?
How do I restart mysql on windows?
What are aggregate functions in mysql?
What are the advantages of mysql in comparison to oracle?
How to delete an existing column in a table?
What is delimiter in mysql trigger?
What is pdo in php mysql?
What is the purpose of using ifnull() function?
Can a table have multiple primary keys?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
