SELECT fittingsequipinfo.fittingID, fittingName, price, GROUP_CONCAT( DISTINCT `fittingCategory`
ORDER BY `fittingCategory`
SEPARATOR "," ) AS re,GROUP_CONCAT( `Equipmentamount`
ORDER BY `fittingCategory`
SEPARATOR "," ) AS re2FROM `fittingsequipinfo`
LEFT JOIN fittingsinfo ON fittingsequipinfo.fittingID = fittingsinfo.fittingID
GROUP BY fittingID
第一个GROUP_CONCAT 没什么问题,但是第二个有问题了,因为 `Equipmentamount` 是int,而不是varchar
ORDER BY `fittingCategory`
SEPARATOR "," ) AS re,GROUP_CONCAT( `Equipmentamount`
ORDER BY `fittingCategory`
SEPARATOR "," ) AS re2FROM `fittingsequipinfo`
LEFT JOIN fittingsinfo ON fittingsequipinfo.fittingID = fittingsinfo.fittingID
GROUP BY fittingID
第一个GROUP_CONCAT 没什么问题,但是第二个有问题了,因为 `Equipmentamount` 是int,而不是varchar
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货