update t_coupon c LEFT JOIN temp_coupon tc on tc.platform_coupon_id=c.coupon_id set c.use_stock=c.use_stock+tc.employ ,c.get_stock=c.get_stock+tc.issue where c.coupon_id = tc.platform_coupon_id
sql 修改数据关联表进行条件筛选
最新推荐文章于 2024-04-02 16:45:22 发布
update t_coupon c LEFT JOIN temp_coupon tc on tc.platform_coupon_id=c.coupon_id set c.use_stock=c.use_stock+tc.employ ,c.get_stock=c.get_stock+tc.issue where c.coupon_id = tc.platform_coupon_id