mysql - INSERT INTO copying from table to another -

i have table lang_name , country_name columns.

in table have listing of countries like:

english   andorra english   united arab emirates english   afghanistan 

i need format on country_names table

id english spanish french italian 1  brazil  brazil  brÉsil  brasile 

i tried use , works aonly 1 language

insert co_names (english) select country_name ulkeler lang_name = 'english' 

when change to

insert co_names (spanish) select country_name ulkeler lang_name = 'spanish'  

it says worked when checked don't see record in spanish part.

my table creation this

create table `co_names` (   `id` int(11) not null,   `english` varchar(255) character set utf8 not null,   `spanish` varchar(255) character set utf8 not null,   `french` varchar(255) character set utf8 not null,   `german` varchar(255) character set utf8 not null,   `italian` varchar(255) character set utf8 not null,   `portugues` varchar(255) character set utf8 not null,   `turkish` varchar(255) character set utf8 not null ) engine=myisam default charset=utf8 collate=utf8_unicode_ci; 

you can see ulkeler db csv here. http://www.mytiq.net/multilanugage country.csv

insert co_names  ( id, english, spanish, french, german, italian, portugues, turkish ) select convert(country_numeric_code, unsigned),  ifnull((select max(country_name) ulkeler u.lang_name = 'english'), 'unknown'), ifnull((select max(country_name) ulkeler u.lang_name = 'spanish'), 'unknown'), ifnull((select max(country_name) ulkeler u.lang_name = 'french'), 'unknown'), ifnull((select max(country_name) ulkeler u.lang_name = 'german'), 'unknown'), ifnull((select max(country_name) ulkeler u.lang_name = 'italian'), 'unknown'), ifnull((select max(country_name) ulkeler u.lang_name = 'portuguese'), 'unknown'), ifnull((select max(country_name) ulkeler u.lang_name = 'turkish'), 'unknown') ulkeler u group country_numeric_code; 

note misspelling of 'portuguese' column (missing last 'e') in co_names table.