Answer Posted / hrindows@gmail.com
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 |
Post New Answer View All Answers
How is myisam table stored?
How to set the time zone for MySQL to particular country time?
How to get the number of rows selected or affected by a sql statement?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
How do I use mysql?
What is heap table in mysql?
Write a command to list all databases in mysql?
What is datatype in mysql?
How to change the database engine in mysql?
Differentiate CHAR_LENGTH and LENGTH?
How to store binary data in mysql?
How to include numeric values in sql statements?
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
why not null is not allowed at table level
What are the different types of triggers in mysql?