How to repeat a value stored in a data column of a MySQL table?

To repeat a value stored in a data column of a MySQL table, the column name must be passed as the first argument to the REPEAT() function. Demonstrate using data from the "Student" table:

Example

mysql> Select REPEAT(Name,3)AS Name from student;
+-----------------------+
| Name                  |
+-----------------------+
| GauravGauravGaurav    |
| AaravAaravAarav       |
| HarshitHarshitHarshit |
| GauravGauravGaurav    |
| YashrajYashrajYashraj |
+-----------------------+
5 rows in set (0.00 sec)

The above is the detailed content of How to repeat a value stored in a data column of a MySQL table?. For more information, please follow other related articles on the PHP Chinese website!