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 is NULL.

Syntax

MYSQL Copy

SELECT REPEAT('MySQL', 3);
'MySQLMySQLMySQL'

Examples

Example

MYSQL Copy

SELECT REPEAT('MySQL', 3);
'MySQLMySQLMySQL'