数据库之联合查询
联合查询: 将多次查询(多条select语句),在记录上进行拼接(字段不会增加)
基本语法
多条select语句构成: 每一条select语句获取的字段数必须严格一致(但是字段类型无关)
select 语句1
union
select 语句2
Union选项 : 与select选项一样有两个
- All:保留全部(不管重复)
- Distinct:去重(整个重复):默认的
mysql> select * from teacher union all select * from teacher;
+----+------------+
| id | name |
+----+------------+
| 1 | 秦老师 |
| 2 | echoqian |
| 3 | xiaojiejie |
| 4 | dagege |
| 1 | 秦老师 |
| 2 | echoqian |
| 3 | xiaojiejie |
| 4 | dagege |
+----+------------+
8 rows in set (0.00 sec)
mysql> select * from teacher union select * from teacher;
+----+------------+
| id | name |
+----+------------+
| 1 | 秦老师 |
| 2 | echoqian |
| 3 | xiaojiejie |
| 4 | dagege |