Mysql update all rows based on select from another table - Stack Overflow

I have two tabels; mysql> describe ipinfo.ip_group_country; +-----+-----+-----+-----+-----+-----+ | Field | Type | Null | Key | Default | Extra | ... Try UPDATE logs.logs SET COUNTRY_CODE = ( SELECT country_code FROM ipinfo.ip_group_country WHERE ipinfo .

stackoverflow.com