UPDATE cx_post_country_table_mapping a INNER JOIN cx_country_info b on a.country_code=b.country_code set a.country_name =b.country_name