Example
Repeat a string 3 times:
sql
SELECT REPEAT("SQL Tutorial", 3);
Definition and Usage
The REPEAT() function repeats a string as many times as specified.
Syntax
text
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: | From MySQL 4.0 |
|---|
More Examples
Example
Repeat the text in CustomerName 2 times:
sql
SELECT REPEAT(CustomerName,
2)
FROM Customers;
Example
Repeat the string 0 times:
sql
SELECT REPEAT("SQL Tutorial", 0);