mysql表关联更新

         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