update B set uid = ss.id, addtime = ss.addtime from
(select * from A as tt where id = (select max(id) from A where name = tt.name) ss
where B.name = ss.name愉快的登山者 ⊙
◢◣◢◣◢◣
(select * from A as tt where id = (select max(id) from A where name = tt.name) ss
where B.name = ss.name愉快的登山者 ⊙
◢◣◢◣◢◣
具体怎么操作???