表创建
create table tb2(id int,v1 int);
创建数据
insert into tb2(id,v1) values(1,11);
insert into tb2(id,v1) values(1,12);
insert into tb2(id,v1) values(1,13);
生成的数据
+------+------+
| id | v1 |
+------+------+
| 1 | 11 |
| 1 | 12 |
| 1 | 13 |
+------+------+
group_concat 实验
select id,group_concat(v1) from tb2 group by id;
实验结果
+------+------------------+
| id | group_concat(v1) |
+------+------------------+
| 1 | 11,12,13 |
+------+------------------+
select id,group_concat(v1 order by v1 desc separator '_') from tb2 group by id;
+------+-------------------------------------------------+
| id | group_concat(v1 order by v1 desc separator '_') |
+------+-------------------------------------------------+
| 1 | 13_12_11 |
+------+-------------------------------------------------+
concat 实验
select concat(id,v1) as info from tb2;
+------+-------------------------------------------------+
| id | group_concat(v1 order by v1 desc separator '_') |
+------+-------------------------------------------------+
| 1 | 13_12_11 |
+------+-------------------------------------------------+
concat_ws实验