mysql有没有批量游标_mysql游标批量操作

BEGIN

DECLARE _uuid VARCHAR(60);

DECLARE _insertNum INT DEFAULT 0;

DECLARE done int DEFAULT 0;

#定义游标

DECLARE rs_cursor CURSOR FOR

SELECT uuid,(10-IFNULL(rateNum,0)) as insertNum from product p

LEFT JOIN

(SELECT product_uuid,count(product_uuid) AS rateNum FROM rate GROUP BY product_uuid HAVING rateNum<10) as n

ON p.uuid = n.product_uuid;

DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;

OPEN rs_cursor;

cursor_loop:LOOP

FETCH rs_cursor INTO _uuid,_insertNum;

IF done = 1 THEN

LEAVE cursor_loop;

END IF;

SELECT _uuid,_insertNum;

INSERT INTO rate(uuid,nick,result,created,content,tid,product_uuid,deleted,flag)

SELECT rand_string(10),nick,result,now(),content,NULL,_uuid,0,NULL FROM rate_sample ORDER BY RAND() LIMIT _insertNum;

END LOOP;

CLOSE rs_cursor;END select count(*) from (SELECT s.phone_num,u.weixin_id,s.total_point FROM `app_db`.`si_receive_red_envelope` s left join app_user u on s.phone_num = u.phone_num

where

ifNull(u.weixin_id,'') !='') m left join si_red_draw_log w on m.phone_num = w.phone_num where

ifNull(w.weixin_id,'') =''

and m.total_point >=25 and m.total_point <50