MySQL Loop usage

While for example

DROP PROCEDURE IF EXISTS Zy.test_pro;
DELIMITER $$
CREATE PROCEDURE Zy.test_pro (in ID INT)
BEGIN
DECLARE num INT;
SET Num=1;
While Num <=id do
INSERT into Zy.test VALUES (num,concat (' Test ', num));
SET num = num +1;
END while;
END;

Repate

Delimiter//drop procedure if exists looppc;create procedure LOOPPC () Begin DECLARE I int;set i = 1;        Repeat INSERT into User_profile_company (UID) values (i+1);  Set i = i + 1; Until I >= end repeat;end//----calls call LOOPPC ()

Loop

Delimiter $ $drop Procedure if exists lopp;create procedure Lopp () BEGIN declare I int; set i = 1;lp1:loop//           LP1 the loop body name loop as the keyword INSERT into user_profile (UID) values (i);        Set i = i+1;　　　　　　　　　　　　　　If i > then leave LP1; Leave the loop body End if;　　　　　　　　　　　　　　End LOOP; Ending Loop End $$

MySQL Loop usage