函数语法:
group_concat( [DISTINCT] 要连接的字段 [Order BY 排序字段 ASC/DESC] [Separator ‘分隔符’] )
以name分组,将id拼接起来,默认以“,”分隔
SELECT
GROUP_CONCAT(id)
FROM
sys.student
WHERE
id BETWEEN 1 AND 9 group by name
函数语法:
group_concat( [DISTINCT] 要连接的字段 [Order BY 排序字段 ASC/DESC] [Separator ‘分隔符’] )
以name分组,将id拼接起来,默认以“,”分隔
SELECT
GROUP_CONCAT(id)
FROM
sys.student
WHERE
id BETWEEN 1 AND 9 group by name