Repeat function in mysql query to repeat string number of times

REPEAT(): repeat a string a specified number of times

REPEAT() returns a string repeated the requested number of times. A count less than 1 returns an empty string.

SELECT REPEAT(' plus2net ', 3);

This will repeat our string plus2net three times. Like this

plus2net  plus2net  plus2net

What about this query ?

SELECT REPEAT(' plus2net ', 0);

No output or blank output

All String Functions LPAD() / RPAD()

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com