Home >> MySql >> What is HEAP table in MySql

What is HEAP table in MySql

Heap table also known as Memory Storage Engine. Heap table is a special table with contents that are stored in memory because the data is vulnerable to crashes, hardware issues, or power outages, only use these tables as temporary work areas or read-only caches for data pulled from other tables.

Heap table are usually used for high-speed temprory storage.No TEXT or BLOB fields are allowed within Heap table.you can only use the comparision operators = and <=>.Heap table do not support auto-increment indexes  must be NOT NULL.

Post Your Comment

Next Questions
What is CSV table
What is MERGE table
What is federated table
What are data types
Numeric data types
Floating data types
Date and Time data types
String data types
Enum data types
SET data types
Difference between varchar and char
Difference between Tinyint and smallint
Difference between enum and set
Difference between signed and unsigned
What is key
What is super key
What is candidate key
What is primary key
What is unique key
What is foreign key
What is join
What is cross join
What is natural join
What is outer join
What is self join

Copyright ©2022 coderraj.com. All Rights Reserved.