dao分销未全部完成处理方案

2022-12-02 11:07:22 阅读:1 编辑
# 2022112415250088057为从这笔订单开始卡住
select * from ims_zhyshop_sun_daoshangorder where order_no="2022112415250088057";
# 243799为ims_zhyshop_sun_daoshangorder的id
select * from ims_zhyshop_sun_daoshangdetail where order_id =243799;
# 243800为ims_zhyshop_sun_daoshangdetail的id
select * from ims_zhyshop_sun_daoshangdetailex where detail_id =243800;

删除前把要删除的SQL语句备份起来(!!!!)

删除查询出来的数据(只能以下两个表)

ims_zhyshop_sun_daoshangdetail ims_zhyshop_sun_daoshangdetailex