-- 删除t1表中的t2表数据 然后再插入t2表数据 实现更新
delete from core.t_trans t1 WHERE EXISTS(SELECT t2.f_trans_id FROM pay_data_ext.r_ext_core_t_trans t2 WHERE t2.f_trans_id=t1.f_trans_id);
-- 插入
insert into core.t_trans select to_date(F_create_time::text,'YYYY-MM-DD'),* from pay_data_ext.r_ext_core_t_trans;