Merge table engine : Merge « Engine « SQL / MySQL

1. SQL / MySQL
2. Engine
3. Merge

Merge table engine

        
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>

   
    
    
    
    
    
    
    
  

Related examples in the same category