How to convert multiple rows in one column ? GROUP CONCAT in mySQL

mysql-tutorials

How to convert multiple rows in one column in mySQL – Thru the help of GROUP_CONCAT function.

Syntax :-

select GROUP_CONCAT(<FIELD NAME> SEPARATOR ‘, ‘) from SKU

Example :-

select GROUP_CONCAT(id SEPARATOR ‘, ‘) from SKU

Related posts

Leave a Comment