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; |
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;