MySQL 遍历方式可以使用 while,loop 和 repeat 来实现, 示例如下:
- BEGIN
- DECLARE i INT DEFAULT 0;
- # WHILE
- WHILE i <5 DO
- SET i = i + 1;
- END WHILE;
- # SELECT i;
- # LOOP
- optLoop:LOOP
- IF i> 10 THEN
- LEAVE optLoop;
- END IF;
- SET i = i + 1;
- END LOOP;
- # SELECT i;
- # REPEAT
- REPEAT
- SET i = i + 1;
- UNTIL i> 15 END REPEAT;
- SELECT i;
- END
来源: http://www.bubuko.com/infodetail-3194931.html