MySQL5.7更新json类型字段中的某个key的值 函数json_replace()
UPDATE statement SET detail=json_replace(detail, '$.jszq', "2021年07月31日")
SELECT * from statement
where generator_id in (SELECT generator_id from generator_sn where generator_sn in (
'1383203822',
'1383280023',
'1384261807',
'1385155053',
'1385157192',
'1385463451'
));
