mysql多表联合更新 的 三种方法

mysql多表联合更新

方法 1

UPDATE fsc_goods as g,fsc_goods_spec as s set g.goods_storage=s.spec_goods_storage where g.goods_id=s.goods_id  and goods_from=1

方法 2 选用JOIN来实现的语句

update goods as g inner join goods_spec as s on g.goods_id= s.goods_id  set g.goods_storage= s.spec_goods_storage where s.goods_from=1

方法 3  用SELECT的原语句:

update spms.user  set DirectReport=(select DirectReport from spms.user where UserName='%s')  where UserName in (select UserName from spms.user where DirectReport='%s')

#使用过的语句
UPDATE fsc_fgoods SET venderId = (SELECT store_id from fsc_goods WHERE fsc_goods.goods_id = fsc_fgoods.supplier_goods_id);

方法 1 和方法2 用过 方法3没用过 . 记录一下备用