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