sql - 关联更新
两个表,a和b,字段都为(id,data)
现在要把a表里的data字段用b表里对应id相等的data值更新
语句如下:
update a
set data =
(select data
from b
where id= a.id)
where id in (select id from b);
两个表,a和b,字段都为(id,data)
现在要把a表里的data字段用b表里对应id相等的data值更新
语句如下:
update a
set data =
(select data
from b
where id= a.id)
where id in (select id from b);