A表
id username address
1 aa
2 bb
3 cc B表
id username address
1 uu abc
2 mm bcd
3 dd oujA,B表比较如果ID 相同 则将B表的ADDRESS 复制到A表中
用SQL语句实现
id username address
1 aa
2 bb
3 cc B表
id username address
1 uu abc
2 mm bcd
3 dd oujA,B表比较如果ID 相同 则将B表的ADDRESS 复制到A表中
用SQL语句实现
from A join B on a.ID=B.ID
set a.address=b.address
from a,b
where a.ID=b.ID
from A left join B on A.ID=B.ID
掉了from update a set address=b.address from a,b where a.id=b.id