REPEAT
repeatβ
Descriptionβ
Syntaxβ
VARCHAR repeat (VARCHAR str, INT count)
Repeat the str of the string count times, return empty string when count is less than 1, return NULL when str, count is any NULL
exampleβ
mysql> SELECT repeat("a", 3);
+----------------+
| repeat('a', 3) |
+----------------+
| aaa |
+----------------+
mysql> SELECT repeat("a", -1);
+-----------------+
| repeat('a', -1) |
+-----------------+
| |
+-----------------+
keywordsβ
REPEAT