mysql - How to update one table based on another table's values on ...

Using MySQL update multiple table syntax: ... solution for it: update ips set countryid=(select countryid from country where ips.iso=country.iso ) ...

dba.stackexchange.com