mysql函数实例-统计日存留率(二)
R NOT FOUND SET stopFlag=1;
OPEN cur2;
FETCH cur2 INTO _status_remain, _remain_count;
WHILE stopFlag = 0 do
IF _status_remain = 1 THEN
SET _temp_count = _remain_count;
SET _all_count = _all_count + _remain_count;
ELSE
SET _all_count = _all_count + _remain_count;
END IF;
INSERT INTO report_user_remain_day(id, day_time, remain_count, remain_percent_day, type_client)
VALUES(UUID(), _day_time, _temp_count, (_temp_count / _all_count), 0);
FETCH cur2 INTO _status_remain, _remain_count;
END WHILE;
CLOSE cur2;
RETURN 1;
END