MySQL group_concat function merges multiple cells of the same key into one cell

mysql GROUP_CONCAT 函数 将相同的键的多个单元格合并到一个单元格

MemberID          MemberName              FruitName--------------    ---------------------   --------------1 Al Apple1 Al Cherry

Desired output

MemberID           MemberName            FruitName-----------        --------------        ------------1 Al Apple, Cherry

3down VoteAccepted

GROUP by MemberName and Group_concat (Fruitname). For example, select Memberid, Membername, Group_concat ( Span class= "PLN" >fruitname) from a left join b on A.= B.group by A.< Span class= "PLN" >membername;

The

MySQL group_concat function merges multiple cells of the same key into a single cell