MySQL：多行作为逗号分隔的单行

使用GROUP_ConCAT FUNCTION

http://dev.mysql.com/tech-resources/articles/4.1/grab-
bag.html

 SELEct m.meal_Id,         GROUP_CONCAt(dish_id) dish_ids,         GROUP_CONCAt(dish_name) dish_names FROM DISH_HAS_DISHES m JOIN DISH d ON (m.dish_id = d.dish_id) GROUP BY meal_Id