4. How to use GROUP BY to concatenate strings in MySQL?

How to use GROUP BY to concatenate strings in MySQL?

Answer

SELECT id, GROUP_CONCAT(string SEPARATOR ' ')FROMtableGROUPBY id;

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat

All string Questions
Ask your interview questions on string

Write Your comment or Questions if you want the answers on string from string Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---