mysql - 将两列排序为一列

Question

假设我有一张 table - 人

id | First Name  | Last Name
-----------------------------'
1    AA             BB
2    EE             DD
3    CC             FF

在这里，我想在 1 列中显示名字和姓氏。

Such that output would be 
----------------------
AA
BB
CC
DD
EE
FF

Can i also display it as 
------------------
1 AA
1 BB
3 CC
2 DD
2 EE
3 FF

使用Mysql查询??

Answer 1

您正在寻找union all:

select first_name as name from persons union all
select last_name from persons
order by name;

编辑:

对于修改后的问题:

select id, first_name as name from persons union all
select id, last_name from persons
order by name;