MySQL 常见函数

1 group_concat([DISTINCT] 要连接的字段 [Order BY ASC/DESC 排序字段] [Separator '分隔符'])

SELECT GROUP_CONCAT(name,age ORDER BY age desc SEPARATOR "-") 
FROM person GROUP BY age;