UPDATE  enterprise_test t1, enterprise_development_relation t2

SET t1.development_area_id = t2.development_area_id, t1.development_area_distance = t2.distance

WHERE

    t1.id = t2.enterprise_id

         UPDATE  enterprise_test t1, enterprise_park_relation t2

SET t1.park_id = t2.park_id, t1.park_distance = t2.distance

WHERE

    t1.id = t2.enterprise_id

-- update a set a.province = b.province,a.city=b.city,a.county=b.county,a.town=b.town,

--                          a.province_code=b.province_code,a.city_code=b.city_code,a.county_code=b.county_code,a.town_code=b.town_code

-- from source_enterprise a inner join source_enterprise2 b

-- on a.name = b.name

--

update a set a.park_id1 = NULL,a.park_distance1=NULL

from source_enterprise a inner join source_park_list b

on (a.park_id=b.id and a.county_code!=b.county_code)

-- SELECT COUNT(1) from source_enterprise where park_id1 is not NULL

-- UPDATE source_enterprise SET park_id1=park_id,park_distance1=park_distance