**1. 语法** ```sql [label:]REPEAT statements UNTIL end_condition END REPEAT [label] - end_condition：条件为真退出循环，为假则继续循环 ``` **2. 演示** ```sql delimiter $ create function fun_add_repeat(count int(11)) returns int begin declare sum int default 0; repeat set sum = sum + 1; set count = count - 1; until count <= 0 end repeat; return sum; end $ mysql> select fun_add_repeat(5) $ +-------------------+ | fun_add_repeat(5) | +-------------------+ | 5 | +-------------------+ ```