update region a
set a.region_code=
(select b.city_pinyin from china_city b where a.region_name = b.city_name)
where exists
(select 1
from china_city b
where a.region_name = b.city_name)
update region a
set a.region_code=
(select b.city_pinyin from china_city b where a.region_name = b.city_name)
where exists
(select 1
from china_city b
where a.region_name = b.city_name)