mysql取json中字段的数据

json内容:

取json的值:

select `date`,dev_seq AS devseq,
        json_extract(reading, '$.sharp' ) AS a,
        json_extract(reading, '$.peak' ) AS b,
        json_extract(reading, '$.flat' ) AS c,
        json_extract(reading, '$.valley' ) AS d,
        json_extract(reading, '$.total' ) AS f
        from device_daily_usage_electric