use `akura`;

UPDATE `COUNTRY` SET `COUNTRY_NAME`='United States' 
WHERE `COUNTRY_NAME`='UnitedStates';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='Sri Lanka' 
WHERE `COUNTRY_NAME`='SriLanka';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='South Africa' 
WHERE `COUNTRY_NAME`='SouthAfrica';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='Antiguaand Barbuda' 
WHERE `COUNTRY_NAME`='AntiguaandBarbuda';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='Ascension Island' 
WHERE `COUNTRY_NAME`='AscensionIsland';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='British Indian Ocean' 
WHERE `COUNTRY_NAME`='BritishIndianOcean';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='British Virgin Islands' 
WHERE `COUNTRY_NAME`='BritishVirginIslands';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='Central Africa' 
WHERE `COUNTRY_NAME`='CentralAfrica';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='China' 
WHERE `COUNTRY_NAME`='China,PeoplesRepublic';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='Christmas Island' 
WHERE `COUNTRY_NAME`='ChristmasIsland';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='Czech Republic' 
WHERE `COUNTRY_NAME`='CzechRepublic';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='North Korea' 
WHERE `COUNTRY_NAME`='NorthKorea';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='Northern Ireland' 
WHERE `COUNTRY_NAME`='NorthernIreland';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='Papua New Guinea' 
WHERE `COUNTRY_NAME`='PapuaNewGuinea';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='Saudi Arabia' 
WHERE `COUNTRY_NAME`='SaudiArabia';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='South Korea' 
WHERE `COUNTRY_NAME`='SouthKorea';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='United Arab Emirates' 
WHERE `COUNTRY_NAME`='UnitedArabEmirates';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='Vatican City State' 
WHERE `COUNTRY_NAME`='VaticanCityState';

UPDATE `COUNTRY` SET `COUNTRY_NAME`='Western Sahara' 
WHERE `COUNTRY_NAME`='WesternSahara';
