数据清理SQL
1064244487 5月前

DELETE FROM `sd_order` WHERE  `time` < '2026-04-30 23:59:59';
DELETE FROM `sd_kami` WHERE `status`=1 and `time` < '2026-04-30 23:59:59';
DELETE FROM `sd_subprofit` WHERE  `time` < '2026-04-30 23:59:59';
DELETE FROM `sd_record` WHERE  `time` < '2026-04-30 23:59:59';
DELETE FROM `sd_recharge` WHERE  `time` < '2026-04-30 23:59:59';
DELETE FROM `sd_log` WHERE  `time` < '2026-04-30 23:59:59';
DELETE FROM `sd_orderDetail` WHERE  `time` < '2026-04-30 23:59:59';

 

1.订单 2.已售卡密 3.分站利润明细 4.会员余额变动明细 5.充值明细 6.操作日志 7.订单ip

最新回复 (0)
返回
1064244487