MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Update table !
Posted by: Jean-Edouard Canton
Date: May 10, 2020 06:08PM

I did this SQL request :

UPDATE prefectures
INNER JOIN villes_france_free ON prefectures.code_departement = villes_france_free.ville_departement
AND villes_france_free.ville_code_postal LIKE '%000'
SET prefectures.Latitude = villes_france_free.ville_latitude_deg ... :)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Update table !
Jean-Edouard Canton
May 10, 2020 04:43PM
Re: Update table !
Peter Brawley
May 10, 2020 05:11PM
Re: Update table !
Jean-Edouard Canton
May 10, 2020 06:10PM
Re: Update table !
Jean-Edouard Canton
May 10, 2020 06:35PM
Re: Update table !
Jean-Edouard Canton
May 10, 2020 06:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.