DELIMITER $$
CREATE PROCEDURE mysql_update_field()
BEGIN
DECLARE x INT;
DECLARE number INT;
DECLARE contador INT;
SET x = 1;
SET number=1;
select count(*) into contador from mdl_user;
REPEAT
IF exists(select * from mdl_user where id=number) THEN
UPDATE mdl_user SET idnumber=username;
END IF;
SET x = x + 1;
SET number =number+1;
SET contador=contador+1;
UNTIL x < contador
END REPEAT;
END$$
DELIMITER ;
**************************** 0 ***********************************
DELIMITER $$
CREATE PROCEDURE mysql_test_repeat_loop5()
BEGIN
DECLARE x INT;
DECLARE number INT;
SET x = 1;
SET number=2000;
REPEAT
INSERT INTO prueba (number) values (number);
SET x = x + 1;
SET number =number+50;
UNTIL x > 5
END REPEAT;
END$$
DELIMITER ;
******************************2 *********************************
DELIMITER $$
CREATE PROCEDURE mysql_test_repeat_loop2()
BEGIN
DECLARE x INT;
SET x = 1;
REPEAT
SET x = x + 1;
UNTIL x > 5
END REPEAT;
END$$
DELIMITER ;