MariaDB Procedure 반복문

// Create
DELIMITER $$
CREATE PROCEDURE functionName()
BEGIN
    DECLARE i INT DEFAULT 1;
    WHILE(i <= 100) DO

        // query

        SET i = i+1;

    END WHILE;
END$$
DELIMITER;

// Execute
CALL functionName();