mysql listagg within_MySql 怎么实现 LISTAGG

我在Orcle里写了一个Sql语句，用到了LISTAGG，现在要改成mysql数据库，我要怎么改这个Sql语句？SELECTA.GUID,A.COMPANY_GUID,A.GOODS_CODE,A.GOODS_NAME,A.SPECIFICATIONS,A.SMALL_IM...

我在Orcle里写了一个Sql语句，用到了LISTAGG，现在要改成mysql数据库，我要怎么改这个Sql语句？

SELECT A.GUID,A.COMPANY_GUID,A.GOODS_CODE,A.GOODS_NAME,A.SPECIFICATIONS,A.SMALL_IMAGE,A.GOODS_UNIT_GUID,A.STATE,A.MARKET_VALUE,A.INTRODUCE,A.INVENTORY,A.ALARM,A.IAMGE_PATH,A.IS_LOSE,A.CREATE_TIME,A.CREATE_USER,A.MODIFY_TIME,A.MODIFY_USER,U.UNIT_NAME AS GOODS_UNIT_NAME

,LISTAGG(B.GUID,''',''') WITHIN GROUP (ORDER BY B.GUID) AS GOODS_TYPE_GUID

FROM B1_GOODS A

LEFT JOIN B1_UNIT U ON U.GUID = A.GOODS_UNIT_GUID

LEFT JOIN B1_GOODS_TYPE_RELATION T ON A.GUID = T.GOODS_GUID

LEFT JOIN B1_GOODS_TYPE B ON T.GOODS_TYPE_GUID = B.GUID

WHERE 1=1

GROUP BY A.GUID,A.COMPANY_GUID,A.GOODS_CODE,A.GOODS_NAME,A.SPECIFICATIONS,A.SMALL_IMAGE,A.GOODS_UNIT_GUID,A.STATE,A.MARKET_VALUE,A.INTRODUCE,A.INVENTORY,A.ALARM,A.IAMGE_PATH,A.IS_LOSE,A.CREATE_TIME,A.CREATE_USER,A.MODIFY_TIME,A.MODIFY_USER,U.UNIT_NAME

ORDER BY A.GUID

展开