Mysql has a one-to-multiple relationship, which combines multiple items and displays all the content (group_concat () method and group)

Mysql has a one-to-multiple relationship. Multiple items are combined to display all the content (group_concat () method and group by). mysql has a one-to-multiple relationship, combine multiple items into one and display all the content (group_concat () method and group by): for example, group the expert technical direction table according to the expert Id, all technical directions of the expert are displayed.

Select sbes. expert_id, group_concat (sbes. skill_direction) as skillDirectionStr from shtic_base_expert_skill sbes where sbes. flag = 0 group by sbes. expert_id