Mysql創(chuàng)建存儲過程，使用游標(biāo)Cursor循環(huán)更新_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 不知道為什么用異常加入判斷 ？ * 這把 游標(biāo) 異常后 捕捉 * 并設(shè)置 循環(huán)使用 變量 stop 為 null 跳出循環(huán)。 */ declare CONTINUE HANDLER FOR SQLSTATE '02000' SET stop = null; /*開游標(biāo)*/	OPEN cur;	/*游標(biāo)向下走一步，將查詢出來的兩個(gè)值付給定義的兩個(gè)變量*/	FETCH cur INTO mdsl,aid;	/* 循環(huán)體 這很明顯 把游標(biāo)查詢出的 name 都加起并用 ; 號隔開 */	WHILE ( stop is not null) DO	update zlgsydrsp.area_info set i_subbran_count=mdsl where id = aid ;	/*游標(biāo)向下走一步*/	FETCH cur INTO mdsl,aid;	END WHILE;	CLOSE cur;END;