MYSQL存储过程-练习2 while 循环

合集 - SQL存储过程(6)

1.MYSQL存储过程-练习12024-05-10

2.MYSQL存储过程-练习2 while 循环2024-05-14

3.MYSQL存储过程-练习3 repeat循环2024-05-144.MYSQL存储过程-练习4 loop循环2024-05-145.MYSQL存储过程-练习5 游标2024-05-156.MYSQL存储过程-练习62024-05-17

收起

MYSQL存储过程-练习2 while 循环

#WHILE循环
DELIMITER $$

CREATE  PROCEDURE `sp_while`()
BEGIN
  DECLARE i INT;
  SET i=1;
  WHILE i<=5 DO
    SELECT i;
    SET i=i+1;
  END WHILE;
END$$

DELIMITER ;

执行存储过程

mysql> call sp_while();
+------+
| i    |
+------+
|    1 |
+------+
1 row in set (0.00 sec)

+------+
| i    |
+------+
|    2 |
+------+
1 row in set (0.01 sec)

+------+
| i    |
+------+
|    3 |
+------+
1 row in set (0.02 sec)

+------+
| i    |
+------+
|    4 |
+------+
1 row in set (0.03 sec)

+------+
| i    |
+------+
|    5 |
+------+
1 row in set (0.04 sec)

Query OK, 0 rows affected (0.04 sec)