Subversion Repositories eFlore/Applications.cel

Rev

Rev 2754 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
2754 aurelien 1 
UPDATE cel_obs co
2 
INNER JOIN cel_obs_etendues coe
3 
  ON coe.id_observation = co.id_observation
4 
  AND cle = 'latitudeDebutRue'
5 
SET co.latitude = coe.valeur;
6 
 
7 
UPDATE cel_obs co
8 
INNER JOIN cel_obs_etendues coe
9 
  ON coe.id_observation = co.id_observation
10 
  AND cle = 'longitudeDebutRue'
11 
SET co.longitude = coe.valeur;