世界各国和地区名称代码，内附xlsx和SQL

/* Navicat Premium Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 80021 Source Host : localhost:3306 Source Schema : ywb_dictionary Target Server Type : MySQL Target Server Version : 80021 File Encoding : 65001 Date: 20/01/2022 09:35:54 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for base_currency -- ---------------------------- DROP TABLE IF EXISTS `base_country`; CREATE TABLE `base_country` ( `country_code` int(5) DEFAULT NULL COMMENT '国家代码',, `two_letter` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '两位字母的国家代码', `three_letter` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '三位字母的国家代码', `country_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家名称' ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of base_currency -- ---------------------------- insert into `base_country` VALUES(20 , 'AD', 'AND', '安道尔'); insert into `base_country` VALUES(784 , 'AE', 'ARE', '阿联酋'); insert into `base_country` VALUES(4 , 'AF', 'AFG', '阿富汗'); insert into `base_country` VALUES(28 , 'AG', 'ATG', '安提瓜和巴布达'); insert into `base_country` VALUES(660 , 'AI', 'AIA', '安圭拉'); insert into `base_country` VALUES(8 , 'AL', 'ALB', '阿尔巴尼亚'); insert into `base_country` VALUES(51 , 'AM', 'ARM', '亚美尼亚'); insert into `base_country` VALUES(24 , 'AO', 'AGO', '安哥拉'); insert into `base_country` VALUES(10 , 'AQ', 'ATA', '南极洲'); insert into `base_country` VALUES(32 , 'AR', 'ARG', '阿根廷'); insert into `base_country` VALUES(16 , 'AS', 'ASM', '美属萨摩亚'); insert into `base_country` VALUES(40 , 'AT', 'AUT', '奥地利'); insert into `base_country` VALUES(36 , 'AU', 'AUS', '澳大利亚'); insert into `base_country` VALUES(533 , 'AW', 'ABW', '阿鲁巴'); insert into `base_country` VALUES(248 , 'AX', 'ALA', '奥兰'); insert into `base_country` VALUES(31 , 'AZ', 'AZE', '阿塞拜疆'); insert into `base_country` VALUES(70 , 'BA', 'BIH', '波斯尼亚和黑塞哥维那'); insert into `base_country` VALUES(52 , 'BB', 'BRB', '巴巴多斯'); insert into `base_country` VALUES(50 , 'BD', 'BGD', '孟加拉'); insert into `base_country` VALUES(56 , 'BE', 'BEL', '比利时'); insert into `base_country` VALUES(854 , 'BF', 'BFA', '布基纳法索'); insert into `base_country` VALUES(100 , 'BG', 'BGR', '保加利亚'); insert into `base_country` VALUES(48 , 'BH', 'BHR', '巴林'); insert into `base_country` VALUES(108 , 'BI', 'BDI', '布隆迪'); insert into `base_country` VALUES(204 , 'BJ', 'BEN', '贝宁'); insert into `base_country` VALUES(652 , 'BL', 'BLM', '圣巴泰勒米'); insert into `base_country` VALUES(60 , 'BM', 'BMU', '百慕大'); insert into `base_country` VALUES(96 , 'BN', 'BRN', '文莱'); insert into `base_country` VALUES(68 , 'BO', 'BOL', '玻利维亚'); insert into `base_country` VALUES(535 , 'BQ', 'BES', '加勒比荷兰'); insert into `base_country` VALUES(76 , 'BR', 'BRA', '巴西'); insert into `base_country` VALUES(44 , 'BS', 'BHS', '巴哈马'); insert into `base_country` VALUES(64 , 'BT', 'BTN', '不丹'); insert into `base_country` VALUES(74 , 'BV', 'BVT', '布韦岛'); insert into `base_country` VALUES(72 , 'BW', 'BWA', '博茨瓦纳'); insert into `base_country` VALUES(112 , 'BY', 'BLR', '白俄罗斯'); insert into `base_country` VALUES(84 , 'BZ', 'BLZ', '伯利兹'); insert into `base_country` VALUES(124 , 'CA', 'CAN', '加拿大'); insert into `base_country` VALUES(166 , 'CC', 'CCK', '科科斯（基林）群岛'); insert into `base_country` VALUES(180 , 'CD', 'COD', '刚果（金）'); insert into `base_country` VALUES(140 , 'CF', 'CAF', '中非'); insert into `base_country` VALUES(178 , 'CG', 'COG', '刚果（布）'); insert into `base_country` VALUES(756 , 'CH', 'CHE', '瑞士'); insert into `base_country` VALUES(384 , 'CI', 'CIV', '科特迪瓦'); insert into `base_country` VALUES(184 , 'CK', 'COK', '库克群岛'); insert into `base_country` VALUES(152 , 'CL', 'CHL', '智利'); insert into `base_country` VALUES(120 , 'CM', 'CMR', '喀麦隆'); insert into `base_country` VALUES(156 , 'CN', 'CHN', '中国'); insert into `base_country` VALUES(170 , 'CO', 'COL', '哥伦比亚'); insert into `base_country` VALUES(188 , 'CR', 'CRI', '哥斯达黎加'); insert into `base_country` VALUES(192 , 'CU', 'CUB', '古巴'); insert into `base_country` VALUES(132 , 'CV', 'CPV', '佛得角'); insert into `base_country` VALUES(531 , 'CW', 'CUW', '库拉索'); insert into `base_country` VALUES(162 , 'CX', 'CXR', '圣诞岛'); insert into `base_country` VALUES(196 , 'CY', 'CYP', '塞浦路斯'); insert into `base_country` VALUES(203 , 'CZ', 'CZE', '捷克'); insert into `base_country` VALUES(276 , 'DE', 'DEU', '德国'); insert into `base_country` VALUES(262 , 'DJ', 'DJI', '吉布提'); insert into `base_country` VALUES(208 , 'DK', 'DNK', '丹麦'); insert into `base_country` VALUES(212 , 'DM', 'DMA', '多米尼克'); insert into `base_country` VALUES(214 , 'DO', 'DOM', '多米尼加'); insert into `base_country` VALUES(12 , 'DZ', 'DZA', '阿尔及利亚'); insert into `base_country` VALUES(218 , 'EC', 'ECU', '厄瓜多尔'); insert into `base_country` VALUES(233 , 'EE', 'EST', '爱沙尼亚'); insert into `base_country` VALUES(818 , 'EG', 'EGY', '埃及'); insert into `base_country` VALUES(732 , 'EH', 'ESH', '阿拉伯撒哈拉民主共和国'); insert into `base_country` VALUES(232 , 'ER', 'ERI', '厄立特里亚'); insert into `base_country` VALUES(724 , 'ES', 'ESP', '西班牙'); insert into `base_country` VALUES(231 , 'ET', 'ETH', '埃塞俄比亚'); insert into `base_country` VALUES(246 , 'FI', 'FIN', '芬兰'); insert into `base_country` VALUES(242 , 'FJ', 'FJI', '斐济'); insert into `base_country` VALUES(238 , 'FK', 'FLK', '福克兰群岛'); insert into `base_country` VALUES(583 , 'FM', 'FSM', '密克罗尼西亚联邦'); insert into `base_country` VALUES(234 , 'FO', 'FRO', '法罗群岛'); insert into `base_country` VALUES(250 , 'FR', 'FRA', '法国'); insert into `base_country` VALUES(266 , 'GA', 'GAB', '加蓬');