国家常用代号 for Mysql数据库

梦里梦外; 2022-06-10 11:50 186阅读 0赞

数据结构如下：

![Center][]

使用方式：

一：新建一个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

[Center]: /images/20220610/9792268e50da48859c0c049ae941acdf.png