注册

group_concat函数不支持

把球给我,我要回家 2023/05/25 2412 4

从mysql迁移过来的一条sql。如下:

SELECT task_id                                       AS taskId,
             GROUP_CONCAT(col_name ORDER BY col_name DESC) AS colNames
      FROM xxx
      WHERE 1 = 1
        AND id = 0
        AND task_id LIKE '%str%'
        AND create_time LIKE '%str%'
      GROUP BY task_id, data_uuid
      ORDER BY task_id, data_uuid

请问有啥办法能兼容这个语句吗?

回答 0
暂无回答
扫一扫
联系客服