mysql之group_concat函数详解

select * from goods;

---

以id分组,把price字段的值在同一行打印出来,逗号分隔(默认)

select id, group_concat(price) from goods group by id;

---

以id分组,把price字段的值在一行打印出来,分红分隔

SELECT id, group_concat(price separator ‘;‘) from goods group by id;

---

以id分组,把去除重复冗余的price字段的值打印在一行,以逗号分隔

select id, group_concat(distinct price) from goods group by id;

---

以id分组,把price字段的值打印在一行,逗号分隔,按照price倒序排列

select id,group_concat(price order by price desc) from goods group by id;

 

mysql之group_concat函数详解

标签：from   http   alt   style   ice   .com   nbsp   image   sql