需要实时变动用触发器不实时变动用updateupdate 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