List of Nations in SQL and Text

You can use this list of countries to create your own SQL insert statements or Data. The SQL version is also included

Ascension Island
Andorra
United Arab Emirates
Afghanistan
Antigua and Barbuda
Anguilla
Albania
Armenia
Netherlands Antilles
Angola
Antartica
Argentina
American Samoa
Australia
Aruba
Azerbaijan
Bosnia and Herzegovina
Barbados
Bangladesh
Belgium
Burkina Faso
Bulgaria
Bahrain
Burundi
Benin
Bermuda
Brunei Darussalam
Bolivia
Brazil
Bahamas
Bhutan
Bouvet Island
Botswana
Belarus
Belize
Canada
Cocos (Keeling) Islands
Congo, Democratic People's Republic
Central African Republic
Congo, Republic of
Switzerland
Cote d'Ivoire
Cook Islands
Chile
Cameroon
China
Colombia
Costa Rica
Cuba
Cap Verde
Christmas Island
Cyprus
Czeck Republic
Germany
Djibouti
Denmark
Dominica
Dominican Republic
Algeria
Ecuador
Estonia
Egypt
Western Sahara
Eritrea
Spain
Ethiopia
Finland
Fiji
Falkland Islands (Malvina)
Micronesia, Federal State of
Faroe Islands
France
Gabon
Grenada
Georgia
French Guiana
Guernsey
Ghana
Gibraltar
Greenland
Gambia
Guinea
Guadeloupe
Equatorial Guinea
Greece
South Georgia and the South Sandwich Islands
Guatemala
Guam
Guinea-Bissau
Guyana
Hong Kong
Heard and McDonald Islands
Honduras
Croatia/Hrvatska
Haiti
Hungary
Indonesia
Ireland
Israel
Isle of Man
India
British Indian Ocean Territory
Iraq
Iran (Islamic Republic of)
Iceland
Italy
Jersey
Jamaica
Jordan
Japan
Kenya
Kyrgyzstan
Cambodia
Kiribati
Comoros
Saint Kitts and Nevis
Korea, Democratic People's Republic
Korea, Republic of
Kuwait
Cayman Islands
Kazakhstan
Lao, People's Democratic Republic
Lebanon
Saint Lucia
Liechtenstein
Sri Lanka
Liberia
Lesotho
Lithuania
Luxembourg
Latvia
Libyan Arab Jamahiriya
Morocco
Monaco
Moldova, Republic of
Madagascar
Marshall Islands
Macedonia, Former Yugoslav Republic
Mali
Myanmar
Mongolia
Macau
Northern Mariana Islands
Martinique
Mauritania
Montserrat
Malta
Mauritius
Maldives
Malawi
Mexico
Malaysia
Mozambique
Namibia
New Caledonia
Niger
Norfolk Island
Nigeria
Nicaragua
Netherlands
Norway
Nepal
Nauru
Niue
New Zealand
Oman
Panama
Peru
French Polynesia
Papua New Guinea
Philippines
Pakistan
Poland
St. Pierre and Miquelon
Pitcairn Island
Puerto Rico
Portugal
Palau
Paraguay
Qatar
Reunion Island
Romania
Russian Federation
Rwanda
Saudi Arabia
Solomon Islands
Seychelles
Sudan
Sweden
Singapore
St. Helena
Slovenia
Svalbard and Jan Mayen Islands
Slovak Republic
Sierra Leone
San Marino
Senegal
Somalia
Suriname
Sao Tome and Principe
El Salvador
Syrian Arab Republic
Swaziland
Turks and Ciacos Islands
Chad
French Southern Territories
Togo
Thailand
Tajikistan
Tokelau
Turkmenistan
Tunisia
Tonga
East Timor
Turkey
Trinidad and Tobago
Tuvalu
Taiwan
Tanzania
Ukraine
Uganda
United Kingdom
United Kingdom
US Minor Outlying Islands
United States
Uruguay
Uzbekistan
Holy See (City Vatican State)
Saint Vincent and the Grenadines
Venezuela
Virgin Islands (British)
Virgin Islands (USA)
Vietnam
Vanuatu
Wallis and Futuna Islands
Western Samoa
Yemen
Mayotte
Yugoslavia
South Africa
Zambia
Zaire
Zimbabwe
Austria

or some sql code

-- phpMyAdmin SQL Dump -- version 2.6.0-rc1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Oct 15, 2004 at 10:29 AM -- Server version: 4.0.20 -- PHP Version: 4.3.8 -- -- Database: `01diarist` --


-- --------------------------------------------------------
--

-- Table structure for table `country`

-- 
CREATE TABLE `country` (

`countryid` int(11) NOT NULL auto_increment,

`country_code` varchar(10) NOT NULL default '',

`country` varchar(64) NOT NULL default '',

`currency` varchar(4) NOT NULL default '0',

UNIQUE KEY `country_code` (`country_code`),

UNIQUE KEY `ID` (`countryid`)

) TYPE=MyISAM AUTO_INCREMENT=251 ;
--

-- Dumping data for table `country`

-- 
INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (1, 'ac', 'Ascension Island', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (2, 'ad', 'Andorra', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (3, 'ae', 'United Arab Emirates', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (4, 'af', 'Afghanistan', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (5, 'ag', 'Antigua and Barbuda', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (6, 'ai', 'Anguilla', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (7, 'al', 'Albania', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (8, 'am', 'Armenia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (9, 'an', 'Netherlands Antilles', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (10, 'ao', 'Angola', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (11, 'aq', 'Antartica', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (12, 'ar', 'Argentina', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (13, 'as', 'American Samoa', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (14, 'au', 'Australia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (15, 'aw', 'Aruba', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (16, 'az', 'Azerbaijan', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (17, 'ba', 'Bosnia and Herzegovina', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (18, 'bb', 'Barbados', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (19, 'bd', 'Bangladesh', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (20, 'be', 'Belgium', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (21, 'bf', 'Burkina Faso', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (22, 'bg', 'Bulgaria', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (23, 'bh', 'Bahrain', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (24, 'bi', 'Burundi', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (25, 'bj', 'Benin', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (26, 'bm', 'Bermuda', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (27, 'bn', 'Brunei Darussalam', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (28, 'bo', 'Bolivia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (29, 'br', 'Brazil', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (30, 'bs', 'Bahamas', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (31, 'bt', 'Bhutan', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (32, 'bv', 'Bouvet Island', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (33, 'bw', 'Botswana', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (34, 'by', 'Belarus', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (35, 'bz', 'Belize', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (36, 'ca', 'Canada', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (37, 'cc', 'Cocos (Keeling) Islands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (38, 'cd', 'Congo, Democratic People''s Republic', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (39, 'cf', 'Central African Republic', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (40, 'cg', 'Congo, Republic of', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (41, 'ch', 'Switzerland', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (42, 'ci', 'Cote d''Ivoire', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (43, 'ck', 'Cook Islands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (44, 'cl', 'Chile', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (45, 'cm', 'Cameroon', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (46, 'cn', 'China', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (47, 'co', 'Colombia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (48, 'cr', 'Costa Rica', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (49, 'cu', 'Cuba', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (50, 'cv', 'Cap Verde', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (51, 'cx', 'Christmas Island', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (52, 'cy', 'Cyprus', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (53, 'cz', 'Czeck Republic', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (54, 'de', 'Germany', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (55, 'dj', 'Djibouti', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (56, 'dk', 'Denmark', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (57, 'dm', 'Dominica', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (58, 'do', 'Dominican Republic', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (59, 'dz', 'Algeria', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (60, 'ec', 'Ecuador', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (61, 'ee', 'Estonia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (62, 'eg', 'Egypt', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (63, 'eh', 'Western Sahara', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (64, 'er', 'Eritrea', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (65, 'es', 'Spain', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (66, 'et', 'Ethiopia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (67, 'fi', 'Finland', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (68, 'fj', 'Fiji', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (69, 'fk', 'Falkland Islands (Malvina)', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (70, 'fm', 'Micronesia, Federal State of', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (71, 'fo', 'Faroe Islands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (72, 'fr', 'France', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (73, 'ga', 'Gabon', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (74, 'gd', 'Grenada', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (75, 'ge', 'Georgia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (76, 'gf', 'French Guiana', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (77, 'gg', 'Guernsey', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (78, 'gh', 'Ghana', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (79, 'gi', 'Gibraltar', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (80, 'gl', 'Greenland', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (81, 'gm', 'Gambia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (82, 'gn', 'Guinea', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (83, 'gp', 'Guadeloupe', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (84, 'gq', 'Equatorial Guinea', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (85, 'gr', 'Greece', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (86, 'gs', 'South Georgia and the South Sandwich Islands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (87, 'gt', 'Guatemala', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (88, 'gu', 'Guam', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (89, 'gw', 'Guinea-Bissau', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (90, 'gy', 'Guyana', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (91, 'hk', 'Hong Kong', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (92, 'hm', 'Heard and McDonald Islands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (93, 'hn', 'Honduras', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (94, 'hr', 'Croatia/Hrvatska', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (95, 'ht', 'Haiti', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (96, 'hu', 'Hungary', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (97, 'id', 'Indonesia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (98, 'ie', 'Ireland', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (99, 'il', 'Israel', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (100, 'im', 'Isle of Man', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (101, 'in', 'India', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (102, 'io', 'British Indian Ocean Territory', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (103, 'iq', 'Iraq', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (104, 'ir', 'Iran (Islamic Republic of)', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (105, 'is', 'Iceland', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (106, 'it', 'Italy', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (107, 'je', 'Jersey', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (108, 'jm', 'Jamaica', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (109, 'jo', 'Jordan', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (110, 'jp', 'Japan', 'Yen');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (111, 'ke', 'Kenya', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (112, 'kg', 'Kyrgyzstan', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (113, 'kh', 'Cambodia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (114, 'ki', 'Kiribati', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (115, 'km', 'Comoros', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (116, 'kn', 'Saint Kitts and Nevis', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (117, 'kp', 'Korea, Democratic People''s Republic', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (118, 'kr', 'Korea, Republic of', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (119, 'kw', 'Kuwait', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (120, 'ky', 'Cayman Islands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (121, 'kz', 'Kazakhstan', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (122, 'la', 'Lao, People''s Democratic Republic', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (123, 'lb', 'Lebanon', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (124, 'lc', 'Saint Lucia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (125, 'li', 'Liechtenstein', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (126, 'lk', 'Sri Lanka', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (127, 'lr', 'Liberia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (128, 'ls', 'Lesotho', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (129, 'lt', 'Lithuania', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (130, 'lu', 'Luxembourg', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (131, 'lv', 'Latvia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (132, 'ly', 'Libyan Arab Jamahiriya', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (133, 'ma', 'Morocco', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (134, 'mc', 'Monaco', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (135, 'md', 'Moldova, Republic of', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (136, 'mg', 'Madagascar', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (137, 'mh', 'Marshall Islands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (138, 'mk', 'Macedonia, Former Yugoslav Republic', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (139, 'ml', 'Mali', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (140, 'mm', 'Myanmar', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (141, 'mn', 'Mongolia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (142, 'mo', 'Macau', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (143, 'mp', 'Northern Mariana Islands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (144, 'mq', 'Martinique', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (145, 'mr', 'Mauritania', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (146, 'ms', 'Montserrat', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (147, 'mt', 'Malta', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (148, 'mu', 'Mauritius', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (149, 'mv', 'Maldives', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (150, 'mw', 'Malawi', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (151, 'mx', 'Mexico', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (152, 'my', 'Malaysia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (153, 'mz', 'Mozambique', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (154, 'na', 'Namibia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (155, 'nc', 'New Caledonia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (156, 'ne', 'Niger', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (157, 'nf', 'Norfolk Island', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (158, 'ng', 'Nigeria', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (159, 'ni', 'Nicaragua', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (160, 'nl', 'Netherlands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (161, 'no', 'Norway', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (162, 'np', 'Nepal', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (163, 'nr', 'Nauru', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (164, 'nu', 'Niue', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (165, 'nz', 'New Zealand', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (166, 'om', 'Oman', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (167, 'pa', 'Panama', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (168, 'pe', 'Peru', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (169, 'pf', 'French Polynesia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (170, 'pg', 'Papua New Guinea', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (171, 'ph', 'Philippines', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (172, 'pk', 'Pakistan', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (173, 'pl', 'Poland', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (174, 'pm', 'St. Pierre and Miquelon', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (175, 'pn', 'Pitcairn Island', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (176, 'pr', 'Puerto Rico', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (177, 'pt', 'Portugal', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (178, 'pw', 'Palau', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (179, 'py', 'Paraguay', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (180, 'qa', 'Qatar', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (181, 're', 'Reunion Island', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (182, 'ro', 'Romania', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (183, 'ru', 'Russian Federation', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (184, 'rw', 'Rwanda', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (185, 'sa', 'Saudi Arabia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (186, 'sb', 'Solomon Islands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (187, 'sc', 'Seychelles', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (188, 'sd', 'Sudan', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (189, 'se', 'Sweden', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (190, 'sg', 'Singapore', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (191, 'sh', 'St. Helena', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (192, 'si', 'Slovenia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (193, 'sj', 'Svalbard and Jan Mayen Islands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (194, 'sk', 'Slovak Republic', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (195, 'sl', 'Sierra Leone', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (196, 'sm', 'San Marino', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (197, 'sn', 'Senegal', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (198, 'so', 'Somalia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (199, 'sr', 'Suriname', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (200, 'st', 'Sao Tome and Principe', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (201, 'sv', 'El Salvador', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (202, 'sy', 'Syrian Arab Republic', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (203, 'sz', 'Swaziland', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (204, 'tc', 'Turks and Ciacos Islands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (205, 'td', 'Chad', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (206, 'tf', 'French Southern Territories', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (207, 'tg', 'Togo', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (208, 'th', 'Thailand', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (209, 'tj', 'Tajikistan', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (210, 'tk', 'Tokelau', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (211, 'tm', 'Turkmenistan', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (212, 'tn', 'Tunisia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (213, 'to', 'Tonga', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (214, 'tp', 'East Timor', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (215, 'tr', 'Turkey', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (216, 'tt', 'Trinidad and Tobago', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (217, 'tv', 'Tuvalu', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (218, 'tw', 'Taiwan', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (219, 'tz', 'Tanzania', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (220, 'ua', 'Ukraine', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (221, 'ug', 'Uganda', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (222, 'uk', 'United Kingdom', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (223, 'gb', 'United Kingdom', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (224, 'um', 'US Minor Outlying Islands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (225, 'us', 'United States', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (226, 'uy', 'Uruguay', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (227, 'uz', 'Uzbekistan', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (228, 'va', 'Holy See (City Vatican State)', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (229, 'vc', 'Saint Vincent and the Grenadines', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (230, 've', 'Venezuela', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (231, 'vg', 'Virgin Islands (British)', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (232, 'vi', 'Virgin Islands (USA)', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (233, 'vn', 'Vietnam', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (234, 'vu', 'Vanuatu', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (235, 'wf', 'Wallis and Futuna Islands', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (236, 'ws', 'Western Samoa', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (237, 'ye', 'Yemen', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (238, 'yt', 'Mayotte', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (239, 'yu', 'Yugoslavia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (240, 'za', 'South Africa', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (241, 'zm', 'Zambia', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (242, 'zr', 'Zaire', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (243, 'zw', 'Zimbabwe', '');

INSERT INTO `country` (`countryid`, `country_code`, `country`, `currency`) VALUES (250, 'at', 'Austria', '');