table : test
id name
----- ----------
1 a
1 b
1 c
2 d
2 e
1、select wm_concat(name) allName from test;
allName
---------------
a,b,c,d,e
2、select replace(wm_concat(name),',','|') allName from test;
allName
-----------------
a|b|c|d|e
3、select id,wm_concat(name) ......
阅读全文