update a set a.name=(select b.name from b where a.id=b.id),a.adress=(select b.address from b where a.id=b.id)
------补充------ update a set a.name=(select b.name from b where a.id=b.id),a.adress=(select b.address from b where a.id=b.id) where a.nameb.name or a.addressb.address
