mysql之group_concat函數詳解

標籤：from   http   alt   style   ice   .com   nbsp   image   sql   

函數文法:

group_concat([DISTINCT] 要串連的欄位 [ORDER BY 排序欄位 ASC/DESC] [SEPARATOR ‘分隔字元‘])

下面舉例說明:

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函數詳解