Question

关于MySQL储存过程多个结果集如何合并

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp`()
BEGIN
SELECT 1 AS A;
SELECT 2 AS A;
END

当前call的结果如下
mysql> call sp();
+---+
| A |
+---+
| 1 |
+---+
1 row in set
+---+
| A |
+---+
| 2 |
+---+
1 row in set
Query OK, 0 rows affected

想要的结果
mysql> call sp();
+---+
| A |
+---+
| 1 |
+---+
| 2 |
+---+
2 row in set
Query OK, 0 rows affected

请问这个该如何操作呢?

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励30（财富值+成长值）

Answer 1

如果字段相同, 可以直接用 UNION ALL 合并

select a, b,c from tableA where 条件A
union all
select a,b,c from tableA where 条件B
union all
......

Answer 2

相关修改逻辑 与语句 查询用户ID，订单ID
select userID,orderID FROM userrun WHERE begindatetime="0000-00-00 00:00:00" AND enddatetime="0000-00-00 00:00:00" AND orderenddatetime="0000-00-00 00:00:00" AND status=1
查产品ID
select `productID` FROM orderinfo WHERE ID= orderID and userID = userID

查询产品类型，周期
select type,period FROM `product` WHERE ID= productID
算出在当前时间上算出，产品开始、结束、订单结束时间在修改
Update userrun set begindatetime= begindatetime , enddatetime= enddatetime, orderenddatetime= orderenddatetime and userID = userID and status=1

Answer 3

使用联合查询