- CREATE[url=http://pr.knowsky.com/]PR[/url]OCEDURE`justifyGroupNum`()NOTDETERMINISTICSQLSECURITYDEFINERCOMMENTBEGIN/*howtorun:calljustifyGroupNum()*/DECLAREp_group_idint;declarep_numint;declarestopFlagint;DECLAREcursor_nameCURSORFORselectc_group_id,count(*)asnumfrom`t_group_member`wherec_validin(3,4)groupbyc_group_id;DECLARECONTINUEHANDLERFORNOTFOUNDsetstopFlag=1;OPENcursor_name;REPEATFETCHcursor_nameINTOp_group_id,p_num;beginupdatet_groupinfosetc_member_number=p_numwherec_group_id=p_group_id;end;UNTILstopFlag=1ENDREPEAT;CLOSEcursor_name;END;
复制代码 |