1.清空REFILL_REPORT_YYS 表内容
truncate table REFILL_REPORT_YYS
2.将新增记录插入到REFILL_REPORT表中
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