How can we combine values of two or more columns of MySQL table and get that value in a single column?
For combining values of two or more columns, we can use MySQL CONCAT() function. In this case, the arguments of the CONCAT() functions would be the name of the columns. For example, suppose we have a table named ‘Student’ and we want the name and address of the student collectively in one column then the following query can be written −
mysql> Select Id, Name, Address, CONCAT(ID,', ',Name,', ', Address)AS 'ID, Name,Address' from Student;
+------+---------+---------+--------------------+
| Id | Name | Address | ID, Name, Address |
+------+---------+---------+--------------------+
| 1 | Gaurav | Delhi | 1, Gaurav, Delhi |
| 2 | Aarav | Mumbai | 2, Aarav, Mumbai |
| 15 | Harshit | Delhi | 15, Harshit, Delhi |
| 20 | Gaurav | Jaipur | 20, Gaurav, Jaipur |
+------+---------+---------+--------------------+
4 rows in set (0.00 sec)
Published on 21-Feb-2018 14:01:12
