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

1、往往我们要修改数据库后台表是都需要咸犴孜稍先把原来执行前的数据进行备份操作，如下：例如修改总账辅助核算后台表，备份-修改供应商辅助核算；create ta芟鲠阻缒ble ncdata.gl_freevalue_bak_20181214 asselect * from ncdata.gl_freevalue where freevalueid in('1001H21000000349PM2I','1001H210000003D1N71U');--辅助核算commit;create table ncdata.gl_docfree1_bak_20181214 asselect * from ncdata.gl_docfree1 where assid in('1001H21000000349PM2I','1001H210000003D1N71U');--辅助项目commit;

3、执行-修改供应商辅助核算；update ncdata.gl_freevalue 衡痕贤伎set TYPEVALUE1='0001Z0100000000005CV0001H210000003TCM5M1' where freevalueid in('1001H21000000349PM2I','1001H210000003D1N71U');--辅助核算commit;update ncdata.gl_docfree1 set F4='0001H210000003TCM5M1' where assid in('1001H21000000349PM2I','1001H210000003D1N71U');--辅助项目commit;

5、回滚-修改供应商辅助核算；up蟠校盯昂date 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;