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没用过 . 记录一下备用
(。・v・。)
喜欢这篇文章吗?欢迎分享到你的微博、QQ群,并关注我们的微博,谢谢支持。