1 UPDATE profile_addresses
AS pa
2 INNER JOIN tmp_profile_addresses
AS ta
ON (pa.pid
= ta.pid
AND pa.jobid
= ta.jobid
AND pa.groupid
= ta.groupid
AND pa.
type = ta.
type AND pa.
text = ta.
text)
3 SET pa.postalText
= ta.postalText
, pa.formatted_address
= ta.formatted_address
, pa.types
= ta.types
,
4 pa.latitude
= ta.latitude
, pa.longitude
= ta.longitude
, pa.southwest_latitude
= ta.southwest_latitude
,
5 pa.southwest_longitude
= ta.southwest_longitude
, pa.northeast_latitude
= ta.northeast_latitude
, pa.northeast_longitude
= ta.northeast_longitude
,
6 pa.location_type
= ta.location_type
, pa.partial_match
= ta.partial_match
,
7 pa.geocoding_date
= ta.geocoding_date
, pa.geocoding_calls
= ta.geocoding_calls
;
9 DROP TABLE tmp_profile_addresses
;
11 -- vim:set syntax=mysql: