dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Jan 14, 2020

Using REPEAT in MySQL

MySQL provides a REPEAT command that can be used when you want to repeat a particular string, a defined number of times.

Consider the example below:

SELECT CONCAT('S',REPEAT("E",2))

Here, we can observe that the output is the text 'SEE'. The letter 'E' has been repeated two times as indicated in the argument.

+-----------------------------+
| CONCAT('S',REPEAT("E",2))   |
+-----------------------------+
| SEE                         | 
+-----------------------------+
Sridhar MS
 
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date