mysql-group_concat(group by 的时候对合并内容的统计)

表创建 

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实验