• + 0 comments

    For MySQL Platform

    DELIMITER $$
    
    CREATE PROCEDURE pattern_print()
    BEGIN
        DECLARE i INT DEFAULT 1;
        
        WHILE i<=20 DO
            SELECT IF(i=1, "*", REPEAT("* ", i));
            SET i = i + 1;
        END WHILE;
    END $$
    
    DELIMITER ;
    
    CALL pattern_print();