mysql - 将列值组合在一个单元格中

Question

我需要编写一个 SQL select 语句，将一列中的值组合到一个单元格中。

例如

table name: Customer_Hobbies
+------------+------------+-----------+
| CustomerId |     Age    |  Hobby    |
+------------+------------+-----------+
| 123        |     17     |  Golf     |
| 123        |     17     |  Football |
| 324        |     14     |  Rugby    |
| 627        |     28     |  Football |
+------------+------------+-----------+

应该返回...

+------------+------------+----------------+
| CustomerId |     Age    |  Hobbies       |
+------------+------------+----------------+
| 123        |     17     |  Golf,Football |
| 324        |     14     |  Rugby         |
| 627        |     28     |  Football      |
+------------+------------+----------------+

这可能吗？

注意我知道数据的布局不是特别合理，但我无法更改。

Answer 1

你想要group_concat():

select customerId, age, group_concat(hobby) as hobbies
from t
group by customerId, age