注册

GROUP_CONCAT函数不支持,搜了一下问题,用了好像不太管用

blueberry 2024/06/04 998 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】:GROUP_CONCAT函数,MySQL迁移过来无法执行,具体是这行GROUP_CONCAT( DISTINCT c.cruiseRouteName ORDER BY c.cruiseRouteName ) AS cruiseRouteNames,以下是SQL,有知道的么:
SELECT
p.
,
s.id screenId,
s.screenName,
s.screenData,
GROUP_CONCAT( DISTINCT c.cruiseRouteName ORDER BY c.cruiseRouteName ) AS cruiseRouteNames
FROM
tb_preset p
LEFT JOIN tb_screenArea s ON
p.id = s.presetIndexId
LEFT JOIN tb_cruise c ON
FIND_IN_SET( p.presetId,
c.presetIds )
AND c.ipcId = p.ipcId
WHERE
p.ipcId = 1377
GROUP BY
p.presetId
ORDER BY
p.presetId;

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