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 |
change column name and make a unique column so we get no dupes.
Use mysqldump to create a copy of the database?
What is mysqli_select_db?
please give me the answer for this: query which generates the second highest integer in the table?
Does mysql support sequence?
State the differences between mongodb and mysql.
What do ddl, dml, and dcl stand for?
What is meant by mysql database?
How do you start and stop MySQL on Windows?
How to shut down the server with 'mysqladmin'?
How to analyze tables with 'mysqlcheck'?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
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)