1.把查询结果用逗号拼接
select group_concat(objname) from humres
2. 把两列的数据拼接在一起
select objname,group_concat(concat_ws('-',id,objname)order by id) as v from humres group by objname;
标签:group,逗号,拼接,objname,两列,concat From: https://www.cnblogs.com/jk200/p/17187966.html