Tuesday 2 August 2016

REPEAT: Repeat string in given number of times



REPEAT(str, count): REPEAT function repeat string, count number of times.

mysql> SELECT REPEAT("HELLO PTR", 5);
+-----------------------------------------------+
| REPEAT("HELLO PTR", 5)                        |
+-----------------------------------------------+
| HELLO PTRHELLO PTRHELLO PTRHELLO PTRHELLO PTR |
+-----------------------------------------------+
1 row in set (0.00 sec)



Previous                                                 Next                                                 Home

No comments:

Post a Comment