Mysql中特有的循环REPEAT…UNTIL你了解么

1、掌握语法格式：REPEAT statement_listUNTIL search_condition END REPEAT;具体逻辑见图：

3、先建一个存储过程把业务逻辑实现。delimiter //DROP PROCEDURE IF EXISTS p_sum;CREATE PROCEDURE p_sum烫喇霰嘴(in n int)BEGIN DECLARE i INT; DECLARE sum INT; SET i = 1; SET sum = 0; REPEAT set sum = sum + i; set i = i +1; UNTIL i > n END REPEAT; SELECT sum;END//

5、执行完了再判断是否有必要执行下一次的循环。REPEAT set sum = sum + i; set i = i +1; UNTIL i > n END REPEAT;