REPEAT

Declaration

REPEAT(str, count)

Description

Returns a string that is the str repeated count times. If count is less than or equal to 0, it returns an empty string. If any parameter is NULL, it returns NULL.

Examples

SELECT
   REPEAT('1', -1),
   REPEAT(null, null),
   REPEAT('Abc', 4)
   \G
*************************** 1. row ***************************
   REPEAT('1', -1):
REPEAT(null, null): NULL
  REPEAT('Abc', 4): AbcAbcAbcAbc
1 row in set (0.001 sec)