title: SQL to Update records of one table with records from another table?
body: <p>I have two tables here both contain like lots of records in the tens of thousands. Now we have one main table whose schema is like this:</p>
  <p>ID | Location Name | Label | Description | Longitude | Latitude</p>
  <p>And we have another table with:</p>
  <p>ID | Location Name | Longitude | Latitude</p>
  <p>The issue is that the longitude and latitude entries in the first table are mostly wrong :( - the correct info is in the second table. Assuming that the IDs are corresponding to the same locations in both tables how can I fix up a query that updates the longitude and latitude field of every row in the first table based upon the entries in the second table where the IDs are the same. I am on a MySQL database.</p>
  <p>EDIT</p>
  <p>Note: Both tables have 20 000 and 50 000 rows respectively.</p>