Mysql创建存储过程，使用游标Cursor循环更新_MySQL

-- Procedure "useCursor" DDLCREATE PROCEDURE `useCursor`()BEGIN /*局部变量的定义 declare*/ declare aid bigint default 0 ; declare mdsl bigint default 0; declare stop int default 0; declare cur CURSOR FOR (select count(area_info.id) as mdsl, area_info.id as aid from area_info right join subbranch_info on subbranch_info.i_subbran_area=area_info.id	where area_info.i_record_status=0 and subbranch_info.i_record_status=0 group by area_info.id); /* mysql 不知道为什么用异常加入判断 ？ * 这把 游标 异常后 捕捉 * 并设置 循环使用 变量 stop 为 null 跳出循环。 */ declare CONTINUE HANDLER FOR SQLSTATE '02000' SET stop = null; /*开游标*/	OPEN cur;	/*游标向下走一步，将查询出来的两个值付给定义的两个变量*/	FETCH cur INTO mdsl,aid;	/* 循环体 这很明显 把游标查询出的 name 都加起并用 ; 号隔开 */	WHILE ( stop is not null) DO	update zlgsydrsp.area_info set i_subbran_count=mdsl where id = aid ;	/*游标向下走一步*/	FETCH cur INTO mdsl,aid;	END WHILE;	CLOSE cur;END;