hackerrank Draw The Triangle 2

 

 

1) SET

 

1-1)

SET @row := 0;

 

 

 

2) * 반복

 

2-1)

REPEAT( "* ", @row := @row + 1 )

 

 

 

3) INFORMATION_SCHEMA.tables

 

3-1)

SET @row :=0;

SELECT REPEAT("* ", @row := @row + 1 )

FROM INFORMATION_SCHEMA.tables

 

 

 

4) where절

 

4-1)

SET @row := 0;

SELECT REPEAT("* ", @row := @row + 1 )

FROM INFORMATION_SCHEMA.tables

WHERE @row < 20;

 

4-1) 결과

 

이하 20줄까지 출력된다.

 

 

SUCCESS!!