REPEAT() :
This function in MySQL is used to repeat a string a specified number of times.
Syntax :
REPEAT(str, count)
Parameters :
This method accepts two parameter.
- str –Input String which we want to repeat.
- count –It will describe that how many times to repeat the string.
Returns :
It returns a repeated string.
Example-1 :
Repeating the String ‘Geeks’ 3 times with the help of REPEAT Function.
SELECT REPEAT("Geeks", 3) AS Repeated_String;
Output :
REPEATED_STRING |
---|
GeeksGeeksGeeks |
Example-2 :
Repeating the String ‘SQL’ 0 times with the help of REPEAT Function.
SELECT REPEAT("SQL", 0) AS Repeated_String;
Output :
REPEATED_STRING |
---|
Example-3 :
REPEAT Function can also be used to repeat column data. To demonstrate create a table named Employee.
CREATE TABLE Employee ( Employee_id INT AUTO_INCREMENT, Employee_name VARCHAR(100) NOT NULL, Joining_Date DATE NOT NULL, PRIMARY KEY(Employee_id ) );
Inserting some data to the Employee table :
INSERT INTO Employee (Employee_name, Joining_Date ) VALUES ('Ananya ', '2000-01-11'), ('Anush ', '2002-11-10' ), ('Aniket ', '2005-06-11' ), ('Anika ', '2008-01-21' ), ('Riyag ', '2008-02-01' ) ;
So, the Employee Table is as follows.
select * from Employee ;
Output :
EMPLOYEE_ID | EMPLOYEE_NAME | JOINING_DATE |
---|---|---|
1 | Ananya | 2000-01-11 |
2 | Anush | 2002-11-10 |
3 | Aniket | 2005-06-11 |
4 | Anika | 2008-01-21 |
5 | Riyag | 2008-02-01 |
Now, we are going to get all repeated string from Employee_name column.
SELECT REPEAT(Employee_name, 2) AS Repeated_Name FROM Employee;
Output :
REPEATED_NAME |
---|
Ananya Ananya |
Anush Anush |
Aniket Aniket |
Anika Anika |
Riyag Riyag |