SELECT
CONCAT('[',
GROUP_CONCAT(
CONCAT('{"mode":"',ifnull(`mode`,''),'"'),',',
CONCAT('"teu":"',ifnull(`teu`,'0'),'"'),
CONCAT(',"type":"',ifnull(`type`,'')),'"}')
,']')
FROM Extend_JobShipment
Mysql 拼接json
于 2022-04-06 18:32:32 首次发布