January 2019
Intermediate to advanced
286 pages
7h 41m
English
The MERGE storage engine is a collection of identical MyISAM tables (where identical column and indexes are in the same order), which can be used as the same table. This is an interesting storage engine. When we have a large amount of data but want to store it in smaller chunks, it's best to use the MERGE storage engine. The MERGE storage engine usually only applies to large databases. Note that a DROP table only deletes a merge specification—original tables are not altered:
CREATE TABLE alldata (no INT NOT NULL, student_name CHAR(40)) ENGINE = MERGE UNION = (data1, data2, data3) INSERT_METHOD = LAST;Query OK, 0 rows affected (0.09 sec)
In the preceding command, assume that data1, data2, and data3 all have the same ...
Read now
Unlock full access