REPEAT 语句

REPEAT 语句

REPEAT 语句是有条件控制的循环语句。当满足特定条件时，就会跳出循环语句。REPEAT 语句的基本
语法形式如下：
[ begin_label : ] REPEAT
Statement_list
UNTIL search_condition
END REPEAT [ end_label ]

eg:

DELIMITER &&
CREATE PROCEDURE pro_user9(IN totalNum INT)
BEGIN
 REPEAT
    SET totalNum=totalNum-1;
    INSERT INTO t_user VALUES(totalNum,'2312312','2321312');
    UNTIL totalNum=1 
 END REPEAT;
END 
&&
DELIMITER ;

CALL pro_user9(11);