Mysql table update command or script help needed

[smartcard]

I have a MySql DB called "CONTACTS" and it has two tables, they are:

Table Name = CUSTOMER [There are many customers in this table]
Field 1 = Customer_Name [Data available]
Field 2 = Customer_Country_Code [Data Available]
Field 3 = Customer_Country_Name [To be updated from COUNTRY table]

Table Name = COUNTRY [There is one record for every country in the world]
Field 1 = Country_Code
Field 2 = Country_Name

How can I run a SQL command or write a PHP script that will fill the CUSTOMER->Customer_Country_Name with the Country Name by checking the CUSTOMER->Customer_Country_Name with COUNTRY->Country_Code

[jatar_k]

is Customer_Country_Code already set for each customer?

if so why pull the name into the other table as well?

[smartcard]

I want it in that way for some other applicaion export.

[coopster]

How about using INSERT ... SELECT [dev.mysql.com] to build the table for export?