全世界127个主要国家Mysql数据库下载

项目需要。。找了下,改了下,藏。


SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `country`
-- ----------------------------
DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
  `country_id` tinyint(3) NOT NULL auto_increment,
  `code` varchar(16) NOT NULL,
  `name_chinese` varchar(128) NOT NULL,
  `name_english` varchar(128) NOT NULL,
  PRIMARY KEY  (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;


-- ----------------------------
-- Records of country
-- ----------------------------
INSERT INTO `country` VALUES ('1', '00', '未知的國家', 'Unknown Country');
INSERT INTO `country` VALUES ('2', 'TT', '千里達與托貝哥共和國 (Trinidad and Tobago)', 'Trinidad and Tobago');
INSERT INTO `country` VALUES ('3', 'TV', '土瓦魯 (Tuvalu)', 'Tuvalu');
INSERT INTO `country` VALUES ('4', 'TR', '土耳其 (Türkiye)', 'Turkey (Türkiye)');
INSERT INTO `country` VALUES ('5', 'TM', '土庫曼 (Türkmenistan)', 'Turkmenistan (Türkmenistan)');
INSERT INTO `country` VALUES ('6', 'BT', '不丹 (འབྲུག་ཡུལ)', 'Bhutan (འབྲུག་ཡུལ)');
INSERT INTO `country` VALUES ('7', 'CF', '中非共和國 (République Centrafricaine)', 'Central African Republic (République Centrafricaine)');
INSERT INTO `country` VALUES ('8', 'CN', '中國 (中国)', 'China (中国)');
INSERT INTO `country` VALUES ('9', 'DK', '丹麥 (Danmark)', 'Denmark (Danmark)');
INSERT INTO `country` VALUES ('10', 'EC', '厄瓜多 (Ecuador)', 'Ecuador');
INSERT INTO `country` VALUES ('11', 'ER', '厄利垂亞 (Ertra)', 'Eritrea (Ertra)');
INSERT INTO `country` VALUES ('12', 'PG', '巴布亞紐幾內亞 (Papua New Guinea)', 'Papua New Guinea');
INSERT INTO `country` VALUES ('13', 'BR', '巴西 (Brasil)', 'Brazil (Brasil)');
INSERT INTO `country` VALUES ('14', 'BB', '巴貝多 (Barbados)', 'Barbados');
INSERT INTO `country` VALUES ('15', 'PY', '巴拉圭 (Paraguay)', 'Paraguay');
INSERT INTO `country` VALUES ('16', 'BH', '巴林 (البحرين)', 'Bahrain (البحرين)');
INSERT INTO `country` VALUES ('17', 'BS', '巴哈馬 (Bahamas)', 'Bahamas');
INSERT INTO `country` VALUES ('18', 'PA', '巴拿馬 (Panamá)', 'Panama (Panamá)');
INSERT INTO `country` VALUES ('19', 'PS', '巴勒斯坦領土 (Palestinian Territory)', 'Palestinian Territory');
INSERT INTO `country` VALUES ('20', 'PK', '巴基斯坦 (پاکستان)', 'Pakistan (پاکستان)');
INSERT INTO `country` VALUES ('21', 'JP', '日本', 'Japan (日本)');
INSERT INTO `country` VALUES ('22', 'BE', '比利時 (België)', 'Belgium (België)');
INSERT INTO `country` VALUES ('23', 'JM', '牙買加 (Jamaica)', 'Jamaica');
INSERT INTO `country` VALUES ('24', 'IL', '以色列 (ישראל)', 'Israel (ישראל)');
INSERT INTO `country` VALUES ('25', 'CA', '加拿大 (Canada)', 'Canada');
INSERT INTO `country` VALUES ('26', 'GA', '加彭 (Gabon)', 'Gabon');
INSERT INTO `country` VALUES ('27', 'MP', '北馬里亞納群島 (Northern Mariana Islands)', 'Northern Mariana Islands');
INSERT INTO `country` VALUES ('28', 'KP', '北韓 (조선)', 'North Korea (조선)');
INSERT INTO `country` VALUES ('29', 'QA', '卡達 (قطر)', 'Qatar (قطر)');
INSERT INTO `country` VALUES ('30', 'CU', '古巴 (Cuba)', 'Cuba');
INSERT INTO `country` VALUES ('31', 'SZ', '史瓦濟蘭 (Swaziland)', 'Swaziland');
INSERT INTO `country` VALUES ('32', 'TW', '台灣', 'Taiwan (台灣)');
INSERT INTO `country` VALUES ('33', 'NE', '尼日 (Niger)', 'Niger');
INSERT INTO `country` VALUES ('34', 'NI', '尼加拉瓜 (Nicaragua)', 'Nicaragua');
INSERT INTO `country` VALUES ('35', 'NP', '尼泊爾 (नेपाल)', 'Nepal (नेपाल)');
INSERT INTO `country` VALUES ('36', 'BV', '布干維島 (Bouvet Island)', 'Bouvet Island');
INSERT INTO `country` VALUES ('37', 'BF', '布吉納法索 (Burkina Faso)', 'Burkina Faso');
INSERT INTO `country` VALUES ('38', 'GT', '瓜地馬拉 (Guatemala)', 'Guatemala');
INSERT INTO `country` VALUES ('39', 'GP', '瓜達羅普 (Guadeloupe)', 'Guadeloupe');
INSERT INTO `country` VALUES ('40', 'WF', '瓦利斯群島和富圖納群島 (Wallis and Futuna)', 'Wallis and Futuna');
INSERT INTO `country` VALUES ('41', 'GM', '甘比亞 (Gambia)', 'Gambia');
INSERT INTO `country` VALUES ('42', 'BY', '白俄羅斯 (Белару́сь)', 'Belarus (Белару́сь)');
INSERT INTO `country` VALUES ('43', 'PN', '皮特康 (Pitcairn)', 'Pitcairn');
INSERT INTO `country` VALUES ('44', 'LT', '立陶宛 (Lietuva)', 'Lithuania (Lietuva)');
INSERT INTO `country` VALUES ('45', 'IQ', '伊拉克 (العراق)', 'Iraq (العراق)');
INSERT INTO `country` VALUES ('46', 'IR', '伊朗 (ایران)', 'Iran (ایران)');
INSERT INTO `country` VALUES ('47', 'IS', '冰島 (Ísland)', 'Iceland (Ísland)');
INSERT INTO `country` VALUES ('48', 'LI', '列支敦士登 (Liechtenstein)', 'Liechtenstein');
INSERT INTO `country` VALUES ('49', 'HU', '匈牙利 (Magyarország)', 'Hungary (Magyarország)');
INSERT INTO `country` VALUES ('50', 'ID', '印尼 (Indonesia)', 'Indonesia');
INSERT INTO `country` VALUES ('51', 'IN', '印度 (India)', 'India');
INSERT INTO `country` VALUES ('52', 'DJ', '吉布地 (Djibouti)', 'Djibouti');
INSERT INTO `country` VALUES ('53', 'KI', '吉里巴斯 (Kiribati)', 'Kiribati');
INSERT INTO `country` VALUES ('54', 'KG', '吉爾吉斯 (Кыргызстан)', 'Kyrgyzstan (Кыргызстан)');
INSERT INTO `country` VALUES ('55', 'DO', '多明尼加共和國 (Dominican Republic)', 'Dominican Republic');
INSERT INTO `country` VALUES ('56', 'DM', '多明尼克 (Dominica)', 'Dominica');
INSERT INTO `country` VALUES ('57', 'TG', '多哥 (Togo)', 'Togo');
INSERT INTO `country` VALUES ('58', 'AG', '安地卡及巴布達 (Antigua and Barbuda)', 'Antigua and Barbuda');
INSERT INTO `country` VALUES ('59', 'AO', '安哥拉 (Angola)', 'Angola');
INSERT INTO `country` VALUES ('60', 'AD', '安道爾共和國 (Andorra)', 'Andorra');
INSERT INTO `country` VALUES ('61', 'AI', '安歸拉島 (Anguilla)', 'Anguilla');
INSERT INTO `country` VALUES ('62', 'TK', '托克勞群島 (Tokelau)', 'Tokelau');
INSERT INTO `country` VALUES ('63', 'BM', '百慕達 (Bermuda)', 'Bermuda');
INSERT INTO `country` VALUES ('64', 'ET', '衣索比亞 (Ityop'iya)', 'Ethiopia (Ityop'iya)');
INSERT INTO `country` VALUES ('65', 'ES', '西班牙 (España)', 'Spain (España)');
INSERT INTO `country` VALUES ('66', 'EH', '西撒哈拉 (الصحراء الغربية)', 'Western Sahara (الصحراء الغربية)');
INSERT INTO `country` VALUES ('67', 'HR', '克羅埃西亞 (Hrvatska)', 'Croatia (Hrvatska)');
INSERT INTO `country` VALUES ('68', 'SJ', '冷岸及央棉群島 (Svalbard and Jan Mayen)', 'Svalbard and Jan Mayen');
INSERT INTO `country` VALUES ('69', 'LY', '利比亞 (ليبيا)', 'Libya (ليبيا)');
INSERT INTO `country` VALUES ('70', 'HN', '宏都拉斯 (Honduras)', 'Honduras');
INSERT INTO `country` VALUES ('71', 'GR', '希臘 ('Eλλας)', 'Greece ('Eλλας)');
INSERT INTO `country` VALUES ('72', 'SA', '沙烏地阿拉伯 (المملكة العربية السعودية)', 'Saudi Arabia (المملكة العربية السعودية)');
INSERT INTO `country` VALUES ('73', 'BN', '汶萊 (Brunei Darussalam)', 'Brunei (Brunei Darussalam)');
INSERT INTO `country` VALUES ('74', 'BZ', '貝里斯 (Belize)', 'Belize');
INSERT INTO `country` VALUES ('75', 'BJ', '貝南 (Bénin)', 'Benin (Bénin)');
INSERT INTO `country` VALUES ('76', 'GQ', '赤道幾內亞 (Guinea Ecuatorial)', 'Equatorial Guinea (Guinea Ecuatorial)');
INSERT INTO `country` VALUES ('77', 'ZW', '辛巴威 (Zimbabwe)', 'Zimbabwe');
INSERT INTO `country` VALUES ('78', 'AM', '亞美尼亞 (Հայաստան)', 'Armenia (Հայաստան)');
INSERT INTO `country` VALUES ('79', 'AZ', '亞賽拜然 (Azərbaycan)', 'Azerbaijan (Azərbaycan)');
INSERT INTO `country` VALUES ('80', 'TZ', '坦尚尼亞 (Tanzania)', 'Tanzania');
INSERT INTO `country` VALUES ('81', 'NG', '奈及利亞 (Nigeria)', 'Nigeria');
INSERT INTO `country` VALUES ('82', 'VE', '委內瑞拉 (Venezuela)', 'Venezuela');
INSERT INTO `country` VALUES ('83', 'BD', '孟加拉 (বাংলাদেশ)', 'Bangladesh (বাংলাদেশ)');
INSERT INTO `country` VALUES ('84', 'ZM', '尚比亞 (Zambia)', 'Zambia');
INSERT INTO `country` VALUES ('85', 'PW', '帛琉 (Belau)', 'Palau (Belau)');
INSERT INTO `country` VALUES ('86', 'SB', '所羅門群島 (Solomon Islands)', 'Solomon Islands');
INSERT INTO `country` VALUES ('87', 'LV', '拉脫維亞 (Latvija)', 'Latvia (Latvija)');
INSERT INTO `country` VALUES ('88', 'TO', '東加 (Tonga)', 'Tonga');
INSERT INTO `country` VALUES ('89', 'TL', '東帝汶 (Timor-Leste)', 'East Timor (Timor-Leste)');
INSERT INTO `country` VALUES ('90', 'BA', '波士尼亞-赫塞哥維納 (Bosna i Hercegovina)', 'Bosnia and Herzegovina (Bosna i Hercegovina)');
INSERT INTO `country` VALUES ('91', 'BW', '波札那 (Botswana)', 'Botswana');
INSERT INTO `country` VALUES ('92', 'PR', '波多黎克 (Puerto Rico)', 'Puerto Rico');
INSERT INTO `country` VALUES ('93', 'PL', '波蘭 (Polska)', 'Poland (Polska)');
INSERT INTO `country` VALUES ('94', 'FR', '法國 (France)', 'France');
INSERT INTO `country` VALUES ('95', 'FO', '法羅群島 (Faroe Islands)', 'Faroe Islands');
INSERT INTO `country` VALUES ('96', 'GF', '法屬圭亞那 (French Guiana)', 'French Guiana');
INSERT INTO `country` VALUES ('97', 'PF', '法屬波里尼西亞 (French Polynesia)', 'French Polynesia');
INSERT INTO `country` VALUES ('98', 'TF', '法屬南部屬地 (French Southern Territories)', 'French Southern Territories');
INSERT INTO `country` VALUES ('99', 'GI', '直布羅陀 (Gibraltar)', 'Gibraltar');
INSERT INTO `country` VALUES ('100', 'KE', '肯亞 (Kenya)', 'Kenya');
INSERT INTO `country` VALUES ('101', 'FI', '芬蘭 (Suomi)', 'Finland (Suomi)');
INSERT INTO `country` VALUES ('102', 'AE', '阿拉伯聯合大公國 (الإمارات العربيّة المتّحدة)', 'United Arab Emirates (الإمارات العربيّة المتّحدة)');
INSERT INTO `country` VALUES ('103', 'AR', '阿根廷 (Argentina)', 'Argentina');
INSERT INTO `country` VALUES ('104', 'OM', '阿曼 (عمان)', 'Oman (عمان)');
INSERT INTO `country` VALUES ('105', 'AF', '阿富汗 (افغانستان)', 'Afghanistan (افغانستان)');
INSERT INTO `country` VALUES ('106', 'DZ', '阿爾及利亞 (الجزائر)', 'Algeria (الجزائر)');
INSERT INTO `country` VALUES ('107', 'AL', '阿爾巴尼亞 (Shqipëria)', 'Albania (Shqipëria)');
INSERT INTO `country` VALUES ('108', 'AW', '阿魯巴島 (Aruba)', 'Aruba');
INSERT INTO `country` VALUES ('109', 'BG', '保加利亞 (България)', 'Bulgaria (България)');
INSERT INTO `country` VALUES ('110', 'RU', '俄羅斯 (Россия)', 'Russia (Россия)');
INSERT INTO `country` VALUES ('111', 'ZA', '南非 (South Africa)', 'South Africa');
INSERT INTO `country` VALUES ('112', 'GS', '南喬治亞與南桑威奇群島 (South Georgia and the South Sandwich Islands)', 'South Georgia and the South Sandwich Islands');
INSERT INTO `country` VALUES ('113', 'AQ', '南極洲 (Antarctica)', 'Antarctica');
INSERT INTO `country` VALUES ('114', 'KR', '南韓 (한국)', 'South Korea (한국)');
INSERT INTO `country` VALUES ('115', 'KZ', '哈薩克 (Қазақстан)', 'Kazakhstan (Қазақстан)');
INSERT INTO `country` VALUES ('116', 'KH', '柬埔寨 (Kampuchea)', 'Cambodia (Kampuchea)');
INSERT INTO `country` VALUES ('117', 'TD', '查德 (Tchad)', 'Chad (Tchad)');
INSERT INTO `country` VALUES ('118', 'BO', '玻利維亞 (Bolivia)', 'Bolivia');
INSERT INTO `country` VALUES ('119', 'CC', '科克群島 (Cocos Islands)', 'Cocos Islands');
INSERT INTO `country` VALUES ('120', 'CK', '科克群島 (Cook Islands)', 'Cook Islands');
INSERT INTO `country` VALUES ('121', 'KW', '科威特 (الكويت)', 'Kuwait (الكويت)');
INSERT INTO `country` VALUES ('122', 'KM', '科摩洛 (Comores)', 'Comoros (Comores)');
INSERT INTO `country` VALUES ('123', 'TN', '突尼西亞 (تونس)', 'Tunisia (تونس)');
INSERT INTO `country` VALUES ('124', 'JO', '約旦 (الاردن)', 'Jordan (الاردن)');
INSERT INTO `country` VALUES ('125', 'US', '美國 (United States)', 'United States');
INSERT INTO `country` VALUES ('126', 'UM', '美屬外部小群島 (United States minor outlying islands)', 'United States minor outlying islands');
INSERT INTO `country` VALUES ('127', 'VI', '美屬維京群島 (Virgin Islands, U.S.)', 'Virgin Islands, U.S.');
 


结束。

或者直接下载.sql文件 >>> 世界国家表数据库

更,2011.3.17

CREATE TABLE `country` (
  `id` smallint(4) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `code` varchar(5) NOT NULL default '',
  `code2` varchar(5) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=243 DEFAULT CHARSET=utf8;

/*Data for the table `country` */

insert  into `country`(`id`,`name`,`code`,`code2`) values (1,'Afghanistan','AF','93');
insert  into `country`(`id`,`name`,`code`,`code2`) values (2,'Albania','AL','355');

中英 - 全世界242个国家.sql文件下载