Question: what is the difference between concat and group_concat in mysql?
Answer: Usage notes: concat() and concat_ws() are appropriate for concatenating the values of multiple columns within the same row, while group_concat() joins together values from different rows. By default, returns a single string covering the whole result set.