清库脚本

最新推荐文章于 2024-02-10 12:03:42 发布
最新推荐文章于 2024-02-10 12:03:42 发布
阅读量433 收藏
点赞数
原文链接：https://my.oschina.net/u/3198970/blog/882595
版权

--清库脚本说明：
--   prtno:  01030100000005
--   '01010111000002','01010111000003','01010111000004','01010111000005','01010111000006','01010111000002','01010111000003','01010111000004','01010111000005','01010111000006'
--   '01010111000007','01010111000008','01010111000009','01010111000010'
--   grocontno :  654201700002558
--前3个 contno 是个人   后面是团体
--   contno:  '154201600002048','154201600000808','154201600001698',

--   '154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'
--   '154201700009808','154201700009918','154201700010048','154201700010158'


--删除银行账户  第一个是团体，后3个是个人的
delete from LYBankLog;
delete from lcbankacc a  where a.businessno not in ('01010111000007','01010111000008','01010111000009','01010111000010','01010111000001',
'01010111000002','01010111000003','01010111000004','01010111000005','01010111000006','01010111000002','01010111000003','01010111000004','01010111000005','01010111000006','01030100000005','01010120160802','01010120160810','01010122170101');

--影像删除脚本(第一个是团体prtno,后3个是个单埋单的prtno)
delete from es_doc_pages where docid not in (select docid from es_doc_main where doccode in ('01010111000007','01010111000008','01010111000009','01010111000010','01010111000001',
'01010111000002','01010111000003','01010111000004','01010111000005','01010111000006','01010111000002','01010111000003','01010111000004','01010111000005','01010111000006','01010111000002','01010111000003','01010111000004','01010111000005','01010111000006','01010111000003','01010111000004','01010111000005','01010111000006','01030100000005','01010120160802','01010122170101','01010120160810'));
delete from es_doc_property  where docid not in (select docid from es_doc_main where doccode in ('01010111000007','01010111000008','01010111000009','01010111000010','01010111000001',
'01010111000002','01010111000003','01010111000004','01010111000005','01010111000006','01030100000005','01010120160802','01010122170101','01010120160810'));
delete from es_doc_relation where docid not in (select docid from es_doc_main where doccode in ('01010111000007','01010111000008','01010111000009','01010111000010','01010111000001',
'01010111000002','01010111000003','01010111000004','01010111000005','01010111000006','01030100000005','01010120160802','01010122170101','01010120160810'));
delete from es_doc_main where doccode not in ('01010111000007','01010111000008','01010111000009','01010111000010','01010111000001',
'01010111000002','01010111000003','01010111000004','01010111000005','01010111000006','01030100000005','01010120160802','01010122170101','01010120160810');

--暂存费

delete   from  LJTempFee where otherno not in ('01010111000007','01010111000008','01010111000009','01010111000010','01010111000001',
'01010111000002','01010111000003','01010111000004','01010111000005','01010111000006','01010120160802','01010122170101','01010120160810');
delete   from  LJTempFeeClass where tempfeeno not in  (select LJTempFee.Tempfeeno from  LJTempFee where otherno in ('01010111000007','01010111000008','01010111000009','01010111000010','01010111000001',
'01010111000002','01010111000003','01010111000004','01010111000005','01010111000006','01010120160802','01010122170101','01010120160810'));
delete   from  LACommisionDetail where grpcontno not in ('654201700002558');


--保单删除脚本(3个是个单，后面都是团单的)
delete   from  lcaddress where customerno not in (
select appntno from  lccont where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'
) union
(select insuredno from  lccont where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'
)));

--防止上期做过保全地址修改，而导致地址变化
UPDATE lcaddress SET postaladdress = '西藏拉萨城关区江苏东路茂源小区3号301室'
WHERE customerno = '0001258106' and modifydate >= date '2017-04-05';
UPDATE lcaddress SET homeaddress = '茂源小区3号301室'
WHERE customerno = '0001258106' and modifydate >= date '2017-04-05';
UPDATE lcaddress SET street = '江苏东路'
WHERE customerno = '0001258106' and modifydate >= date '2017-04-05';


delete   from  LACommisionDetail where grpcontno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'
);
delete   from  lcbnf where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'
);


delete   from  LCPrem where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  LCGet where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'
);
delete   from  LCAppnt where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'
);
delete   from  LCInsured where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  LCContState where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  LOloan where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');


delete   from  LASPayPerson where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  LJAPayPerson where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  LJAPay where incomeno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  LJSPayPerson where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  LJSPay where otherno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  LJSGet where otherno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  LJAGet where otherno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  ljagetendorse where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  lobonuspol where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'); 
delete   from  lcinsureacc where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  lcinsureaccclass where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'); 
delete   from  lcinsureacctrace where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  lcinsureaccfee where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  lcinsureaccclassfee where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  lcinsureaccfeetrace where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
--12.27新增
delete from LCUWError where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete from LCCUWError where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete from LCIndUWError where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');

--理赔保单恢复脚本
delete from  llclaim where clmno in (select clmno from  llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));

delete from  llbnf  where clmno in (select clmno from  llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));

delete from  Llreportrela;
delete from  llclaimdetail  where clmno in (select clmno from  llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));
delete from  ljagetclaim  ;
--where otherno in (select clmno from  llclaimpolicy where contno in (
--'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));
delete from  llbalance  where clmno in (select clmno from  llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));

delete from  llcaserela   where caseno in (select caseno from  llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));
delete from  llaccident where accno in 
(select caserelano from  llcaserela where caseno in (select caseno from  llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718')));
delete from llclaimdutykind where clmno in (select clmno from llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));
delete from llclaimdutyfee where clmno in (select clmno from llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));
delete from llappclaimreason where caseno in (select caseno from llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));
delete from llaccidentsub where customerno in (select appntno from lccont where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));
delete from  lcconthangupstate where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete from  LLToClaimDuty where  caseno in (select caseno from llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));

delete from llaffix where rgtno in (select rgtno from llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));         
delete from  LLAccidentSub where AccNo in (select caserelano from llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));
delete from  llfeemain where clmno in (select clmno from llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));
delete from  LLToClaimDutyFee a  where 1 = 1 and a.ClmNo in (select clmno from llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));
delete from lccontstate c where c.contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718') and c.statetype = 'Terminate' and c.state = '1';
delete  from  llclaimpolicy where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');

update ldperson set deathdate = '' where customerno in (select appntno from lccont where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));
update ldperson set deathdate = '' where customerno in (select cc.insuredno from lccont cc where cc.contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718'));
update lccont set appflag = '1' where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
update lcpol set appflag = '1' where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
--保全
update lccont set autopayflag ='1'  where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
update lcpol set autopayflag ='1'  where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');

update lcget set Summoney = '0'  where contno in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');

--理赔
delete from Ljfiget;
delete from LLAppClaimReason;
delete from  llcase;
delete   from  LLCLAIMUWMAIN;
delete from LLREPORTREASON;

delete from LLREPORTAFFIX ;
delete from LLSUBREPORT;
delete from  llreport;
delete from  llregister;
delete   from  LCDuty where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete   from  LCPol where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');

--工作流删除脚本
delete from lpedoritem;
delete from lpedorapp;
delete from lpedormain;
delete from lpedorprint;
delete from ljsgetendorse;
delete from ljagetendorse;
delete from lwmission;
delete from lbmission;
delete from lcconthangupstate;
delete from LCGRPCONTHANGUPSTATE;


delete from FIOperationLog ;
delete from FIOperationParameter;
delete from FIDataFeeBackApp;
delete from Fiinterfacelog;
DELETE from ljotofinfo;
Delete from fidatatransresult;
Delete from FiInterfaceInfo;
delete from CUX_LP_GL_INTERFACE;

delete from LCINSURED where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete from LCCUSTOMERIMPART where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete from LCCont where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');
delete from lccontplanfee where contno not in (
'154201700009808','154201700009918','154201700010048','154201700010158','154201600002268','154201600002378','154201600002488','154201600002598','154201600002608',
'154201600002048','154201600000808','154201600001698','130540000000725','130540000000726','130540000000727','130540000000728','130540000000729','130540000000730','130540000000731','130540000000732','130540000000733','130540000000734','154201600002718');

--团险清库脚本
delete from ldgrp where customerno not in (select appntno from lccont where grpcontno = '654201700002558');
delete from lcgrpcont where grpcontno not in ('654201700002558');
delete  from LCGCUWSUB where grpcontno  not in ('654201700002558');
delete  from LCGCUWMASTER where grpcontno  not in ('654201700002558');
delete  from LCGRPAPPNT where grpcontno  not in ('654201700002558');
delete  from LCGUWERROR where grpcontno  not in ('654201700002558');
delete  from LCGUWSUB where grpcontno  not in ('654201700002558');
delete  from LCGUWMASTER where grpcontno  not in ('654201700002558');
delete  from LCGRPPOL where grpcontno  not in ('654201700002558');
delete  from LCGRPISSUEPOL  where grpcontno  not in ('654201700002558');
delete  from LPGRPPOL ;
delete  from LPGRPCONT ;
delete  from LPGRPEDORITEM ;
delete  from LPGRPEDORMAIN ;
delete  from lccontplan where grpcontno  not in ('654201700002558');
delete  from lccontplandutyparam where grpcontno  not in ('654201700002558');
delete  from lccontplanfactory where grpcontno  not in ('654201700002558');
delete  from lccontplangetdutyparam where grpcontno  not in ('654201700002558');
delete  from lccontplanparam where grpcontno  not in ('654201700002558');
delete  from lccontplanrisk where grpcontno  not in ('654201700002558');
delete  from LJAPayGrp;


 

转载于:https://my.oschina.net/u/3198970/blog/882595

chuyan6466
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mysql清库脚本_一个清空数据库并初始化的脚本
weixin_39867066的博客
02-04 1282
经常要清空数据库,于是写了一个小脚本,还是学到很多东西.1.保留数据表结构,只删除所有表数据方法1:导出一个没有数据的数据库,再drop原来的数据库,create 一个新的(空的,没有表结构),再source一下之前导出的没有数据的sqlmysqldump -u${USERNAME} -p${PASSWORD} -h${HOSTNAME} ${DATABASE} --no-data >vil...
脚本
zengquan2014的博客
11-15 490
emp脚本 prompt Importing table emp... set feedback off set define off insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values (7369, 'SMITH', 'CLERK', 7902, to_date('17-12-1980
MySQL数据库自动备份与清理脚本
03-20
1、mysql数据库自动备份与清理 2、支持mysql 5.7与mysql 8.0 3、基于mysql enterprise backup备份 4、支持备份数据通过ftp上传或通过rsync上传 5、支持自定义备份数据定期清理
一个清空数据库数据的脚本总结
a15105311557的博客
02-02 325
测试时,有时要清空数据库很多数据,由于有些表有关联,所以干脆所有表数据都清除. 我的思路是:先备份一个只有表结构的sql,再备份一些保存业务配置的表,再把原来的数据库drop,再创建一个新的数据库,再source一下还原表结构,再还原保存业务配置的表.由于经常要清空数据库,于是写了一个小脚本,还是学到很多东西. 这个小脚本花了两天时间,我是做测试的,也是一个很怕代码的人,一直在逃避.有时...
activiti 清库脚本
jackyrongvip的专栏
07-19 445
activiti 清库脚本 DELETE FROM `act_hi_attachment`; DELETE FROM `act_hi_comment`; DELETE FROM `act_hi_detail`; DELETE FROM `act_hi_actinst`; DELETE FROM `act_hi_identitylink`; D...
MySQL定时备份及清理脚本（一劳永逸）-改良版本
l6xy6的博客
02-10 1880
MySQL定时备份及清理脚本（一劳永逸）-改良版本 四 脚本赋权，linux自带定时任务工具配置 chmod +x save-all-data.sh crontab用法： crontab -e 编辑工作表 crontab -l 列出工作表中的命令 cro
R5清库脚本.rar清库脚本
04-09
标题为“R5清库脚本.rar”的压缩包文件，很显然，它提供了一个用于清理特定R5系统数据库的脚本。R5可能是指某个软件系统的版本号，这可能是企业资源规划（ERP）、客户关系管理（CRM）或其他业务系统的一部分。 在...
Sql清库脚本
04-24
Sqlserver的清库脚本，清空数据库中指定表的数据但不会删除表与表之间的关系...
清库脚本，als745
12-11
清理业务数据
maven仓库清理脚本
10-18
手动清理这些失败的依赖既耗时又可能遗漏，因此，使用自动化脚本来完成这项工作变得尤为重要。 "Maven仓库清理脚本"就是为了解决这个问题而设计的。这个脚本能够智能地检测并移除本地Maven仓库中那些下载不完全或者...
沃通知清库脚本全部.sql
10-24
沃通知清库脚本全部.sql
mysql清库脚本_MySQL binlog 自动清理脚本
weixin_39832829的博客
02-19 255
MySQL binlog 自动清理脚本# vim /data/scripts/delete_mysql_binlog.sh#!/bin/bash#=======================================================================================# 用于删除 MySQL Master 端已经同步完的 binlog【需在 ...
ORA-27300的临时处理方法。
wlp_name的专栏
11-06 689
http://space.itpub.net/16158219/viewspace-590998 点7oracle报错如下： Thu Oct 13 14:04:46 2011 Errors in file d:\oracle\product\10.2.0\admin\ctcmc\bdump\ctcmc_psp0_1036.trc: ORA-27300: OS system dependen
抓取oracle数据库耗费资源的sql语句
weixin_34026276的博客
08-14 132
oracle数据库连接业务系统，而有些sql语句的执行严重影响了oracle的性能，就如同mysql的慢查询一样，mysql可以开启慢查询日志定位这些造成数据库性能下降的语句，而oracle同样可以做到，而且有过之而无不及。 下面举例说明 首先用root用户登陆核心应用系统，su - oracle 执行命令 topas 可以查看...
智能锁（远程开锁、指纹开锁、密码开锁、刷卡开锁）
最新发布
07-19
按键功能：输入密码，并能根据密码来决定开门还是进入管理员模式 密码功能：能够更换开门密码/管理员密码，且具有掉电不丢失功能 刷卡功能：能够判断卡片是否登记；刷卡开门；删除/登记开门卡片 指纹功能：指纹开门；删除/登记指纹 语音功能：播放不同功能的语言提示 门铃功能：机械开关控制门铃响 阿里云服务器接入：连接阿里云服务器，可以上报设备信息，也可以通过服务器端无线控制，如修改密码、恢复出厂设置、调节音量大小、远程开门等
qinglong脚本库去重.py
06-20
### 回答1： 清龙脚本库去重.py是一个用于去除数据重复的Python脚本库。该脚本通过对数据进行分组，去重和合并的方式，能够有效地去除数据中重复的元素。 通过使用清龙脚本库去重.py，用户可以轻松地去除数据表中的重复数据，以提高数据的准确性和可靠性。此外，该脚本库还支持对多个数据表进行去重，并生成唯一的结果表。 清龙脚本库去重.py还支持多种数据类型，包括文本，数字，日期和时间等。用户可以根据自己的需要选择合适的数据类型进行去重。 使用清龙脚本库去重.py还可以大幅提高数据处理效率，因为它可以快速处理大量数据，并在处理完成之后返回结果。 总之，清龙脚本库去重.py是一个非常好用的数据去重工具，它可以帮助用户高效地处理数据，提高数据质量和准确性。无论是个人用户还是企业用户，都可以从中获得巨大的收益。 ### 回答2： qinglong脚本库去重.py是一个Python脚本，主要功能是对青龙项目所管理的脚本库进行去重操作。这个脚本能够识别出脚本名称与脚本作者相同的脚本，并将它们合并为一个。这样操作可以避免脚本库中存在重复的脚本，让青龙项目更加清晰和便利。 在具体实现上，qinglong脚本库去重.py主要是通过读取青龙所管理的脚本文件夹下的所有.js文件，然后将它们的脚本名称和作者读入内存，并按照一定的规则对它们进行比对和去重。最后将结果写入特定的文件中，完成整个去重操作。 使用qinglong脚本库去重.py可以帮助青龙用户更好地管理他们的脚本库。这个脚本操作简单，功能实用，是青龙用户们进行脚本管理的好帮手。 ### 回答3： qinglong脚本库去重.py是一个Python脚本，用于去除青龙脚本库中的重复脚本。青龙脚本库是一个用于管理和运行各种Python脚本的平台，但由于用户上传和删除不规范，可能会导致脚本库中出现重复的脚本。 qinglong脚本库去重.py的作用是通过对脚本库中每个脚本的MD5值进行比较，来判断脚本是否重复，并将重复的脚本进行删除。该脚本需要使用青龙面板的API接口来实现对脚本库的操作。 运行该脚本需要先配置好青龙面板的配置文件，并填写正确的API地址、用户名和密码。然后，在终端中运行该脚本，等待脚本执行完毕即可。 使用该脚本可以有效地清理青龙脚本库中的重复脚本，提高脚本库的使用效率和管理效果。但需要注意，在运行该脚本前，应备份好脚本库的数据，以便于出现问题时能够恢复。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值