没想到你是这种薯片的博客

SET SESSION "myapp.old" = '';SET SESSION "myapp.new" = '';UPDATE contract_work_calendar_use SET operation_user_name = current_setting ( 'myapp.new' ) WHERE operation_user_name = current_setting ( 'myapp.old' )

多表联合查询UPDATE contract_contract_file SET create_user_name = C.undertake_user_name, create_user_account = C.undertake_user_account FROM contract_contract AS C WHERE contract_id = C.ID AND contract_contract_file.TYPE = 1单表联合查询UPDATE contrac