Create view for union : Union « Select Clause « SQL / MySQL

1. SQL / MySQL
2. Select Clause
3. Union

Create view for union

   
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>
mysql>
mysql>
mysql> CREATE VIEW PENALTIES_ALL AS
    -> SELECT * FROM PENALTIES_1990
    -> UNION
    -> SELECT * FROM PENALTIES_1991
    -> UNION
    -> SELECT * FROM PENALTIES_1992;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>
mysql> drop view PENALTIES_ALL;
Query OK, 0 rows affected (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>

   
    
    
  

Related examples in the same category