ajanuskevicius
11/3/2016 - 7:46 AM

MySQL - Repeat Loop Function

MySQL - Repeat Loop Function

DELIMITER //

CREATE FUNCTION GetRepeatLoop ( starting_value INT )
RETURNS INT

BEGIN

   DECLARE result INT;

   SET result = 0;

   label1: REPEAT
     SET result = result + starting_value;
   UNTIL result >= 1000
   END REPEAT label1;

   RETURN result;

END; //

DELIMITER ;