MySQL Forums
Forum List  »  French

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

Et celle ci non plus :(

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

http://www.canton-tech.org

Options: ReplyQuote


Subject
Views
Written By
Posted
1079
September 29, 2019 11:09AM
Re: Update et jointure entre 2 tables
440
September 29, 2019 11:52AM


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.