mysql - merge cols into one row

Question

I need to merge few columns into one row in mysql, separated by some char (; or dot), from:

Id              Item       Options

1               Charger       iphone
2               Car           black
3               Food          vege

into:

Items

"Charger; Car; Food"

Answer 1

You are looking for group_concat(), presumably:

select id, group_concat(item separator '; ') as items
from t
group by id;