mysql json格式化
mysql数据库版本5.7+select result from dam_common_job_result where job_id = 28; 将json字符串中的batchNumber取出采用mysql内置语法JSON_EXTRACT来解析字符串select JSON_EXTRACT(result, '$.resultMap."2".batchNumber') as batchNumber from dam_common_job_result where job_id = 28; 虽然得到结果,但是
原创
2022-07-05 11:07:13 ·
703 阅读 ·
0 评论