MySQL Iterate method WHILE

Posted on January 11, 2018, 3:35 pm, by admin, under mysql.
CREATE PROCEDURE example1()
label1:BEGIN
DECLARE rowCount INT DEFAULT 0;
DECLARE i INT DEFAULT 0;
 
SELECT COUNT(*) INTO rowCount FROM my_table;
 
WHILE (i <= rowCount) DO
 
SELECT i;
 
SET i = i+1000;
END WHILE;
END;
Comment (RSS)  |  Trackback

Leave a Reply

«
»