每周充值记录导入流程

1.清空REFILL_REPORT_YYS 表内容
truncate table REFILL_REPORT_YYS 


2.将新增记录插入到REFILL_REPORT表中

insert into REFILL_REPORT

(trade_type,trade_num, refill_money,refill_time,trade_company,refill_state,zheng_chong,refill_clerk,province_company

,city_company,note,dt,charging_card,cell_phone_number,service_number,third_pay_number,if_payfilish,remark,pay_type) 

select 

trade_type,trade_num, refill_money,refill_time,trade_company,refill_state,zheng_chong,refill_clerk,province_company

,city_company,note,dt,charging_card,cell_phone_number,service_number,third_pay_number,if_payfilish,remark,pay_type from REFILL_REPORT_YYS