CREATE PROCEDURE getDevQuestionAnswer ( _routeId BIGINT ( 11 ), _standardName VARCHAR ( 100 ) ) BEGIN
SET @params = '';
SELECT
@params := CONCAT( @params, ',GROUP_CONCAT(if(topic= \'', topic, '\',answer,', '\'\')) as ', '\'', topic, '\'' ) AS aa
FROM
( SELECT DISTINCT topic FROM dev_questionnaireanswer WHERE routeId = _routeId AND standardName = _standardName and subitemType!='2' ) A;
SET @sql = CONCAT ( 'select equipmentCode', @params, ' from `dev_questionnaireanswer` WHERE subitemType!=',2,' and routeId =', _routeId, ' AND standardName =', '\'', _standardName, '\' GROUP BY equipmentCode' );
PREPARE stmt
FROM
@sql;
EXECUTE stmt;
END;
-- 运行存储过程
CALL getDevQuestionAnswer ( 123,'标准1');
我只想要第二个结果集,我该如何处理
调整一下给变量赋值的方式,改用select xxx into @parm 的方式给变量赋值,就会不在result输出变量了