SELECT CONCAT(RTRIM(code_name), ',') AS a FROM agency 去空格 添加格式
SELECT GROUP_CONCAT(code_name) ,COUNT(code_name) AS a
FROM agency 多行合并成一行
SELECT CONCAT(RTRIM(code_name), ',') AS a FROM agency 去空格 添加格式
SELECT GROUP_CONCAT(code_name) ,COUNT(code_name) AS a
FROM agency 多行合并成一行