[MySQL/Hackerrank] Draw The Triangle 2

P(R) represents a pattern drawn by Julia in R rows. The following pattern represents P(5):

Write a query to print the pattern P(20).

 

DELIMITER $$
CREATE PROCEDURE PrintStar2(IN NUM INT)
BEGIN
    SET @I = 1;
    WHILE (@I <= NUM) DO
        SELECT RPAD('', @I*2, '* ');
        SET @I = @I + 1;
    END WHILE;
END$$
DELIMITER ;

CALL PrintStar2(20);

 

Draw The Triangle 1에서 풀어서인지 7분정도 소요되었다.