DELETE FROM `wp_order` where `status` = 0 limit 100
其中
limit 100
是指定执行多少行
去掉代表执行所有的
这是将以下状态的数据库订单弄成待分账
UPDATE `fz_receiver_list` SET status=0 WHERE `reason` = '对同笔订单分账频率过高'; UPDATE `fz_receiver_list` SET status=0 WHERE `reason` = '订单处理中,请稍后重试'; UPDATE `fz_receiver_list` SET status=0 WHERE `reason` = '系统繁忙,请稍后重试'; UPDATE `fz_receiver_list` SET status=0 WHERE `reason` = '你的操作过于频繁,请稍后再试'; UPDATE `fz_receiver_list` SET status=0 WHERE `reason` = '请求频率过高,请降低频率后再试。'; DELETE FROM `fz_receiver_list` WHERE `reason`='商户分账单号已经存在,请确认是否并发请求';
数据库中将哪天的订单进行解冻
UPDATE `fz_receiver_list` SET status=0 WHERE `reason` = '订单处理中,请在到达结算周期之后再请求分账' and datetime like '%2022-10-11%';
这个是查询9状态订单的列表
SELECT * FROM `fz_receiver_list` WHERE `status`=9
将状态为9待处理改成0未执行
UPDATE `fz_receiver_list` SET `status` = 0 WHERE `status` = 9
本文作者为senhuo,转载请注明。