/branches/v2.25-scarificateur/doc/bdd/2015-04_migration_lat_lon_sauvages/maj_lat_lon_sauvages.sql |
---|
New file |
0,0 → 1,11 |
UPDATE cel_obs co |
INNER JOIN cel_obs_etendues coe |
ON coe.id_observation = co.id_observation |
AND cle = 'latitudeDebutRue' |
SET co.latitude = coe.valeur; |
UPDATE cel_obs co |
INNER JOIN cel_obs_etendues coe |
ON coe.id_observation = co.id_observation |
AND cle = 'longitudeDebutRue' |
SET co.longitude = coe.valeur; |