当前位置：网站首页>The problem of the result set returned by MySQL stored procedure

The problem of the result set returned by MySQL stored procedure

2022-07-22 17:57:00 【CSDN Q & A】

mysql The problem of the result set returned by the stored procedure 

DELIMITER $$USE `crj`$$DROP PROCEDURE IF EXISTS `crj_duty`$$CREATE DEFINER=`root`@`%` PROCEDURE `crj_duty`()BEGINSET @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 ;** Execution results **![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")** Expected results ** I just want the second result set , What should I do with ？
原网站

版权声明
本文为[CSDN Q & A]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/203/202207151627425227.html

边栏推荐

猜你喜欢

随机推荐