DROP PROCEDURE IF EXISTS prg_cursor;
DELIMITER $$
CREATE PROCEDURE prg_cursor()
BEGIN
DECLARE i INT DEFAULT 1;
DECLARE total INT DEFAULT 3;
SELECT NOW();
/**while循环**/
WHILE (i<total) DO
SELECT i;
SET i=i+1;
END WHILE;
SET i=1;
#repeat循环
REPEAT
SELECT i;
SET i=i+1;
UNTIL i>=total
END REPEAT;
SET i=1;
#loop循环
testLabel:LOOP
SELECT i;
IF(i<=total) THEN
SET i=i+1;
ITERATE testLabel;
END IF;
IF(i>total) THEN
LEAVE testLabel;
END IF;
END LOOP;
END
$$
CALL prg_cursor()
DELIMITER $$
CREATE PROCEDURE prg_cursor()
BEGIN
DECLARE i INT DEFAULT 1;
DECLARE total INT DEFAULT 3;
SELECT NOW();
/**while循环**/
WHILE (i<total) DO
SELECT i;
SET i=i+1;
END WHILE;
SET i=1;
#repeat循环
REPEAT
SELECT i;
SET i=i+1;
UNTIL i>=total
END REPEAT;
SET i=1;
#loop循环
testLabel:LOOP
SELECT i;
IF(i<=total) THEN
SET i=i+1;
ITERATE testLabel;
END IF;
IF(i>total) THEN
LEAVE testLabel;
END IF;
END LOOP;
END
$$
CALL prg_cursor()