MySQL Forums
Forum List  »  French

Re: Update et jointure entre 2 tables
Posted by: Jean-Edouard Canton
Date: September 29, 2019 11:37AM

J'ai essayé ceci mais sans succès :( :

SET SQL_BIG_SELECTS=1;
UPDATE stationE85
SET Longitude = fullstation.Longitude,
Latitude = fullstation.Latitude
FROM stationE85
INNER JOIN fullstation ON stationE85.station = fullstation.nom AND stationE85.dep = fullstation.CP

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Update et jointure entre 2 tables
215
September 29, 2019 11:37AM


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.