sql - MYSQL Update Statement Inner Join Tables - Stack Overflow

Try this: UPDATE business AS b INNER JOIN business_geocode AS g ON b. business_id = g.business_id SET b.mapx = g.latitude, b.mapy ...

www.google.com.tw