Question

SQL怎么把一个表字段信息(ID)修改为对应另一个表的内容

A表 B表

A表、B表都有address_ID这一列，B表中的addressname是address_ID对应的具体内容。请问，如何将A表中的address_ID改为B表中对应的addressname?
1楼、2楼你们的回答确定是sql sever上的语句吗？？





Answer 1

update A set A.address_ID=B.addressname from A inner join B on A.address_ID = B.address_ID

Answer 2

sqlserver:
update A set A.address_ID=B.addressname from B where A.address_ID=B.address_ID
不过你的A表中这个ID值要是字符型才可以啊

Answer 3

update A表
set address_ID =
(
select address_ID
from B表
where A表.addressname = B表.addressname
)

Answer 4

update 最基本语句……