Hello Guys, Today we will discuss on the HEAP tables in MySQL. HEAP tables are present in memory and they are used for high-speed storage on the temporary basis.You need to specify the type while at creation. Basically, heap tables are also called memory tables.If the Mysql Database crashed then you will loose all data stored in the heap tables.
mysql> CREATE TABLE test_table_heap TYPE = HEAP SELECT ip, SUM(downloads) AS down FROM log_table GROUP BY ip;
mysql> SELECT COUNT(ip), AVG(down) FROM test_table_heap;
mysql> DROP TABLE test_table_heap;
BLOB and TEXT type of data storage are not…