mysql列合并

2016-02-16 by wwwcomcn123

SELECT *,GROUP_CONCAT(qy.qy_name SEPARATOR ';') AS NAME FROM ydyl_xdxx xdxx INNER JOIN ydyl_qy qy ON(xdxx.xd_id=qy.qy_xd_id) WHERE qy.qy_statu=1 GROUP BY xd_ssidtype关键字:1.GROUP_CONCAT2.GROUP BY

第七城市

栏目导航(关闭)