UPDATE info1 t1 JOIN info2 t2
ON t1.name = t2.name
SET t1.age = t2.age, t1.class = t2.class;
update ads_yhfz_blxx_v1 a join code_town b
on b.name=a.xzdzjd
set a.xzdz_code=b.code,
a.xzdzsf_code=b.province,
a.xzdzcs_code=b.city,
a.xzdzqx_code=b.area,
a.xzdzjd_code=b.town;