[HackerRank/SQL] Alternative Queries - Draw The Triangle 1

Problem. Alternative Queries - Draw The Triangle 1

---

Link.

https://www.hackerrank.com/challenges/draw-the-triangle-1/problem?isFullScreen=true 

Draw The Triangle 1 | HackerRank

---

Description.

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

---

Key Point. 

REPEAT,

 

information_schema.tables를 사용한 이유:

 

---

My Answer. 

SET @number := 21;
SELECT REPEAT('* ', @number := @number - 1) FROM information_schema.tables;

---

References. 

문제풀이: https://www.hackerrank.com/challenges/draw-the-triangle-1/forum

Discussion on Draw The Triangle 1 Challenge

 

information_schema 테이블: https://rk1993.tistory.com/230

[MySQL]information_schema란 ? (정의 및 테이블 종류)