select id,group_concat(distinct age) from test_group_concat group by id;
select id,group_concat(id,'_', age SEPARATOR ';') from test_group_concat group by id;

  

 posted on 2023-12-05 17:08  boye169  阅读(9)  评论(0编辑  收藏  举报