Mysql update inner

UPDATE business AS b
INNER JOIN business_geocode AS g ON b.business_id = g.business_id
SET b.mapx = g.latitude,
  b.mapy = g.longitude
WHERE  (b.mapx = '' or b.mapx = 0) and
  g.latitude > 0

Source: stackoverflow.com

Similar codes

1 vote300 views1 answer
Column with prefix in sql
SQL
10 votes273 views1 answer
Oracle view dependencies
SQL
0 vote315 views1 answer
Php get closest location by latitude longitude
SQL
0 vote308 views1 answer
Redudancy in SQL
SQL
0 vote304 views2 answers
Mysql output csv
SQL
0 vote345 views1 answer
How to run mysql on terminal mac
SQL
2 votes308 views1 answer
No data found oracle
SQL
15 votes326 views7 answers
MYSQL
SQL
11 votes317 views3 answers
Sqlite3 create table from another table
SQL
0 vote309 views1 answer
SqlFunction does not exist
SQL