对查询出来的数据进行递增修改

最新推荐文章于 2020-11-24 18:02:36 发布

晨曦遇晓

最新推荐文章于 2020-11-24 18:02:36 发布

阅读量719

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/u014508939/article/details/81485779

版权

数据库专栏收录该内容

46 篇文章 1 订阅

订阅专栏

UPDATE shopping_goods a INNER JOIN
(SELECT go.id,go.goods_price,@var1:=@var1+50 addprice FROM (
SELECT goods.id,
       goods.addTime AS 'add_time',
       goods.goods_name,
       goods.goods_price,
       goods.activity_status,
       goods.promo_price promo_price,
       goods.modify_time,goods.goods_price_low,
       goods.goods_price_high,
       goods.promo_price_low,
       goods.promo_price_high,
       store.id store_id,
       store.store_name,
       brand.name goods_brand,
       ugc2.id store_first_class,
       ugc1.id store_second_class,
       CONCAT(acc.path,'/',acc.name) goods_photo_path,
       CONCAT(acc2.path,'/',acc2.name) goods_recommend
FROM shopping_goods goods
LEFT JOIN shopping_store store ON goods.goods_store_id=store.id
LEFT JOIN shopping_goodsbrand brand ON brand.id=goods.goods_brand_id
LEFT JOIN shopping_goods_ugc u ON u.goods_id=goods.id
LEFT JOIN shopping_usergoodsclass ugc1 ON u.class_id=ugc1.id
LEFT JOIN shopping_usergoodsclass ugc2 ON ugc1.parent_id=ugc2.id
LEFT JOIN shopping_goods_sku sku ON goods.id=sku.goods_id
LEFT JOIN shopping_accessory acc ON goods.goods_main_photo_id=acc.id
LEFT JOIN shopping_accessory acc2 ON goods.goods_recommend=acc2.id
WHERE
goods.goods_status=0
AND goods.addTime BETWEEN '2018-03-11 09:46:55' AND '2018-03-11 09:48:10'
GROUP BY goods.id
) AS go,(SELECT @var1:=0) t ORDER BY go.id)b ON a.id=b.id
SET a.goods_price=b.goods_price+b.addprice