This Post below ↓ is only visible to you.
It is sheduled to delete with all the changelog & comment data attached. You can cancel deletion at any time.

COUNTRIES LIST SQL, country list sql

COUNTRIES LIST SQL, country list sqlEdit

Andrzej Jeziorski · 431 user posts · 26 user answers

You can download entire .zip sql file with: countries list sql, country list sql with country codes by clicking <a href='http://path-of-power.com/download/175/country-list-sql.zip'>country-list-sql.zip</a>. 
<code> 
-- 
-- Table structure for table `power_countries` 
-- 
 
CREATE TABLE IF NOT EXISTS `power_countries` ( 
 `id` int(11) NOT NULL auto_increment, 
 `t` varchar(255) NOT NULL default '', 
 `code` varchar(255) NOT NULL default '', 
 `seq` int(11) NOT NULL default '0', 
 PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=220 ; 
 
-- 
-- Dumping data for table `power_countries` 
-- 
 
INSERT INTO `power_countries` (`id`, `t`, `code`, `seq`) VALUES 
(1, 'United States', 'US', 0), 
(2, 'United Kingdom', 'UK', 0), 
(3, 'Norway', 'NO', 0), 
(4, 'Greece', 'GR', 0), 
(5, 'Afghanistan', 'AF', 0), 
(6, 'Albania', 'AL', 0), 
(7, 'Algeria', 'DZ', 0), 
(8, 'American Samoa', 'AS', 0), 
(9, 'Andorra', 'AD', 0), 
(10, 'Angola', 'AO', 0), 
(11, 'Anguilla', 'AI', 0), 
(12, 'Antigua & Barbuda', 'AG', 0), 
(13, 'Antilles, Netherlands', 'AN', 0), 
(182, 'Senegal', 'SN', 0), 
(15, 'Argentina', 'AR', 0), 
(16, 'Armenia', 'AM', 0), 
(17, 'Aruba', 'AW', 0), 
(18, 'Australia', 'AU', 0), 
(19, 'Austria', 'AT', 0), 
(20, 'Azerbaijan', 'AZ', 0), 
(21, 'Bahamas, The', 'BS', 0), 
(22, 'Bahrain', 'BH', 0), 
(23, 'Bangladesh', 'BD', 0), 
(24, 'Barbados', 'BB', 0), 
(25, 'Belarus', 'BY', 0), 
(26, 'Belgium', 'BE', 0), 
(27, 'Belize', 'BZ', 0), 
(28, 'Benin', 'BJ', 0), 
(29, 'Bermuda', 'BM', 0), 
(30, 'Bhutan', 'BT', 0), 
(31, 'Bolivia', 'BO', 0), 
(32, 'Bosnia and Herzegovina', 'BA', 0), 
(33, 'Botswana', 'BW', 0), 
(34, 'Brazil', 'BR', 0), 
(35, 'British Virgin Islands', 'VG', 0), 
(36, 'Brunei Darussalam', 'BN', 0), 
(37, 'Bulgaria', 'BG', 0), 
(38, 'Burkina Faso', 'BF', 0), 
(39, 'Burundi', 'BI', 0), 
(40, 'Cambodia', 'KH', 0), 
(41, 'Cameroon', 'CM', 0), 
(42, 'Canada', 'CA', 0), 
(43, 'Cape Verde', 'CV', 0), 
(44, 'Cayman Islands', 'KY', 0), 
(45, 'Central African Republic', 'CF', 0), 
(46, 'Chad', 'TD', 0), 
(47, 'Chile', 'CL', 0), 
(48, 'China', 'CN', 0), 
(49, 'Colombia', 'CO', 0), 
(50, 'Comoros', 'KM', 0), 
(51, 'Congo', 'CG', 0), 
(52, 'Congo', 'CD', 0), 
(53, 'Cook Islands', 'CK', 0), 
(54, 'Costa Rica', 'CR', 0), 
(55, 'Cote D''Ivoire', 'CI', 0), 
(56, 'Croatia', 'HR', 0), 
(57, 'Cuba', 'CU', 0), 
(58, 'Cyprus', 'CY', 0), 
(59, 'Czech Republic', 'CZ', 0), 
(60, 'Denmark', 'DK', 0), 
(61, 'Djibouti', 'DJ', 0), 
(62, 'Dominica', 'DM', 0), 
(63, 'Dominican Republic', 'DO', 0), 
(64, 'East Timor (Timor-Leste)', 'TP', 0), 
(65, 'Ecuador', 'EC', 0), 
(66, 'Egypt', 'EG', 0), 
(67, 'El Salvador', 'SV', 0), 
(68, 'Equatorial Guinea', 'GQ', 0), 
(69, 'Eritrea', 'ER', 0), 
(70, 'Estonia', 'EE', 0), 
(71, 'Ethiopia', 'ET', 0), 
(72, 'Falkland Islands', 'FK', 0), 
(73, 'Faroe Islands', 'FO', 0), 
(74, 'Fiji', 'FJ', 0), 
(75, 'Finland', 'FI', 0), 
(76, 'France', 'FR', 0), 
(77, 'French Guiana', 'GF', 0), 
(78, 'French Polynesia', 'PF', 0), 
(79, 'Gabon', 'GA', 0), 
(80, 'Gambia, the', 'GM', 0), 
(81, 'Georgia', 'GE', 0), 
(82, 'Germany', 'DE', 0), 
(83, 'Ghana', 'GH', 0), 
(84, 'Gibraltar', 'GI', 0), 
(86, 'Greenland', 'GL', 0), 
(87, 'Grenada', 'GD', 0), 
(88, 'Guadeloupe', 'GP', 0), 
(89, 'Guam', 'GU', 0), 
(90, 'Guatemala', 'GT', 0), 
(91, 'Guernsey and Alderney', 'GG', 0), 
(92, 'Guinea', 'GN', 0), 
(93, 'Guinea-Bissau', 'GW', 0), 
(94, 'Guinea, Equatorial', 'GP', 0), 
(95, 'Guiana, French', 'GF', 0), 
(96, 'Guyana', 'GY', 0), 
(97, 'Haiti', 'HT', 0), 
(179, 'San Marino', 'SM', 0), 
(99, 'Honduras', 'HN', 0), 
(100, 'Hong Kong, (China)', 'HK', 0), 
(101, 'Hungary', 'HU', 0), 
(102, 'Iceland', 'IS', 0), 
(103, 'India', 'IN', 0), 
(104, 'Indonesia', 'ID', 0), 
(105, 'Iran, Islamic Republic of', 'IR', 0), 
(106, 'Iraq', 'IQ', 0), 
(107, 'Ireland', 'IE', 0), 
(108, 'Israel', 'IL', 0), 
(109, 'Ivory Coast (Cote d''Ivoire)', 'CI', 0), 
(110, 'Italy', 'IT', 0), 
(111, 'Jamaica', 'JM', 0), 
(112, 'Japan', 'JP', 0), 
(113, 'Jersey', 'JE', 0), 
(114, 'Jordan', 'JO', 0), 
(115, 'Kazakhstan', 'KZ', 0), 
(116, 'Kenya', 'KE', 0), 
(117, 'Kiribati', 'KI', 0), 
(118, 'Korea, (South) Rep. of', 'KR', 0), 
(119, 'Kuwait', 'KW', 0), 
(120, 'Kyrgyzstan', 'KG', 0), 
(121, 'Lao People''s Dem. Rep.', 'LA', 0), 
(122, 'Latvia', 'LV', 0), 
(123, 'Lebanon', 'LB', 0), 
(124, 'Lesotho', 'LS', 0), 
(125, 'Libyan Arab Jamahiriya', 'LY', 0), 
(126, 'Liechtenstein', 'LI', 0), 
(127, 'Lithuania', 'LT', 0), 
(128, 'Luxembourg', 'LU', 0), 
(129, 'Macao, (China)', 'MO', 0), 
(130, 'Macedonia, TFYR', 'MK', 0), 
(131, 'Madagascar', 'MG', 0), 
(132, 'Malawi', 'MW', 0), 
(133, 'Malaysia', 'MY', 0), 
(134, 'Maldives', 'MV', 0), 
(135, 'Mali', 'ML', 0), 
(136, 'Malta', 'MT', 0), 
(137, 'Martinique', 'MQ', 0), 
(138, 'Mauritania', 'MR', 0), 
(139, 'Mauritius', 'MU', 0), 
(140, 'Mexico', 'MX', 0), 
(141, 'Micronesia', 'FM', 0), 
(142, 'Moldova, Republic of', 'MD', 0), 
(143, 'Monaco', 'MC', 0), 
(144, 'Mongolia', 'MN', 0), 
(145, 'Montenegro', 'CS', 0), 
(146, 'Morocco', 'MA', 0), 
(147, 'Mozambique', 'MZ', 0), 
(148, 'Myanmar (ex-Burma)', 'MM', 0), 
(149, 'Namibia', 'NA', 0), 
(150, 'Nepal', 'NP', 0), 
(151, 'Netherlands', 'NL', 0), 
(152, 'New Caledonia', 'NC', 0), 
(153, 'New Zealand', 'NZ', 0), 
(154, 'Nicaragua', 'NI', 0), 
(155, 'Niger', 'NE', 0), 
(156, 'Nigeria', 'NG', 0), 
(157, 'Northern Mariana Islands', 'MP', 0), 
(159, 'Oman', 'OM', 0), 
(160, 'Pakistan', 'PK', 0), 
(161, 'Palestinian Territory', 'PS', 0), 
(162, 'Panama', 'PA', 0), 
(163, 'Papua New Guinea', 'PG', 0), 
(164, 'Paraguay', 'PY', 0), 
(165, 'Peru', 'PE', 0), 
(166, 'Philippines', 'PH', 0), 
(167, 'Poland', 'PL', 0), 
(168, 'Portugal', 'PT', 0), 
(170, 'Qatar', 'QA', 0), 
(171, 'Reunion', 'RE', 0), 
(172, 'Romania', 'RO', 0), 
(173, 'Russian Federation', 'RU', 0), 
(174, 'Rwanda', 'RW', 0), 
(175, 'Saint Kitts and Nevis', 'KN', 0), 
(176, 'Saint Lucia', 'LC', 0), 
(177, 'St. Vincent & the Grenad.', 'VC', 0), 
(178, 'Samoa', 'WS', 0), 
(180, 'Sao Tome and Principe', 'ST', 0), 
(181, 'Saudi Arabia', 'SA', 0), 
(183, 'Serbia', 'RS', 0), 
(184, 'Seychelles', 'SC', 0), 
(185, 'Singapore', 'SG', 0), 
(186, 'Slovakia', 'SK', 0), 
(187, 'Slovenia', 'SI', 0), 
(188, 'Solomon Islands', 'SB', 0), 
(189, 'Somalia', 'SO', 0), 
(190, 'Spain', 'ES', 0), 
(191, 'Sri Lanka (ex-Ceilan)', 'LK', 0), 
(192, 'Sudan', 'SD', 0), 
(193, 'Suriname', 'SR', 0), 
(194, 'Swaziland', 'SZ', 0), 
(195, 'Sweden', 'SE', 0), 
(196, 'Switzerland', 'CH', 0), 
(197, 'Syrian Arab Republic', 'SY', 0), 
(198, 'Taiwan', 'TW', 0), 
(199, 'Tajikistan', 'TJ', 0), 
(200, 'Tanzania, United Rep. of', 'TZ', 0), 
(201, 'Thailand', 'TH', 0), 
(202, 'Togo', 'TG', 0), 
(203, 'Tonga', 'TO', 0), 
(204, 'Trinidad & Tobago', 'TT', 0), 
(205, 'Tunisia', 'TN', 0), 
(206, 'Turkey', 'TR', 0), 
(207, 'Turkmenistan', 'TM', 0), 
(208, 'Uganda', 'UG', 0), 
(209, 'Ukraine', 'UA', 0), 
(210, 'United Arab Emirates', 'AE', 0), 
(211, 'Uruguay', 'UY', 0), 
(212, 'Uzbekistan', 'UZ', 0), 
(213, 'Vanuatu', 'VU', 0), 
(214, 'Venezuela', 'VE', 0), 
(215, 'Viet Nam', 'VN', 0), 
(216, 'Virgin Islands, U.S.', 'VI', 0), 
(217, 'Yemen', 'YE', 0), 
(218, 'Zambia', 'ZM', 0), 
(219, 'Zimbabwe', 'ZW', 0); 
</code>

Cancel

You can download entire .zip sql file with: countries list sql, country list sql with country codes by clicking country-list-sql.zip.



--

-- Table structure for table `power_countries`

--



CREATE TABLE IF NOT EXISTS `power_countries` (

  `id` int(11) NOT NULL auto_increment,

  `t` varchar(255) NOT NULL default '',

  `code` varchar(255) NOT NULL default '',

  `seq` int(11) NOT NULL default '0',

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=220 ;



--

-- Dumping data for table `power_countries`

--



INSERT INTO `power_countries` (`id`, `t`, `code`, `seq`) VALUES

(1, 'United States', 'US', 0),

(2, 'United Kingdom', 'UK', 0),

(3, 'Norway', 'NO', 0),

(4, 'Greece', 'GR', 0),

(5, 'Afghanistan', 'AF', 0),

(6, 'Albania', 'AL', 0),

(7, 'Algeria', 'DZ', 0),

(8, 'American Samoa', 'AS', 0),

(9, 'Andorra', 'AD', 0),

(10, 'Angola', 'AO', 0),

(11, 'Anguilla', 'AI', 0),

(12, 'Antigua & Barbuda', 'AG', 0),

(13, 'Antilles, Netherlands', 'AN', 0),

(182, 'Senegal', 'SN', 0),

(15, 'Argentina', 'AR', 0),

(16, 'Armenia', 'AM', 0),

(17, 'Aruba', 'AW', 0),

(18, 'Australia', 'AU', 0),

(19, 'Austria', 'AT', 0),

(20, 'Azerbaijan', 'AZ', 0),

(21, 'Bahamas, The', 'BS', 0),

(22, 'Bahrain', 'BH', 0),

(23, 'Bangladesh', 'BD', 0),

(24, 'Barbados', 'BB', 0),

(25, 'Belarus', 'BY', 0),

(26, 'Belgium', 'BE', 0),

(27, 'Belize', 'BZ', 0),

(28, 'Benin', 'BJ', 0),

(29, 'Bermuda', 'BM', 0),

(30, 'Bhutan', 'BT', 0),

(31, 'Bolivia', 'BO', 0),

(32, 'Bosnia and Herzegovina', 'BA', 0),

(33, 'Botswana', 'BW', 0),

(34, 'Brazil', 'BR', 0),

(35, 'British Virgin Islands', 'VG', 0),

(36, 'Brunei Darussalam', 'BN', 0),

(37, 'Bulgaria', 'BG', 0),

(38, 'Burkina Faso', 'BF', 0),

(39, 'Burundi', 'BI', 0),

(40, 'Cambodia', 'KH', 0),

(41, 'Cameroon', 'CM', 0),

(42, 'Canada', 'CA', 0),

(43, 'Cape Verde', 'CV', 0),

(44, 'Cayman Islands', 'KY', 0),

(45, 'Central African Republic', 'CF', 0),

(46, 'Chad', 'TD', 0),

(47, 'Chile', 'CL', 0),

(48, 'China', 'CN', 0),

(49, 'Colombia', 'CO', 0),

(50, 'Comoros', 'KM', 0),

(51, 'Congo', 'CG', 0),

(52, 'Congo', 'CD', 0),

(53, 'Cook Islands', 'CK', 0),

(54, 'Costa Rica', 'CR', 0),

(55, 'Cote D''Ivoire', 'CI', 0),

(56, 'Croatia', 'HR', 0),

(57, 'Cuba', 'CU', 0),

(58, 'Cyprus', 'CY', 0),

(59, 'Czech Republic', 'CZ', 0),

(60, 'Denmark', 'DK', 0),

(61, 'Djibouti', 'DJ', 0),

(62, 'Dominica', 'DM', 0),

(63, 'Dominican Republic', 'DO', 0),

(64, 'East Timor (Timor-Leste)', 'TP', 0),

(65, 'Ecuador', 'EC', 0),

(66, 'Egypt', 'EG', 0),

(67, 'El Salvador', 'SV', 0),

(68, 'Equatorial Guinea', 'GQ', 0),

(69, 'Eritrea', 'ER', 0),

(70, 'Estonia', 'EE', 0),

(71, 'Ethiopia', 'ET', 0),

(72, 'Falkland Islands', 'FK', 0),

(73, 'Faroe Islands', 'FO', 0),

(74, 'Fiji', 'FJ', 0),

(75, 'Finland', 'FI', 0),

(76, 'France', 'FR', 0),

(77, 'French Guiana', 'GF', 0),

(78, 'French Polynesia', 'PF', 0),

(79, 'Gabon', 'GA', 0),

(80, 'Gambia, the', 'GM', 0),

(81, 'Georgia', 'GE', 0),

(82, 'Germany', 'DE', 0),

(83, 'Ghana', 'GH', 0),

(84, 'Gibraltar', 'GI', 0),

(86, 'Greenland', 'GL', 0),

(87, 'Grenada', 'GD', 0),

(88, 'Guadeloupe', 'GP', 0),

(89, 'Guam', 'GU', 0),

(90, 'Guatemala', 'GT', 0),

(91, 'Guernsey and Alderney', 'GG', 0),

(92, 'Guinea', 'GN', 0),

(93, 'Guinea-Bissau', 'GW', 0),

(94, 'Guinea, Equatorial', 'GP', 0),

(95, 'Guiana, French', 'GF', 0),

(96, 'Guyana', 'GY', 0),

(97, 'Haiti', 'HT', 0),

(179, 'San Marino', 'SM', 0),

(99, 'Honduras', 'HN', 0),

(100, 'Hong Kong, (China)', 'HK', 0),

(101, 'Hungary', 'HU', 0),

(102, 'Iceland', 'IS', 0),

(103, 'India', 'IN', 0),

(104, 'Indonesia', 'ID', 0),

(105, 'Iran, Islamic Republic of', 'IR', 0),

(106, 'Iraq', 'IQ', 0),

(107, 'Ireland', 'IE', 0),

(108, 'Israel', 'IL', 0),

(109, 'Ivory Coast (Cote d''Ivoire)', 'CI', 0),

(110, 'Italy', 'IT', 0),

(111, 'Jamaica', 'JM', 0),

(112, 'Japan', 'JP', 0),

(113, 'Jersey', 'JE', 0),

(114, 'Jordan', 'JO', 0),

(115, 'Kazakhstan', 'KZ', 0),

(116, 'Kenya', 'KE', 0),

(117, 'Kiribati', 'KI', 0),

(118, 'Korea, (South) Rep. of', 'KR', 0),

(119, 'Kuwait', 'KW', 0),

(120, 'Kyrgyzstan', 'KG', 0),

(121, 'Lao People''s Dem. Rep.', 'LA', 0),

(122, 'Latvia', 'LV', 0),

(123, 'Lebanon', 'LB', 0),

(124, 'Lesotho', 'LS', 0),

(125, 'Libyan Arab Jamahiriya', 'LY', 0),

(126, 'Liechtenstein', 'LI', 0),

(127, 'Lithuania', 'LT', 0),

(128, 'Luxembourg', 'LU', 0),

(129, 'Macao, (China)', 'MO', 0),

(130, 'Macedonia, TFYR', 'MK', 0),

(131, 'Madagascar', 'MG', 0),

(132, 'Malawi', 'MW', 0),

(133, 'Malaysia', 'MY', 0),

(134, 'Maldives', 'MV', 0),

(135, 'Mali', 'ML', 0),

(136, 'Malta', 'MT', 0),

(137, 'Martinique', 'MQ', 0),

(138, 'Mauritania', 'MR', 0),

(139, 'Mauritius', 'MU', 0),

(140, 'Mexico', 'MX', 0),

(141, 'Micronesia', 'FM', 0),

(142, 'Moldova, Republic of', 'MD', 0),

(143, 'Monaco', 'MC', 0),

(144, 'Mongolia', 'MN', 0),

(145, 'Montenegro', 'CS', 0),

(146, 'Morocco', 'MA', 0),

(147, 'Mozambique', 'MZ', 0),

(148, 'Myanmar (ex-Burma)', 'MM', 0),

(149, 'Namibia', 'NA', 0),

(150, 'Nepal', 'NP', 0),

(151, 'Netherlands', 'NL', 0),

(152, 'New Caledonia', 'NC', 0),

(153, 'New Zealand', 'NZ', 0),

(154, 'Nicaragua', 'NI', 0),

(155, 'Niger', 'NE', 0),

(156, 'Nigeria', 'NG', 0),

(157, 'Northern Mariana Islands', 'MP', 0),

(159, 'Oman', 'OM', 0),

(160, 'Pakistan', 'PK', 0),

(161, 'Palestinian Territory', 'PS', 0),

(162, 'Panama', 'PA', 0),

(163, 'Papua New Guinea', 'PG', 0),

(164, 'Paraguay', 'PY', 0),

(165, 'Peru', 'PE', 0),

(166, 'Philippines', 'PH', 0),

(167, 'Poland', 'PL', 0),

(168, 'Portugal', 'PT', 0),

(170, 'Qatar', 'QA', 0),

(171, 'Reunion', 'RE', 0),

(172, 'Romania', 'RO', 0),

(173, 'Russian Federation', 'RU', 0),

(174, 'Rwanda', 'RW', 0),

(175, 'Saint Kitts and Nevis', 'KN', 0),

(176, 'Saint Lucia', 'LC', 0),

(177, 'St. Vincent & the Grenad.', 'VC', 0),

(178, 'Samoa', 'WS', 0),

(180, 'Sao Tome and Principe', 'ST', 0),

(181, 'Saudi Arabia', 'SA', 0),

(183, 'Serbia', 'RS', 0),

(184, 'Seychelles', 'SC', 0),

(185, 'Singapore', 'SG', 0),

(186, 'Slovakia', 'SK', 0),

(187, 'Slovenia', 'SI', 0),

(188, 'Solomon Islands', 'SB', 0),

(189, 'Somalia', 'SO', 0),

(190, 'Spain', 'ES', 0),

(191, 'Sri Lanka (ex-Ceilan)', 'LK', 0),

(192, 'Sudan', 'SD', 0),

(193, 'Suriname', 'SR', 0),

(194, 'Swaziland', 'SZ', 0),

(195, 'Sweden', 'SE', 0),

(196, 'Switzerland', 'CH', 0),

(197, 'Syrian Arab Republic', 'SY', 0),

(198, 'Taiwan', 'TW', 0),

(199, 'Tajikistan', 'TJ', 0),

(200, 'Tanzania, United Rep. of', 'TZ', 0),

(201, 'Thailand', 'TH', 0),

(202, 'Togo', 'TG', 0),

(203, 'Tonga', 'TO', 0),

(204, 'Trinidad & Tobago', 'TT', 0),

(205, 'Tunisia', 'TN', 0),

(206, 'Turkey', 'TR', 0),

(207, 'Turkmenistan', 'TM', 0),

(208, 'Uganda', 'UG', 0),

(209, 'Ukraine', 'UA', 0),

(210, 'United Arab Emirates', 'AE', 0),

(211, 'Uruguay', 'UY', 0),

(212, 'Uzbekistan', 'UZ', 0),

(213, 'Vanuatu', 'VU', 0),

(214, 'Venezuela', 'VE', 0),

(215, 'Viet Nam', 'VN', 0),

(216, 'Virgin Islands, U.S.', 'VI', 0),

(217, 'Yemen', 'YE', 0),

(218, 'Zambia', 'ZM', 0),

(219, 'Zimbabwe', 'ZW', 0);

Edit

Comment ·

1 · 2 years ago

<AndyPSV> @Honey: you must add it manually, I don't have it
<Honey> Hello There,Can you please provide the country table with there currency also
<Sax> I was wondering if someone would actually keep a list of countries like this in SQL for use. Thank
you. This list was quite useful. Let me know if I can do anything in return. – Andrzej Jeziorski 2 months ago · Reply