node.js - How to combine rows with same ID but different values in certain columns in mysql

Question

id	name	age	gender	hobby
1	Max	20	Male	Skating
1	Max	20	Male	Running
1	Max	20	Male	Jogging
2	Tom	24	Male	Skating
3	Mary	22	Female	Dancing

Answer 1

You could try using group_concat()

 select id, name, age, gender, group_concat(hobby) 
 from my_table 
 group by id, name, age, gender