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

试试这个查询-

SELECt  email,  GROUP_CONCAt(CONCAt('{name:"', name, '", phone:"',phone,'"}')) listFROM  table1GROUP 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"} |+---------------+-------------------------------------------------------------+