执行mysql备份语句_常见的数据库后台脚本备份执行回滚语句

回滚-修改供应商辅助核算；

update ncdata.gl_freevalue set TYPEVALUE1=

(select TYPEVALUE1 from ncdata.gl_docfree1_bak_20181214 where freevalueid in('1001H21000000349PM2I','1001H210000003D1N71U') )

where freevalueid in('1001H21000000349PM2I','1001H210000003D1N71U');--辅助核算

commit;

update ncdata.gl_docfree1 set F4=

(select F4 from ncdata.gl_docfree1_bak_20181214 where assid in('1001H21000000349PM2I','1001H210000003D1N71U') )

where assid in('1001H21000000349PM2I','1001H210000003D1N71U');--辅助项目

commit;