Commit | Line | Data |
---|---|---|
c7d784c5 SJ |
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) | |
9e64234f | 3 | SET pa.postalText = ta.postalText, pa.formatted_address = ta.formatted_address, pa.types = ta.types, |
c7d784c5 SJ |
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; | |
8 | ||
9 | DROP TABLE tmp_profile_addresses; | |
10 | ||
11 | -- vim:set syntax=mysql: |