会sql语言的来帮忙！

来源：百度知道 编辑：UC知道 时间：2024/05/04 12:58:39
ecs_goods_gallery 表的 img_original 字段内容 替换成 ecs_goods 表的 original_img 条件是 ecs_goods_gallery 表的 goods_id 和 ecs_goods 表的 goods_id 对应相等！
感谢1-3楼，不过不正确，xixinfeng，偶也是这样写的，不行。。。还是很感谢！

提高赏金，会sql的帮帮忙~~ 谢谢啦！

update ecs_goods_gallery a
set img_original =(select original_img from ecs_goods b
where b.goods_id =a.goods_id)
where exists (select 1
from ecs_goods b
where b.goods_id=a.goods_id
)
你看这个行不行，我在我的机子上实验的可以。

update ecs_goods_gallery set ecs_goods_gallery.img_original=ecs_goods.original_img
from ecs_goods_gallery,ecs_goods
where ecs_goods_gallery.goods_id=ecs_goods.goods_id
再试试这个 我运行了，肯定对

update ecs_goods_gallery set img_original = ecs_goods.original_img
from ecs_goods_gallery,ecs_goods
where ecs_goods_gallery.goods_id = ecs_goods.goods_id

相当简单的
update ecs_goods_gallery
set img_original=b.original_img
from ecs_goods_gallery a ,ecs_goods b
where a.goods_id=b.goods_id

from ecs_goods_gallery a ,ecs_goods b 这句语句句形不能改变必须把ecs_goods_gallery 放在前面.

updata ecs_goods_gallery
set ecs_goods_gallery .img_original =ecs_