mysql json group_如何用group-concat mysql创建json格式？

尝试这个查询 –

SELECT

email,

GROUP_CONCAT(CONCAT('{name:"', name, '", phone:"',phone,'"}')) list

FROM

table1

GROUP BY

email;

JSON格式结果 –

+---------------+-------------------------------------------------------------+

| email | list |

+---------------+-------------------------------------------------------------+

| my1@gmail.com | {name:"Ben", phone:"6555333"},{name:"Joi", phone:"3434356"} |

| my2@gmail.com | {name:"Tom", phone:"2322452"},{name:"Dan", phone:"8768768"} |

+---------------+-------------------------------------------------------------+