DELIMITER $$
CREATE PROCEDURE updateAuditPlanReport()
BEGIN
 DECLARE report_end_flag int DEFAULT 0;
 DECLARE last_report_id int DEFAULT 0;
 DECLARE num int DEFAULT 1;
 DECLARE val_id int(10) unsigned;
 DECLARE val_audit_plan_report_id int(10) unsigned;
 DECLARE val_number int(10) unsigned;
 DECLARE cur_report CURSOR FOR SELECT id,audit_plan_report_id,number FROM sqle.audit_plan_report_sqls_v2 WHERE number IS NULL AND deleted_at IS NULL;
 DECLARE CONTINUE HANDLER FOR NOT FOUND SET report_end_flag=1;
 
 OPEN cur_report;
 FETCH cur_report INTO val_id,val_audit_plan_report_id,val_number;
 WHILE report_end_flag <>1 DO
 IF val_audit_plan_report_id!=last_report_id THEN
 SET num=1;
 SET last_report_id=val_audit_plan_report_id;
 END IF;
 UPDATE sqle.audit_plan_report_sqls_v2
 SET number=num
 WHERE id=val_id;
 SET num=num+1;
 FETCH cur_report INTO val_id,val_audit_plan_report_id,val_number;
 END WHILE;
END; 
$$
DELIMITER ;
CALL updateAuditPlanReport();