mysql一对多关系,将多条组成一条并显示全部内容(group_concat()方法与group by并用)
mysql 一对多关系,将多条组成一条并显示全部内容(group_concat()方法与group by并用):
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