MySQL如何返回集合_mysql返回集合

今天想利用mysql存储过程返回多条记录,以前用oracle的游标可以直接返回.mysql不支持游标返回

通过找了资料原来可以这么做

CREATE DEFINER=`xxxx`@`%` PROCEDURE `getprizesuminfo`(opid VARCHAR(32),aid INT)

BEGIN

/**

* 获取微信活动奖品数量,及参加次数

*

* @author xuyw

* @email xyw10000@163.com

* @date 2014-04-02

*/

SELECT

p.id,

IFNULL((p.prize_actual_sum-l.zjsum),0) ptotal,

(SELECT

COUNT(activityid) playsum

FROM wxactivity_prize_log

WHERE activityid = aid

AND openid = opid) playsum

FROM (SELECT

id,

prize_actual_sum

FROM wxactivity_prize

WHERE wxactivity_id = aid

ORDER BY id) p

LEFT JOIN (SELECT

l.prizeid,

COUNT(l.prizeid) zjsum

FROM wxactivity_prize_log l

WHERE l.is_prize = 2

AND l.activityid =