zxy_mark/mysql数据库解析json 并导出语句/footscan_json_extract.md

SELECT  foot_scan_id,foot_scan_sign,measure_time,device_code,
JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(`wb_tbl_foot_scan`.`foot_scan_json`,'$.foot_info'),'$.left_info'),'$.length') AS left_length,
JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(`wb_tbl_foot_scan`.`foot_scan_json`,'$.foot_info'),'$.left_info'),'$.width') AS left_width,
JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(`wb_tbl_foot_scan`.`foot_scan_json`,'$.foot_info'),'$.left_info'),'$.height') AS left_width,
JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(`wb_tbl_foot_scan`.`foot_scan_json`,'$.foot_info'),'$.left_info'),'$.plantar_circumference') AS plantar_circumference,
JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(`wb_tbl_foot_scan`.`foot_scan_json`,'$.foot_info'),'$.right_info'),'$.length') AS left_length,
JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(`wb_tbl_foot_scan`.`foot_scan_json`,'$.foot_info'),'$.right_info'),'$.width') AS left_width,
JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(`wb_tbl_foot_scan`.`foot_scan_json`,'$.foot_info'),'$.right_info'),'$.height') AS left_width,
JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(`wb_tbl_foot_scan`.`foot_scan_json`,'$.foot_info'),'$.right_info'),'$.plantar_circumference') AS plantar_circumference
 FROM wb_tbl_foot_scan WHERE device_code = 'SCMD03001004' AND `measure_time` BETWEEN '2021-09-09 10:00:00' AND '2021-09-09 10:30:00'