UPDATE `car_contract-1` set SaleId=SaleId+10000 WHERE SaleId<>'';
UPDATE `car_contract-1` set CntrNo=CONCAT(CntrNo,'1') WHERE CntrNo<>'';
UPDATE `car_contract-1` set CllOutNo=CONCAT(CllOutNo,'1') WHERE CllOutNo<>'';
UPDATE `car_contract-1` set SaleMan=CONCAT(substr(SaleMan,1,3),'某某') WHERE SaleMan<>'';
UPDATE `car_contract-1` set Name=CONCAT(substr(Name,1,3),'某',substr(Name,7)) WHERE Name<>'';
UPDATE `car_contract-1` set IdNo=CONCAT(substr(IdNo,1,6),'99999') WHERE IdNo<>'';
UPDATE `car_contract-1` set LicNo=CONCAT(substr(LicNo,1,4),'9999') WHERE LicNo<>'';
UPDATE `car_contract-1` set Tel=substr(Tel,1,8) WHERE Tel<>'';
UPDATE `car_contract-1` set Cell=substr(Cell,1,8) WHERE Cell<>'';
UPDATE `car_contract-1` set Adr=substr(Adr,1,12) WHERE Adr<>'';
UPDATE `car_contract-1` set Memo='' WHERE Memo<>'';

UPDATE `car_sale-1` set SaleId=SaleId+10000 WHERE SaleId<>'';
UPDATE `car_sale-1` set CarId=CarId+10000 WHERE CarId<>'';

UPDATE `car_pur-1` set RsvMemo='' WHERE RsvMemo<>'';
UPDATE `car_pur-1` set Supplier='汎德' WHERE Supplier<>'';
UPDATE `car_pur-1` set CarId=CarId+10000 WHERE CarId<>'';
UPDATE `car_pur-1` set SaleId=SaleId+10000 WHERE SaleId<>'';
UPDATE `car_pur-1` set FrNo7=CONCAT(substr(FrNo7,1,6),floor(rand()*10)) WHERE FrNo7<>'';
UPDATE `car_pur-1` set OrderNo=CONCAT(substr(OrderNo,1,6),floor(rand()*10)) WHERE OrderNo<>'';
UPDATE `car_pur-1` set CllInNo=CONCAT(CllInNo,'1') WHERE CllInNo<>'';

UPDATE `car_pur_a-1` set CarId=CarId+10000 WHERE CarId<>'';

UPDATE `car_finance-1` set SrcId=SrcId+10000 WHERE SrcId<>'';

UPDATE `des_contract-1` set CntrNo=CONCAT(CntrNo,'1') WHERE CntrNo<>'';

UPDATE `car_fina_rec-1` set SaleId=SaleId+10000 WHERE SaleId<>'';

UPDATE `car_fina_pay-1` set CarId=CarId+10000 WHERE CarId<>'';