急：mysql怎么实现sqlserver中for xml path

mysql中有group_concat()()可以合并多行内容select AID,ANAME,(select group_concat(VALUE) from B where B.AID=A.AID) as AVALUE from A

(1) select b,b+'('+stuff((select ','+a from tab t2 where t2.b=t1.b for xml path('')),1,1,'')+')' as result from tab t1 group by b

(2) select b,'('+stuff((select ','+a from tab t2 where t2.b=t1.b for xml path('')),1,1,'')+')' as result from tab t1 group by b

(3) select b+'('+stuff((select ','+a from tab t2 where t2.b=t1.b for xml path('')),1,1,'')+')' as result from tab t1 group by b

看哪个你要的。

至于为什么可以这样，请百度T-SQL的for xml path。

---