mysql - 连接表 MySQL

Question

如果我有以下表格

表 1:

+------+-----------+
| sex  | type      |
+------+-----------+
|  m   | rolls     |
|  f   | acom      |
+------+-----------+

tbl2:

+------+-----------+
| age  | type      |
+------+-----------+
| 12   | rolls     |
| 25   | acom      |
+------+-----------+

我如何创建一个 View 来显示合并的两个表，但性别和年龄成为类别

+-----------+-----------+
| category  | type      |
+-----------+-----------+
|    m      | rolls     |
|    f      | acom      |
|   12      | rolls     |
|   25      | acom      |
+-----------+-----------+

谢谢。

Answer 1

你可以使用union语句

SELECT `sex` as `category`,`type` FROM `tbl1`
UNION
SELECT `age` as `category`,`type` FROM `tbl2`