[MySQL] REPEAT()

MySQL 문자열 함수와 연산자

 

REPEAT()

   - 문자열 반복

 

REPEAT(str, count)

의 형태

 

Returns a string consisting of the string str repeated count times. If count is less than 1, returns an empty string. Returns NULL if str or count are NULL.

 

mysql> SELECT REPEAT('오늘은', 5);
+-----------------------------------------------+
| REPEAT('오늘은', 5)                           |
+-----------------------------------------------+
| 오늘은오늘은오늘은오늘은오늘은                |
+-----------------------------------------------+
1 row in set (0.00 sec)