全球国家经纬度坐标数据-MySQL

因为工作上需求原因需要用到国外的国家名和经纬度等数据，网上找了很久，暂时得不到完整所需的数据，故而从网上收集数据并且自己手动完善，得到如下的信息，整理了一整天，如果对你有所帮助，还请帮忙点个赞，谢谢大佬们~

MySQL数据库中数据如图

MySQL数据库脚本（直接复制即可使用）

// An highlighted block
DROP TABLE IF EXISTS `country_config`;
CREATE TABLE `country_config`  (
  `CountryChinese` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家中文名',
  `CountryEnglish` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家英文名',
  `MatchingWords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键匹配词',
  `Longitude` double NULL DEFAULT NULL COMMENT '经度',
  `Latitude` double NULL DEFAULT NULL COMMENT '纬度'
) ENGINE = InnoDB AUTO_INCREMENT = 265 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of country_config
-- ----------------------------
INSERT INTO `country_config` VALUES ('安道尔', 'Andorra', NULL, 1.601554, 42.546245);
INSERT INTO `country_config` VALUES ('阿拉伯联合酋长国', 'United Arab Emirates', NULL, 53.847818, 23.424076);
INSERT INTO `country_config` VALUES ('阿富汗', 'Afghanistan', NULL, 67.709953, 33.93911);
INSERT INTO `country_config` VALUES ('安提瓜和巴布达', 'Antigua and Barbuda', NULL, -61.796428, 17.060816);
INSERT INTO `country_config` VALUES ('安圭拉', 'Anguilla', NULL, -63.068615, 18.220554);
INSERT INTO `country_config` VALUES ('阿尔巴尼亚', 'Albania', NULL, 20.168331, 41.153332);
INSERT INTO `country_config` VALUES ('亚美尼亚', 'Armenia', NULL, 45.038189, 40.069099);
INSERT INTO `country_config` VALUES ('荷属安的列斯群岛', 'Curasao', NULL, -69.060087, 12.226079);
INSERT INTO `country_config` VALUES ('安哥拉', 'Angola', NULL, 17.873887, -11.202692);
INSERT INTO `country_config` VALUES ('南极洲', 'Argentina', NULL, -63.616672, -38.416097);
INSERT INTO `country_config` VALUES ('美洲萨摩亚群岛', 'American Samoa', NULL, -170.132217, -14.270972);
INSERT INTO `country_config` VALUES ('奥地利', 'Austria', NULL, 14.550072, 47.516231);
INSERT INTO `country_config` VALUES ('澳大利亚', 'Australia', NULL, 133.775136, -25.274398);
INSERT INTO `country_config` VALUES ('阿鲁巴', 'Aruba', NULL, -69.968338, 12.52111);
INSERT INTO `country_config` VALUES ('阿塞拜疆', 'Azerbaijan', NULL, 47.576927, 40.143105);
INSERT INTO `country_config` VALUES ('波斯尼亚和黑塞哥维那', 'Bosnia and Herzegovina', NULL, 17.679076, 43.915886);
INSERT INTO `country_config` VALUES ('巴巴多斯', 'Barbados', NULL, -59.543198, 13.193887);
INSERT INTO `country_config` VALUES ('孟加拉国', 'Bangladesh', NULL, 90.356331, 23.684994);
INSERT INTO `country_config` VALUES ('比利时', 'Belgium', NULL, 4.469936, 50.503887);
INSERT INTO `country_config` VALUES ('布基纳法索', 'Burkina Faso', NULL, -1.561593, 12.238333);
INSERT INTO `country_config` VALUES ('保加利亚', 'Bulgaria', NULL, 25.48583, 42.733883);
INSERT INTO `country_config` VALUES ('巴林', 'Bahrain', NULL, 50.637772, 25.930414);
INSERT INTO `country_config` VALUES ('布隆迪', 'Burundi', NULL, 29.918886, -3.373056);
INSERT INTO `country_config` VALUES ('贝宁', 'Benin', NULL, 2.315834, 9.30769);
INSERT INTO `country_config` VALUES ('百慕大', 'Bermuda', NULL, -64.75737, 32.321384);
INSERT INTO `country_config` VALUES ('文莱', 'Brunei', NULL, 114.727669, 4.535277);
INSERT INTO `country_config` VALUES ('玻利维亚', 'Bolivia', NULL, -63.588653, -16.290154);
INSERT INTO `country_config` VALUES ('巴西', 'Brazil', NULL, -51.92528, -14.235004);
INSERT INTO `country_config` VALUES ('巴哈马', 'Bahamas', NULL, -77.39628, 25.03428);
INSERT INTO `country_config` VALUES ('不丹', 'Bhutan', NULL, 90.433601, 27.514162);
INSERT INTO `country_config` VALUES ('布韦岛', 'Bouvet Island', NULL, 3.413194, -54.423199);
INSERT INTO `country_config` VALUES ('博茨瓦纳', 'Botswana', NULL, 24.684866, -22.328474);
INSERT INTO `country_config` VALUES ('白俄罗斯', 'Belarus', NULL, 27.953389, 53.709807);
INSERT INTO `country_config` VALUES ('伯利兹', 'Belize', NULL, -88.49765, 17.189877);
INSERT INTO `country_config` VALUES ('加拿大', 'Canada', NULL, -106.346771, 56.130366);
INSERT INTO `country_config` VALUES ('科科斯群岛', 'Cocos Islands', NULL, 96.870956, -12.164165);
INSERT INTO `country_config` VALUES ('刚果', 'Democratic Republic of the Congo', NULL, 21.758664, -4.038333);
INSERT INTO `country_config` VALUES ('中非', 'Central African Republic', NULL, 20.939444, 6.611111);
INSERT INTO `country_config` VALUES ('瑞士', 'Switzerland', NULL, 8.227512, 46.818188);
INSERT INTO `country_config` VALUES ('库克群岛', 'Cook Islands', NULL, -159.777671, -21.236736);
INSERT INTO `country_config` VALUES ('智利', 'Chile', NULL, -71.542969, -35.675147);
INSERT INTO `country_config` VALUES ('喀麦隆', 'Cameroon'