從多個 select 語句中獲取結果的 MySQL 查詢？

若要從多個 select 語句中獲取結果，請使用 UNION ALL。以下是語法 -

select yourValue1 AS anyColumnName
UNION ALL
select yourValue2 AS yourColumnName
.
.
.
.
N

讓我們實現上述語法，以便逐行返回數字列表 -

mysql> select 100 AS Number
   UNION ALL
   select 1000 AS Number
   UNION ALL
   select 10000 AS Number
   UNION ALL
   select 100000 AS Number
   UNION ALL
   select 1000000 AS Number
   UNION ALL
   select 10000000 AS Number
   UNION ALL
   select 100000000 AS Number
   UNION ALL
   select 1000000000 AS Number;

這將產生以下輸出 -

+------------+
| Number     |
+------------+
|        100 |
|       1000 |
|      10000 |
|     100000 |
|    1000000 |
|   10000000 |
|  100000000 |
| 1000000000 |
+------------+
8 rows in set (0.00 sec)

AmitDiwan

更新於: 03-Sep-2019

639 次瀏覽

開啟您的 職業 生涯

透過完成該課程獲得認證

開始學習