MySql将两个列合并为一个新列

Question

我有一个带有MySQL表的如下结构。

+----------------+----------------+
|    data 1      |      data2     |
+----------------+----------------+
|     1          |     2          |
+----------------+----------------+

我想将以上两列合并为一列，如下所示：

+---------------------+
|      data           |
+---------------------+
|          1          |
+---------------------+
|          2          |
+---------------------+

无论如何，谢谢您的帮助:)

Answer 1

使用UNION

SELECT data1 AS data FROM yourTable
UNION ALL
SELECT data2 AS data FROM yourTable

Answer 2

使用UNION -如果希望合并列具有distinct值，则使用UNION All

SELECT data1 AS data FROM yourTable
UNION
SELECT data2 AS data FROM yourTable