jh_jiah的博客

转载 mysql之group_concat函数详解

函数语法：group_concat( [DISTINCT] 要连接的字段 [Order BY 排序字段 ASC/DESC] [Separator ‘分隔符’] )下面举例说明：select id,price from goods; 1以id分组，把price字段的值在同一行打印出来，逗号分隔(默认)select id, group_concat(price) from goods group by id; 1以id分组，把price字段的值在一行打印出来，分号分隔se..