--1
update o2o_shop_info_app a set citycode=(select id from shop_area b
where a.city1=b.areaname
)
where pt_name='饿了么h5' and province1='河北省'


--2
update o2o_shop_info_app a set adcode=(select id from shop_area b
where b.areaname=a.district and
a.citycode =b.parentid
)
where pt_name='饿了么h5' and province1='河北省'