谁知道MYSQL有没有类似多表查询的、但是是实现update的功能?
比如:
Table A
商品,商铺ID,货物名称.....
1 ,1,xxxx
2,3,zzzzzTable B
id,商品ID,价格,....
1,1,100
2,1,200我要实现update [B] set 价格=12345 where B.商品ID=A.商品ID and A.商铺ID=5 and B.商品ID=1请问如何写SQL?新人分不多
比如:
Table A
商品,商铺ID,货物名称.....
1 ,1,xxxx
2,3,zzzzzTable B
id,商品ID,价格,....
1,1,100
2,1,200我要实现update [B] set 价格=12345 where B.商品ID=A.商品ID and A.商铺ID=5 and B.商品ID=1请问如何写SQL?新人分不多
set b.价格=12345
where A.商铺ID=5 and B.商品ID=1
[ecm_goods]
goods_id store_id [ecm_goods_spec]
spec_id goods_id price stock第一种:
update ecm_goods_spec,ecm_goods set ecm_goods_spec.price=12345
where ecm_goods.store_id=2 and ecm_goods_spec.goods_id=1 and ecm_goods_spec.goods_id=ecm_goods.goods_id第二种:
UPDATE ecm_goods_spec INNER JOIN ecm_goods ON ecm_goods.goods_id = ecm_goods_spec.goods_id SET ecm_goods_spec.price =12345 WHERE ecm_goods.store_id =2 AND ecm_goods_spec.goods_id =1另请大家说说那种效率高一点,谢谢。