Collections:
REPEAT() - Repeating String
How to repeat a string multiple times using the REPEAT() function?
✍: FYIcenter.com
REPEAT(str, count) is a MySQL built-in function that repeats a string for a given number of times. For example:
SELECT REPEAT('Echo, ', 3); -- +---------------------+ -- | REPEAT('Echo, ', 3) | -- +---------------------+ -- | Echo, Echo, Echo, | -- +---------------------+
Reference information of the REPEAT() function:
REPEAT(str, count): modstr 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 are NULL. Arguments, return value and availability: str: Required. The given string to be repeated. modstr: Return value. The repeated string. Available since MySQL 4.0.
⇒ REPLACE() - Replacing Substring
⇐ QUOTE() - MySQL Quoting String
2023-11-13, 232🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...