export to ./tbl_zzf_order.del of del select ORDER_ID, USER_ID, AMOUNT, MERCHANT, ORDER_ST, REC_UPD_TS, REC_CRT_TS FROM TBL_ZZF_ORDER where REC_UPD_TS between timestamp('2017-01-01 00:00:00') and timestamp('2017-09-18 23:59:59') and ORDER_ST in ('01','03') with ur;
import from ./tbl_zzf_order.del of del insert into TBL_ZZF_ORDER (ORDER_ID, USER_ID, AMOUNT, MERCHANT, ORDER_ST, REC_UPD_TS, REC_CRT_TS);
import from ./tbl_zzf_order.del of del insert into TBL_ZZF_ORDER (ORDER_ID, USER_ID, AMOUNT, MERCHANT, ORDER_ST, REC_UPD_TS, REC_CRT_TS);
本文介绍了一种从TBL_ZZF_ORDER表中导出特定状态的订单数据的方法,并将其重新导入同一表的过程。筛选条件包括更新时间范围及订单状态。
982

被折叠的 条评论
为什么被折叠?



