导出数据SQL参考

select * from T_BD_Customer where fid ='y6gAAAA0KNy/DAQO'

select * from T_BD_CUSTOMERCOMPANYINFO where  FCustomerID ='y6gAAAA0KNy/DAQO'

1.做好表的备份

2.根据已有数据，写出客户新增的sql

insert into xxx ()

3.修改fid的方法




SELECT * FROM T_ORG_BaseUnit

SELECT * FROM T_BD_AccountBanks where FCONTROLUNITID = (SELECT FID  FROM T_ORG_BaseUnit where FNUMBER = '01.06.01')


SELECT * FROM T_BD_Supplier where FCONTROLUNITID = (SELECT FID  FROM T_ORG_BaseUnit where FNUMBER = '01.06.01')


SELECT * FROM T_BD_Customer where FCONTROLUNITID = (SELECT FID  FROM T_ORG_BaseUnit where FNUMBER = '01.06.01')


SELECT * FROM T_BD_AccountView where FCONTROLUNITID = (SELECT FID  FROM T_ORG_BaseUnit where FNUMBER = '01.06.01')


SELECT * FROM T_BD_Project









SELECT * FROM T_BD_Customer where FID = 'y6gAAAAD27C/DAQO'
SELECT FName_L2  FROM T_BD_Customer where FName_L2 = '张江基金'
SELECT * FROM T_BD_Customer where FNUMBER = 'LGZH-N203'
SELECT * FROM T_BD_Customer






INSERT INTO T_BD_Customer (FID ,FCREATORID,FName_L2,FCREATETIME ,FCONTROLUNITID,FNUMBER,FADDRESS,FTXREGISTERNO,FUSEDSTATUS,FEFFECTEDSTATUS) VALUES ((select newbosid('BF0C040E')),'y6gAAAAAA/LM567U','N-204','2021-06-08 15:46:57','LGZH-N204','256c221a-0106-1000-e000-10d7c0a813f413B7DE7F','测试地址','204',1,2)

INSERT INTO T_BD_Customer(FID,FCREATORID,FCREATETIME,FCONTROLUNITID,FName_L2,FNUMBER,FUSEDSTATUS ,FBROWSEGROUPID,FTXREGISTERNO,FEFFECTEDSTATUS) VALUES((select newbosid('BF0C040E')),'256c221a-0106-1000-e000-10d7c0a813f413B7DE7F','2021-06-07 14:07:56','y6gAAAAABA/M567U','N-206','LGZH-N206',1,'y6gAAAAAZHp6JWmi','206',2)

SELECT * FROM T_BD_Customer where FADDRESS = '测试地址'

SELECT * FROM T_BD_Customer where FTXREGISTERNO = '201'

select newbosid('BF0C040E')
select newbosid('BF0C040E')
LGZH-0032
LGZH-0032