DECLARE @var int -- Declare SELECT @var = 1 -- Initialization WHILE @var <= 20 -- condition BEGIN -- Begin PRINT replicate('* ', @var) -- Print SET @var = @var + 1 -- decrement END -- END

Easy Approach ^ ^

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

--using ms sql server

declare @i int set @i=1

while (@i<=20) begin print replicate('* ',@i) set @i=@i+1 end

Another Solution for Mysql better than previous version :

set @number = 0; select repeat('* ', @number := @number + 1) from information_schema.tables Limit 20;

By Vivek :)

Shorter Query :

SELECT REPEAT('* ', @row := @row + 1) AS stars FROM information_schema.columns, (SELECT @row := 0) AS init LIMIT 20;