THE WORLD'S LARGEST WEB DEVELOPER SITE
HTML CSS JAVASCRIPT SQL PHP BOOTSTRAP HOW TO JQUERY W3.CSS ANGULARJS XML MORE FORUM EXAMPLES REFERENCES

MySQL REPEAT() Function

❮ MySQL Functions

Example

Repeat the string three times:

SELECT REPEAT("SQL Tutorial", 3);
Try it Yourself »

Definition and Usage

The REPEAT() function repeats a string a specified number of times.

Syntax

REPEAT(string, number)

Parameter Values

Parameter Description
string Required. The string to repeat
number Required. The number of times to repeat the string

Technical Details

Works in: MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23

More Examples

Example

Repeat the text in CustomerName two times:

SELECT REPEAT(CustomerName, 2)
FROM Customers;
Try it Yourself »

Example

Repeat the string zero times:

SELECT REPEAT("SQL Tutorial", 0);
Try it Yourself »

❮ MySQL Functions