mysql存储过程返回的结果集的问题
DELIMITER $$
USE `crj`$$
DROP PROCEDURE IF EXISTS `crj_duty`$$
CREATE DEFINER=`root`@`%` PROCEDURE `crj_duty`()
BEGIN
SET @EE='';
SELECT @EE :=CONCAT(@EE,'max(if(duty_type= \'',duty_type,'\',duty_name,NULL)) as ',duty_type, ',') AS aa FROM (SELECT DISTINCT duty_type FROM sks_duty_info) A ;
SET @QQ = CONCAT('select ifnull(c.parent_id,\'TOTAL\')as parent_id,',@EE,' b.duty_time from sks_duty_info c,sks_duty_days b WHERE c.parent_id=b.id group by parent_id order by b.duty_time asc');
-- SELECT @QQ;
PREPARE zbb FROM @QQ;
EXECUTE zbb;
DEALLOCATE PREPARE zbb;
END$$
DELIMITER ;
**执行结果**
![img](https://img-mid.csdnimg.cn/release/static/image/mid/ask/217062378756119.png "#left")
![img](https://img-mid.csdnimg.cn/release/static/image/mid/ask/100072378756194.png "#left")
**期望结果**
我只想要第二个结果集,我该如何处理?