本文共 1188 字,大约阅读时间需要 3 分钟。
group_concat 将相同的行组合起来
+------+------+ | id| name | +------+------+ |1 | 10| |1 | 20| |1 | 20| |2 | 20| |3 | 200 | |3 | 500 | +------+------+select id,group_concat(name separator ';') from aa group by id;
+------+--------------------+ | id| group_concat(name) | +------+--------------------+ |1 | 10,20,20| |2 | 20 | |3 | 200,500| +------+--------------------+
select id,group_concat(name separator ';') from aa group by id;
+------+----------------------------------+ | id| group_concat(name separator ';') | +------+----------------------------------+ |1 | 10;20;20 | |2 | 20| |3 | 200;500 | +------+----------------------------------+
select id,group_concat(distinct name) from aa group by id;
+------+-----------------------------+ | id| group_concat(distinct name) | +------+-----------------------------+ |1 | 10,20| |2 | 20 | |3 | 200,500 | +------+-----------------------------+
+------+---------------------------------------+
| id| group_concat(name order by name desc) | +------+---------------------------------------+ |1 | 20,20,10 | |2 | 20| |3 | 500,200| +------+---------------------------------------+转载地址:http://kaboi.baihongyu.com/