#庆丰电商买家版后台服务 更新数据库,order_goods表新增了order_store_id字段 UPDATE order_goods og LEFT JOIN order_store os on og.trade_id=os.trade_id and og.store_id=os.store_id SET og.order_store_id=os.id

UPDATE after_sell a
LEFT JOIN order_goods og on og.id=a.order_goods_id LEFT JOIN order_store os on og.order_store_id=os.id SET a.goods_id=og.goods_id, a.goods_pic=og.goods_pic, a.goods_name=og.goods_name, a.goods_attrs=og.goods_attrs, a.store_id=og.store_id, a.order_store_code = os.code

UPDATE goods_common SET recommend=activity_id

//更新属性 内容 INSERT INTO attr_value(id,attr_id,attr,attr_value) SELECT ga.value_id,ga.attrs_id,a.NAME,ga.value FROM goods2attrs ga LEFT JOIN attr a on a.id=ga.attrs_id GROUP BY ga.value_id

//跟新ordergoods 的goodsCommonId UPDATE order_goods og LEFT JOIN goods g on og.goods_id=g.id SET og.goods_common_id=g.goods_common_id

//更新商品属性的goodscommonId UPDATE goods2attrs ga LEFT JOIN goods g on ga.goods_id=g.id SET ga.goods_common_id=g.goods_common_id

#第二次更新

更新商品指定物流类型

UPDATE goods_common
SET logistics_type=NULL