好资源导航 » 文章资讯 » MySQL查询从多个选择语句获取结果？

MySQL查询从多个选择语句获取结果？

2024-05-10 15:09:03 373

要从多个select语句获取结果，请使用UNIONALL。以下是语法-

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)

返回顶部
3162201930
czq8825@qq.com

MySQL查询从多个选择语句获取结果？

热门推荐

随机推荐