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>