Mega Code Archive
Merge table engine
<![CDATA[
mysql>
mysql> CREATE TABLE PENALTIES_1990
-> (PAYMENTNO INTEGER NOT NULL PRIMARY KEY)
-> ENGINE=MYISAM
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO PENALTIES_1990 VALUES (1),(2),(3)
-> ;
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> CREATE TABLE PENALTIES_1991
-> (PAYMENTNO INTEGER NOT NULL PRIMARY KEY)
-> ENGINE=MYISAM
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO PENALTIES_1991 VALUES (4),(5),(6)
-> ;
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> CREATE TABLE PENALTIES_1992
-> (PAYMENTNO INTEGER NOT NULL PRIMARY KEY)
-> ENGINE=MYISAM
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO PENALTIES_1992 VALUES (7),(8),(9);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> CREATE TABLE PENALTIES_ALL
-> (PAYMENTNO INTEGER NOT NULL PRIMARY KEY)
-> ENGINE = MERGE
-> UNION = (PENALTIES_1990,PENALTIES_1991,PENALTIES_1992)
-> INSERT_METHOD = NO
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT * FROM PENALTIES_ALL;
+-----------+
| PAYMENTNO |
+-----------+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
+-----------+
9 rows in set (0.00 sec)
mysql>
mysql> drop table penalties_1990;
Query OK, 0 rows affected (0.00 sec)
mysql> drop table penalties_1991;
Query OK, 0 rows affected (0.00 sec)
mysql> drop table penalties_1992;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> drop table penalties_all;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>
]]>