Hackerrank | MySQL | Draw The Triangle 2

Draw The Triangle 2

Problem

Draw The Triangle 2 | HackerRank

 

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).

 

 

SET @num = 0;
SELECT REPEAT('* ', @num := @num+1)
FROM information_schema.tables
LIMIT 20

SET @NUM:= 0;
SELECT REPEAT('* ', @NUM := @NUM + 1)
FROM information_schema.tables
LIMIT 20;