1 of 1

REPEAT Function

Repeat a string. This function returns a string consisting of the input string repeated a specified number of times.

Syntax

REPEAT(str,count)

Description

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

Examples

_{This page is licensed: GPLv2, originally from}

SELECT QUOTE(REPEAT('MariaDB ',4));
+------------------------------------+
| QUOTE(REPEAT('MariaDB ',4))        |
+------------------------------------+
| 'MariaDB MariaDB MariaDB MariaDB ' |
+------------------------------------+