国家常用代号 for Mysql数据库

数据结构如下：

 

使用方式：

 

一：新建一个cmf_country_code.sql文件，用记事本打开，将下面的代码粘贴进去，然后打开Mysql数据库，执行导入.sql文件即可。

SET FOREIGN_KEY_CHECKS=0;


-- ----------------------------
-- Table structure for `cmf_country_code`
-- ----------------------------
DROP TABLE IF EXISTS `cmf_country_code`;
CREATE TABLE `cmf_country_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country` varchar(255) DEFAULT NULL COMMENT '国家名称',
  `code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8mb4;


-- ----------------------------
-- Records of cmf_country_code
-- ----------------------------
INSERT INTO `cmf_country_code` VALUES ('1', '美国，加拿大', '1');
INSERT INTO `cmf_country_code` VALUES ('2', '哈萨克斯坦，俄罗斯', '7');
INSERT INTO `cmf_country_code` VALUES ('3', '埃及', '20');
INSERT INTO `cmf_country_code` VALUES ('4', '南非', '27');
INSERT INTO `cmf_country_code` VALUES ('5', '希腊', '30');
INSERT INTO `cmf_country_code` VALUES ('6', '荷兰', '31');
INSERT INTO `cmf_country_code` VALUES ('7', '比利时', '32');
INSERT INTO `cmf_country_code` VALUES ('8', '法国', '33');
INSERT INTO `cmf_country_code` VALUES ('9', '西班牙', '34');
INSERT INTO `cmf_country_code` VALUES ('10', '匈牙利', '36');
INSERT INTO `cmf_country_code` VALUES ('11', '意大利', '39');
INSERT INTO `cmf_country_code` VALUES ('12', '罗马尼亚', '40');
INSERT INTO `cmf_country_code` VALUES ('13', '瑞士', '41');
INSERT INTO `cmf_country_code` VALUES ('14', '奥地利', '43');
INSERT INTO `cmf_country_code` VALUES ('15', '根西，马恩，泽西，英国', '44');
INSERT INTO `cmf_country_code` VALUES ('16', '丹麦', '45');
INSERT INTO `cmf_country_code` VALUES ('17', '瑞典', '46');
INSERT INTO `cmf_country_code` VALUES ('18', '挪威', '47');
INSERT INTO `cmf_country_code` VALUES ('19', '波兰', '48');
INSERT INTO `cmf_country_code` VALUES ('20', '德国', '49');
INSERT INTO `cmf_country_code` VALUES ('21', '秘鲁', '51');
INSERT INTO `cmf_country_code` VALUES ('22', '墨西哥', '52');
INSERT INTO `cmf_country_code` VALUES ('23', '古巴', '53');
INSERT INTO `cmf_country_code` VALUES ('24', '阿根廷', '54');
INSERT INTO `cmf_country_code` VALUES ('25', '巴西', '55');
INSERT INTO `cmf_country_code` VALUES ('26', '智利', '56');
INSERT INTO `cmf_country_code` VALUES ('27', '哥伦比亚', '57');
INSERT INTO `cmf_country_code` VALUES ('28', '委内瑞拉', '58');
INSERT INTO `cmf_country_code` VALUES ('29', '马来西亚', '60');
INSERT INTO `cmf_country_code` VALUES ('30', '澳大利亚', '61');
INSERT INTO `cmf_country_code` VALUES ('31', '印度尼西亚', '62');
INSERT INTO `cmf_country_code` VALUES ('32', '菲律宾', '63');
INSERT INTO `cmf_country_code` VALUES ('33', '新西兰', '64');
INSERT INTO `cmf_country_code` VALUES ('34', '新加坡', '65');
INSERT INTO `cmf_country_code` VALUES ('35', '泰国', '66');
INSERT INTO `cmf_country_code` VALUES ('36', '日本', '81');
INSERT INTO `cmf_country_code` VALUES ('37', '韩国', '82');
INSERT INTO `cmf_country_code` VALUES ('38', '越南', '84');
INSERT INTO `cmf_country_code` VALUES ('39', '土耳其', '90');
INSERT INTO `cmf_country_code` VALUES ('40', '印度', '91');
INSERT INTO `cmf_country_code` VALUES ('41', '巴基斯坦', '92');
INSERT INTO `cmf_country_code` VALUES ('42', '阿富汗', '93');
INSERT INTO `cmf_country_code` VALUES ('43', '斯里兰卡', '94');
INSERT INTO `cmf_country_code` VALUES ('44', '缅甸', '95');
INSERT INTO `cmf_country_code` VALUES ('45', '伊朗', '98');
INSERT INTO `cmf_country_code` VALUES ('46', '南苏丹', '211');
INSERT INTO `cmf_country_code` VALUES ('47', '摩洛哥', '212');
INSERT INTO `cmf_country_code` VALUES ('48', '阿尔及利亚', '213');
INSERT INTO `cmf_country_code` VALUES ('49', '突尼斯', '216');
INSERT INTO `cmf_country_code` VALUES ('50', '利比亚', '218');
INSERT INTO `cmf_country_code` VALUES ('51', '冈比亚', '220');
INSERT INTO `cmf_country_code` VALUES ('52', '塞内加尔', '221');
INSERT INTO `cmf_country_code` VALUES ('53', '毛里塔尼亚', '222');
INSERT INTO `cmf_country_code` VALUES ('54', '马里', '223');
INSERT INTO `cmf_country_code` VALUES ('55', '科特迪瓦', '225');
INSERT INTO `cmf_country_code` VALUES ('56', '布基纳法索', '226');
INSERT INTO `cmf_country_code` VALUES ('57', '尼日尔', '227');
INSERT INTO `cmf_country_code` VALUES ('58', '多哥', '228');
INSERT INTO `cmf_country_code` VALUES ('59', '贝宁', '229');
INSERT INTO `cmf_country_code` VALUES ('60', '毛里求斯', '230');
INSERT INTO `cmf_country_code` VALUES ('61', '利比里亚', '231');
INSERT INTO `cmf_country_code` VALUES ('62', '塞拉利昂', '232');
INSERT INTO `cmf_country_code` VALUES ('63', '加纳', '233');
INSERT INTO `cmf_country_code` VALUES ('64', '尼日利亚', '234');
INSERT INTO `cmf_country_code` VALUES ('65', '乍得', '235');
INSERT INTO `cmf_country_code` VALUES ('66', '中非共和国', '236');
INSERT INTO `cmf_country_code` VALUES ('67', '喀麦隆', '237');
INSERT INTO `cmf_country_code` VALUES ('68', '佛得角', '238');
INSERT INTO `cmf_country_code` VALUES ('69', '赤道几内亚', '240');
INSERT INTO `cmf_country_code` VALUES ('70', '加蓬', '241');
INSERT INTO `cmf_country_code` VALUES ('71', '刚果', '242');
INSERT INTO `cmf_country_code` VALUES ('72', '刚果民主共和国', '243');
INSERT INTO `cmf_country_code` VALUES ('73', '安哥拉', '244');
INSERT INTO `cmf_country_code` VALUES ('74', '几内亚比绍共和国', '245');
INSERT INTO `cmf_country_code` VALUES ('75', '塞舌尔', '248');
INSERT INTO `cmf_country_code` VALUES ('76', '苏丹', '249');
INSERT INTO `cmf_country_code` VALUES ('77', '卢旺达', '250');
INSERT INTO `cmf_country_code` VALUES ('78', '埃塞俄比亚', '251');
INSERT INTO `cmf_country_code` VALUES ('79', '索马里', '252');
INSERT INTO `cmf_country_code` VALUES ('80', '吉布提', '253');
INSERT INTO `cmf_country_code` VALUES ('81', '肯尼亚', '254');
INSERT INTO `cmf_country_code` VALUES ('82', '坦桑尼亚', '255');
INSERT INTO `cmf_country_code` VALUES ('83', '乌干达', '256');
INSERT INTO `cmf_country_code` VALUES ('84', '布隆迪', '257');
INSERT INTO `cmf_country_code` VALUES ('85', '莫桑比克', '258');
INSERT INTO `cmf_country_code` VALUES ('86', '赞比亚', '260');
INSERT INTO `cmf_country_code` VALUES ('87', '马达加斯加', '261');
INSERT INTO `cmf_country_code` VALUES ('88', '留尼旺', '262');
INSERT INTO `cmf_country_code` VALUES ('89', '津巴布韦', '263');
INSERT INTO `cmf_country_code` VALUES ('90', '纳米比亚', '264');
INSERT INTO `cmf_country_code` VALUES ('91', '马拉维', '265');
INSERT INTO `cmf_country_code` VALUES ('92', '莱索托', '266');
INSERT INTO `cmf_country_code` VALUES ('93', '博茨瓦纳', '267');
INSERT INTO `cmf_country_code` VALUES ('94', '斯威士兰', '268');
INSERT INTO `cmf_country_code` VALUES ('95', '科摩罗', '269');
INSERT INTO `cmf_country_code` VALUES ('96', '厄立特里亚', '291');
INSERT INTO `cmf_country_code` VALUES ('97', '阿鲁巴', '297');
INSERT INTO `cmf_country_code` VALUES ('98', '法罗群岛', '298');
INSERT INTO `cmf_country_code` VALUES ('99', '格陵兰岛', '299');
INSERT INTO `cmf_country_code` VALUES ('100', '直布罗陀', '350');
INSERT INTO `cmf_country_code` VALUES ('101', '葡萄牙', '351');
INSERT INTO `cmf_country_code` VALUES ('102', '卢森堡', '352');
INSERT INTO `cmf_country_code` VALUES ('103', '爱尔兰', '353');
INSERT INTO `cmf_country_code` VALUES ('104', '冰岛', '354');
INSERT INTO `cmf_country_code` VALUES ('105', '阿尔巴尼亚', '355');
INSERT INTO `cmf_country_code` VALUES ('106', '马耳他', '356');
INSERT INTO `cmf_country_code` VALUES ('107', '塞浦路斯', '357');
INSERT INTO `cmf_country_code` VALUES ('108', '芬兰', '358');
INSERT INTO `cmf_country_code` VALUES ('109', '保加利亚', '359');
INSERT INTO `cmf_country_code` VALUES ('110', '立陶宛', '370');
INSERT INTO `cmf_country_code` VALUES ('111', '拉脱维亚', '371');
INSERT INTO `cmf_country_code` VALUES ('112', '爱沙尼亚', '372');
INSERT INTO `cmf_country_code` VALUES ('113', '摩尔多瓦', '373');
INSERT INTO `cmf_country_code` VALUES ('114', '亚美尼亚', '374');
INSERT INTO `cmf_country_code` VALUES ('115', '白俄罗斯', '375');
INSERT INTO `cmf_country_code` VALUES ('116', '安道尔', '376');
INSERT INTO `cmf_country_code` VALUES ('117', '摩纳哥', '377');
INSERT INTO `cmf_country_code` VALUES ('118', '圣马力诺', '378');
INSERT INTO `cmf_country_code` VALUES ('119', '乌克兰', '380');
INSERT INTO `cmf_country_code` VALUES ('120', '科索沃，塞尔维亚', '381');
INSERT INTO `cmf_country_code` VALUES ('121', '黑山共和国', '382');
INSERT INTO `cmf_country_code` VALUES ('122', '克罗地亚', '385');
INSERT INTO `cmf_country_code` VALUES ('123', '斯洛文尼亚', '386');
INSERT INTO `cmf_country_code` VALUES ('124', '波黑', '387');
INSERT INTO `cmf_country_code` VALUES ('125', '马其顿王国', '389');
INSERT INTO `cmf_country_code` VALUES ('126', '捷克共和国', '420');
INSERT INTO `cmf_country_code` VALUES ('127', '斯洛伐克', '421');
INSERT INTO `cmf_country_code` VALUES ('128', '列支敦斯登', '423');
INSERT INTO `cmf_country_code` VALUES ('129', '福克兰群岛', '500');
INSERT INTO `cmf_country_code` VALUES ('130', '伯利兹', '501');
INSERT INTO `cmf_country_code` VALUES ('131', '危地马拉', '502');
INSERT INTO `cmf_country_code` VALUES ('132', '萨尔瓦多', '503');
INSERT INTO `cmf_country_code` VALUES ('133', '洪都拉斯', '504');
INSERT INTO `cmf_country_code` VALUES ('134', '尼加拉瓜', '505');
INSERT INTO `cmf_country_code` VALUES ('135', '哥斯达黎加', '506');
INSERT INTO `cmf_country_code` VALUES ('136', '巴拿马', '507');
INSERT INTO `cmf_country_code` VALUES ('137', '海地', '509');
INSERT INTO `cmf_country_code` VALUES ('138', '瓜德罗普', '590');
INSERT INTO `cmf_country_code` VALUES ('139', '玻利维亚', '591');
INSERT INTO `cmf_country_code` VALUES ('140', '圭亚那', '592');
INSERT INTO `cmf_country_code` VALUES ('141', '厄瓜多尔', '593');
INSERT INTO `cmf_country_code` VALUES ('142', '法属圭亚那', '594');
INSERT INTO `cmf_country_code` VALUES ('143', '巴拉圭', '595');
INSERT INTO `cmf_country_code` VALUES ('144', '马提尼克', '596');
INSERT INTO `cmf_country_code` VALUES ('145', '苏里南', '597');
INSERT INTO `cmf_country_code` VALUES ('146', '乌拉圭', '598');
INSERT INTO `cmf_country_code` VALUES ('147', '荷属安德列斯群岛', '599');
INSERT INTO `cmf_country_code` VALUES ('148', '东帝汶', '670');
INSERT INTO `cmf_country_code` VALUES ('149', '关岛', '671');
INSERT INTO `cmf_country_code` VALUES ('150', '文莱达鲁萨兰国', '673');
INSERT INTO `cmf_country_code` VALUES ('151', '几内亚,巴布亚新几内亚', '675');
INSERT INTO `cmf_country_code` VALUES ('152', '汤加', '676');
INSERT INTO `cmf_country_code` VALUES ('153', '所罗门群岛', '677');
INSERT INTO `cmf_country_code` VALUES ('154', '瓦努阿图', '678');
INSERT INTO `cmf_country_code` VALUES ('155', '斐济', '679');
INSERT INTO `cmf_country_code` VALUES ('156', '帕劳', '680');
INSERT INTO `cmf_country_code` VALUES ('157', '库克群岛', '682');
INSERT INTO `cmf_country_code` VALUES ('158', '美属萨摩亚,萨摩亚群岛', '684');
INSERT INTO `cmf_country_code` VALUES ('159', '新喀里多尼亚', '687');
INSERT INTO `cmf_country_code` VALUES ('160', '法属玻利尼西亚', '689');
INSERT INTO `cmf_country_code` VALUES ('161', '朝鲜', '850');
INSERT INTO `cmf_country_code` VALUES ('162', '中国香港', '852');
INSERT INTO `cmf_country_code` VALUES ('163', '中国澳门', '853');
INSERT INTO `cmf_country_code` VALUES ('164', '柬埔寨', '855');
INSERT INTO `cmf_country_code` VALUES ('165', '老挝', '856');
INSERT INTO `cmf_country_code` VALUES ('166', '孟加拉国', '880');
INSERT INTO `cmf_country_code` VALUES ('167', '中国台湾', '886');
INSERT INTO `cmf_country_code` VALUES ('168', '马尔代夫', '960');
INSERT INTO `cmf_country_code` VALUES ('169', '黎巴嫩', '961');
INSERT INTO `cmf_country_code` VALUES ('170', '约旦', '962');
INSERT INTO `cmf_country_code` VALUES ('171', '阿拉伯叙利亚共和国', '963');
INSERT INTO `cmf_country_code` VALUES ('172', '伊拉克', '964');
INSERT INTO `cmf_country_code` VALUES ('173', '科威特', '965');
INSERT INTO `cmf_country_code` VALUES ('174', '沙特阿拉伯', '966');
INSERT INTO `cmf_country_code` VALUES ('175', '也门', '967');
INSERT INTO `cmf_country_code` VALUES ('176', '阿曼', '968');
INSERT INTO `cmf_country_code` VALUES ('177', '阿拉伯联合酋长国', '971');
INSERT INTO `cmf_country_code` VALUES ('178', '以色列', '972');
INSERT INTO `cmf_country_code` VALUES ('179', '巴林', '973');
INSERT INTO `cmf_country_code` VALUES ('180', '卡塔尔', '974');
INSERT INTO `cmf_country_code` VALUES ('181', '不丹', '975');
INSERT INTO `cmf_country_code` VALUES ('182', '蒙古', '976');
INSERT INTO `cmf_country_code` VALUES ('183', '尼泊尔', '977');
INSERT INTO `cmf_country_code` VALUES ('184', '塔吉克斯坦', '992');
INSERT INTO `cmf_country_code` VALUES ('185', '土库曼斯坦', '993');
INSERT INTO `cmf_country_code` VALUES ('186', '阿塞拜疆', '994');
INSERT INTO `cmf_country_code` VALUES ('187', '格鲁吉亚', '995');
INSERT INTO `cmf_country_code` VALUES ('188', '吉尔吉斯斯坦', '996');
INSERT INTO `cmf_country_code` VALUES ('189', '乌兹别克斯坦', '998');
INSERT INTO `cmf_country_code` VALUES ('190', '巴哈马群岛', '1242');
INSERT INTO `cmf_country_code` VALUES ('191', '巴巴多斯', '1246');
INSERT INTO `cmf_country_code` VALUES ('192', '安圭拉岛', '1264');
INSERT INTO `cmf_country_code` VALUES ('193', '安提瓜和巴布达', '1268');
INSERT INTO `cmf_country_code` VALUES ('194', '英属维尔京群岛', '1340');
INSERT INTO `cmf_country_code` VALUES ('195', '开曼群岛', '1345');
INSERT INTO `cmf_country_code` VALUES ('196', '百慕大群岛', '1441');
INSERT INTO `cmf_country_code` VALUES ('197', '特克斯和凯科斯群岛', '1649');
INSERT INTO `cmf_country_code` VALUES ('198', '蒙特塞拉特岛', '1664');
INSERT INTO `cmf_country_code` VALUES ('199', '圣卢西亚岛', '1758');
INSERT INTO `cmf_country_code` VALUES ('200', '多米尼克', '1767');
INSERT INTO `cmf_country_code` VALUES ('201', '圣文森特和格林纳丁斯', '1784');
INSERT INTO `cmf_country_code` VALUES ('202', '波多黎各', '1787');
INSERT INTO `cmf_country_code` VALUES ('203', '格林纳达,特立尼达和多巴哥', '1809');
INSERT INTO `cmf_country_code` VALUES ('204', '圣基茨和尼维斯', '1869');
INSERT INTO `cmf_country_code` VALUES ('205', '牙买加', '1876');
INSERT INTO `cmf_country_code` VALUES ('206', '多米尼亚共和国', '1890');

INSERT INTO `cmf_country_code` VALUES ('207', '中国大陆', '86');

二：点击下面链接，下载.sql文件，直接在mysql数据库中导入即可。

 

http://pan.baidu.com/s/1pLBfNHD

 

密码：yc5g