mysql:select group_concat(列) from 表 group by null
mysql:select group_concat(列)from 表
oralce:select WM_CONCAT(A.title) as citys from tmpcity A
sql server:select stuff((select ','+A.title from tmpCity A FOR xml PATH('')), 1, 1, '') as citys
展示mysql
1 原数据如下
select * from tableCeShi;
2.1 拼接单列数据为一个字段
select group_concat(wks) from tableCeShi ; -- 默认的逗号分隔
select group_concat(wks SEPARATOR ';') from tableCeShi ; -- 指定分隔符号
2.2 拼接单列数据为一个字段,字段内容加单引号
select group_concat(concat('''',wks,'''')) as wks from tableCeShi ;
3.拼接多列为一列
SELECT concat(years,'年',wks) from tableCeShi;