要从多个 select 语句中获取结果,请使用 UNION ALL。以下是语法 -select yourValue1 AS anyColumnName UNioN ALL select yourValue2 AS yourC
要从多个 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)
--结束END--
本文标题: MySQL查询从多个select语句中获取结果?
本文链接: https://www.lsjlt.com/news/437717.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0