mysql修改json字段sql备份

update dec_main a,
            dec_main_copy20240110 b
            set a.ie_Date = b.ie_Date,
                    a.declaration_data = b.declaration_data,
                    a.custom_state = b.custom_state,
                    a.content = JSON_SET(a.content, '$.ieDate', json_extract(b.content,'$.ieDate')) , 
                    a.content = JSON_SET(a.content, '$.declarationData', json_extract(b.content,'$.declarationData')) , 
                    a.content = JSON_SET(a.content, '$.customState', json_extract(b.content,'$.customState'))  
        where a.cus_sourece ='91320600138342054Q' 
          and b.cus_sourece = '91320600138342054Q'  
          and a.entry_id = b.entry_id 
          and ifnull(a.entry_id,'-') != '-'
          and ifnull(b.entry_id,'-') != '-'  ;