数据库执行命令

森活哥 502
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

分享