MySql ´æ´¢¹ý³ÌʹÓÃÓαêÑ­»·²åÈëÊý¾ÝʾÀý

±¾Ê¾Àýͨ¹ý while...end while Ñ­»·¿ØÖÆÓαêÀ´ÊµÏÖ²åÈë±í¼Ç¼¡£
DROP PROCEDURE IF exists pro_initCategoryForTradingEntity;
create procedure pro_initCategoryForTradingEntity(tradingEntityId int)
begin
    declare f_parent,entityId  int;
    declare b int default 0;    /*ÊÇ·ñ´ïµ½¼Ç¼µÄĩβ¿ØÖƱäÁ¿*/
    declare f_name varchar(100);   
    DECLARE cur_1 CURSOR FOR select FName,FParent,tradingEntityId from t_category_tag;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET b = 1;
    OPEN cur_1;
    FETCH cur_1 INTO f_name, f_parent, entityId; /*»ñÈ¡µÚÒ»Ìõ¼Ç¼*/
    while b<>1 do           
        insert into t_category(FName,FParent,FTradingEntity)  values(f_name, f_parent, entityId);
        FETCH cur_1 INTO f_name, f_parent, entityId; /*È¡ÏÂÒ»Ìõ¼Ç¼*/
    end while;
    close cur_1;       
end;
call pro_initCategoryForTradingEntity(2);
ÁíÍâÑ­»·Ò²¿ÉÒÔÓÃrepeat...end repeat À´Ñ­»·¿ØÖÆ£¬ÒÔÏÂÊÇÎÒ×î³õËù×öµÄʾÀý´úÂ룬µ«½á¹ûÊDzåÈëµÄʵ¼ÊÊý¾Ý×ÜÊý¶à³öÒ»Ìõ,ÔÚ´ËÁгö×÷Ϊһ¸ö·´ÃæʾÀý´úÂë¡£µ±È»×îºóÓõÄÊÇÉÏÃæwhile...end while ·½°¸¡£
DROP PROCEDURE IF exists pro_initCategoryForTradingEntity;
create procedure pro_initCategoryForTradingEntity(tradingEntityId int)
begin
        declare f_parent,entityId,b  int;
    declare f_name varchar(100);
    DECLARE cur_1 CURSOR FOR select FName,FParent,tradingEntityId from t_category_tag;
    DECLARE CONTINUE HANDLER FOR NOT FOUND
    SET b = 1;
    OPEN cur_1;
    REPEAT
        FETCH cur_1 INTO f_name, f_parent, entityId;
 &