Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> CREATE DATABASE asd;
- Query OK, 1 row affected (0.48 sec)
- mysql> SELECT table_name,table_comment FROM INFORMATION_SCHEMA.tables WHERE table_schema='asd';
- Empty set (0.05 sec)
- mysql> USE asd;
- Database changed
- mysql> CREATE TABLE ukraine (
- -> name CHAR(30) NOT NULL);
- Query OK, 0 rows affected (0.84 sec)
- mysql> INSERT INTO ukraine VALUES ('Kiev'),('Lvov'),('Kharkov'),('Poltava');
- Query OK, 4 rows affected (0.15 sec)
- Records: 4 Duplicates: 0 Warnings: 0
- mysql> SELECT * FROM ukraine;
- +---------+
- | name |
- +---------+
- | Kiev |
- | Lvov |
- | Kharkov |
- | Poltava |
- +---------+
- 4 rows in set (0.00 sec)
- mysql> CREATE TABLE russia (
- -> name CHAR(30) NOT NULL);
- Query OK, 0 rows affected (0.25 sec)
- mysql> INSERT INTO russia VALUES ('Moskva'),('Belgorod'),('Krasnodar'),('Sochi');
- Query OK, 4 rows affected (0.11 sec)
- Records: 4 Duplicates: 0 Warnings: 0
- mysql> SELECT * FROM russia;
- +-----------+
- | name |
- +-----------+
- | Moskva |
- | Belgorod |
- | Krasnodar |
- | Sochi |
- +-----------+
- 4 rows in set (0.00 sec)
- Объединяю с помощью UNION
- mysql> (SELECT * FROM ukraine) UNION (SELECT * FROM russia);
- +-----------+
- | name |
- +-----------+
- | Kiev |
- | Lvov |
- | Kharkov |
- | Poltava |
- | Moskva |
- | Belgorod |
- | Krasnodar |
- | Sochi |
- +-----------+
- 8 rows in set (0.00 sec)
- mysql> (SELECT * FROM ukraine ORDER BY name) UNION (SELECT * FROM russia);
- +-----------+
- | name |
- +-----------+
- | Kiev |
- | Lvov |
- | Kharkov |
- | Poltava |
- | Moskva |
- | Belgorod |
- | Krasnodar |
- | Sochi |
- +-----------+
- 8 rows in set (0.00 sec)
- mysql> (SELECT * FROM ukraine) UNION (SELECT * FROM russia ORDER BY name);
- +-----------+
- | name |
- +-----------+
- | Kiev |
- | Lvov |
- | Kharkov |
- | Poltava |
- | Moskva |
- | Belgorod |
- | Krasnodar |
- | Sochi |
- +-----------+
- 8 rows in set (0.00 sec)
- mysql> (SELECT * FROM ukraine) UNION (SELECT * FROM russia) ORDER BY name;
- +-----------+
- | name |
- +-----------+
- | Belgorod |
- | Kharkov |
- | Kiev |
- | Krasnodar |
- | Lvov |
- | Moskva |
- | Poltava |
- | Sochi |
- +-----------+
- 8 rows in set (0.00 sec)
- SELECT ....
- UNION
- SELECT ....
- UNION
- SELECT ....
- UNION
- SELECT ....
- INSERT INTO `temp` SELECT .....;
- INSERT INTO `temp` SELECT .....;
- INSERT INTO `temp` SELECT .....;
- INSERT INTO `temp` SELECT .....;
- SELECT * FROM `temp`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement