关于#oracle#的问题，如何解决？

Question

oracle中的listagg函数改写成mysql的语句

 SELECT audit_id,
       listagg(label_id, ',') WITHIN GROUP (ORDER BY audit_id)   AS label_ids,
       listagg(label_name, ',') WITHIN GROUP (ORDER BY audit_id) AS label_names
FROM DAM_LABEL_INST.LABEL_AUDIT_ITEM
GROUP BY audit_id;

改写成mysql语句

Answer 1

 SELECT audit_id,
       group_concat(label_id ORDER BY audit_id)   AS label_ids,
       group_concat（label_name ORDER BY audit_id) AS label_names
FROM DAM_LABEL_INST.LABEL_AUDIT_ITEM
GROUP BY audit_id;