清理销售

1. 订单已经完成单未上传的数据

SELECT *  FROM x_orders  WHERE ( x_orders.done = 1 ) And ( x_orders.flag = '0' );

2. 清空数据

truncate table X_fkd;
truncate table x_fktz;
truncate table X_xsd;
truncate table x_xstz;
truncate table x_orders;
truncate table x_order;
truncate table x_order_details;
truncate table x_zfb_jytz;
truncate table x_bmpcoupon;
truncate table x_skpcoupon;