SET @i := 0;

SELECT REPEAT('* ', @i := @i + 1)
FROM information_schema.tables
WHERE @i < 20;

DECLARE @i INT = 1;
DECLARE @max INT = 20;

WHILE @i<=@max
BEGIN
   PRINT REPLICATE ('* ', @i)
   SET @i= @i+1
END

WITH RECURSIVE numbers AS (
    SELECT 1 AS n
    UNION ALL
    SELECT n + 1 FROM numbers WHERE n < 20
)
SELECT REPEAT('* ', n) FROM numbers; 

WITH RECURSIVE numbers AS (
  SELECT 1 AS i
  UNION ALL
  SELECT i + 1 FROM numbers WHERE i < 20
)
SELECT REPEAT(' *', i) AS stars
FROM numbers;

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