地球全国名称SQL

-- ----------------------------
-- Table structure for lz_countries
-- ----------------------------
DROP TABLE IF EXISTS `lz_countries`;
CREATE TABLE `lz_countries`  (
  `id` int(10) NOT NULL COMMENT '国家id',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '国家名',
  `code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '国家代码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of lz_countries
-- ----------------------------
INSERT INTO `lz_countries` VALUES (1, '中国', 'CHINA');
INSERT INTO `lz_countries` VALUES (2, '阿尔巴尼亚', 'ALB');
INSERT INTO `lz_countries` VALUES (3, '阿尔及利亚', 'DZA');
INSERT INTO `lz_countries` VALUES (4, '阿富汗', 'AFG');
INSERT INTO `lz_countries` VALUES (5, '阿根廷', 'ARG');
INSERT INTO `lz_countries` VALUES (6, '阿拉伯联合酋长国', 'ARE');
INSERT INTO `lz_countries` VALUES (7, '阿鲁巴', 'ABW');
INSERT INTO `lz_countries` VALUES (8, '阿曼', 'OMN');
INSERT INTO `lz_countries` VALUES (9, '阿塞拜疆', 'AZE');
INSERT INTO `lz_countries` VALUES (10, '阿森松岛', 'ASC');
INSERT INTO `lz_countries` VALUES (11, '埃及', 'EGY');
INSERT INTO `lz_countries` VALUES (12, '埃塞俄比亚', 'ETH');
INSERT INTO `lz_countries` VALUES (13, '爱尔兰', 'IRL');
INSERT INTO `lz_countries` VALUES (14, '爱沙尼亚', 'EST');
INSERT INTO `lz_countries` VALUES (15, '安道尔', 'AND');
INSERT INTO `lz_countries` VALUES (16, '安哥拉', 'AGO');
INSERT INTO `lz_countries` VALUES (17, '安圭拉', 'AIA');
INSERT INTO `lz_countries` VALUES (18, '安提瓜岛和巴布达', 'ATG');
INSERT INTO `lz_countries` VALUES (19, '奥地利', 'AUT');
INSERT INTO `lz_countries` VALUES (20, '奥兰群岛', 'ALA');
INSERT INTO `lz_countries` VALUES (21, '澳大利亚', 'AUS');
INSERT INTO `lz_countries` VALUES (22, '巴巴多斯岛', 'BRB');
INSERT INTO `lz_countries` VALUES (23, '巴布亚新几内亚', 'PNG');
INSERT INTO `lz_countries` VALUES (24, '巴哈马', 'BHS');
INSERT INTO `lz_countries` VALUES (25, '巴基斯坦', 'PAK');
INSERT INTO `lz_countries` VALUES (26, '巴拉圭', 'PRY');
INSERT INTO `lz_countries` VALUES (27, '巴勒斯坦', 'PSE');
INSERT INTO `lz_countries` VALUES (28, '巴林', 'BHR');
INSERT INTO `lz_countries` VALUES (29, '巴拿马', 'PAN');
INSERT INTO `lz_countries` VALUES (30, '巴西', 'BRA');
INSERT INTO `lz_countries` VALUES (31, '白俄罗斯', 'BLR');
INSERT INTO `lz_countries` VALUES (32, '百慕大', 'BMU');
INSERT INTO `lz_countries` VALUES (33, '保加利亚', 'BGR');
INSERT INTO `lz_countries` VALUES (34, '北马里亚纳群岛', 'MNP');
INSERT INTO `lz_countries` VALUES (35, '贝宁', 'BEN');
INSERT INTO `lz_countries` VALUES (36, '比利时', 'BEL');
INSERT INTO `lz_countries` VALUES (37, '冰岛', 'ISL');
INSERT INTO `lz_countries` VALUES (38, '波多黎各', 'PRI');
INSERT INTO `lz_countries` VALUES (39, '波兰', 'POL');
INSERT INTO `lz_countries` VALUES (40, '波斯尼亚和黑塞哥维那', 'BIH');
INSERT INTO `lz_countries` VALUES (41, '玻利维亚', 'BOL');
INSERT INTO `lz_countries` VALUES (42, '伯利兹', 'BLZ');
INSERT INTO `lz_countries` VALUES (43, '博茨瓦纳', 'BWA');
INSERT INTO `lz_countries` VALUES (44, '不丹', 'BTN');
INSERT INTO `lz_countries` VALUES (45, '布基纳法索', 'BFA');
INSERT INTO `lz_countries` VALUES (46, '布隆迪', 'BDI');
INSERT INTO `lz_countries` VALUES (47, '布韦岛', 'BVT');
INSERT INTO `lz_countries` VALUES (48, '朝鲜', 'PRK');
INSERT INTO `lz_countries` VALUES (49, '丹麦', 'DNK');
INSERT INTO `lz_countries` VALUES (50, '德国', 'DEU');
INSERT INTO `lz_countries` VALUES (51, '东帝汶', 'TLS');
INSERT INTO `lz_countries` VALUES (52, '多哥', 'TGO');
INSERT INTO `lz_countries` VALUES (53, '多米尼加', 'DMA');
INSERT INTO `lz_countries` VALUES (54, '多米尼加共和国', 'DOM');
INSERT INTO `lz_countries` VALUES (55, '俄罗斯', 'RUS');
INSERT INTO `lz_countries` VALUES (56, '厄瓜多尔', 'ECU');
INSERT INTO `lz_countries` VALUES (57, '厄立特里亚', 'ERI');
INSERT INTO `lz_countries` VALUES (58, '法国', 'FRA');
INSERT INTO `lz_countries` VALUES (59, '法罗群岛', 'FRO');
INSERT INTO `lz_countries` VALUES (60, '法属波利尼西亚', 'PYF');
INSERT INTO `lz_countries` VALUES (61, '法属圭亚那', 'GUF');
INSERT INTO `lz_countries` VALUES (62, '法属南部领地', 'ATF');
INSERT INTO `lz_countries` VALUES (63, '梵蒂冈', 'VAT');
INSERT INTO `lz_countries` VALUES (64, '菲律宾', 'PHL');
INSERT INTO `lz_countries` VALUES (65, '斐济', 'FJI');
INSERT INTO `lz_countries` VALUES (66, '芬兰', 'FIN');
INSERT INTO `lz_countries` VALUES (67, '佛得角', 'CPV');
INSERT INTO `lz_countries` VALUES (68, '弗兰克群岛', 'FLK');
INSERT INTO `lz_countries` VALUES (69, '冈比亚', 'GMB');
INSERT INTO `lz_countries` VALUES (70, '刚果', 'COG');
INSERT INTO `lz_countries` VALUES (71, '刚果民主共和国', 'COD');
INSERT INTO `lz_countries` VALUES (72, '哥伦比亚', 'COL');
INSERT INTO `lz_countries` VALUES (73, '哥斯达黎加', 'CRI');
INSERT INTO `lz_countries` VALUES (74, '格恩西岛', 'GGY');
INSERT INTO `lz_countries` VALUES (75, '格林纳达', 'GRD');
INSERT INTO `lz_countries` VALUES (76, '格陵兰', 'GRL');
INSERT INTO `lz_countries` VALUES (77, '古巴', 'CUB');
INSERT INTO `lz_countries` VALUES (78, '瓜德罗普', 'GLP');
INSERT INTO `lz_countries` VALUES (79, '关岛', 'GUM');
INSERT INTO `lz_countries` VALUES (80, '圭亚那', 'GUY');
INSERT INTO `lz_countries` VALUES (81, '哈萨克斯坦', 'KAZ');
INSERT INTO `lz_countries` VALUES (82, '海地', 'HTI');
INSERT INTO `lz_countries` VALUES (83, '韩国', 'KOR');
INSERT INTO `lz_countries` VALUES (84, '荷兰', 'NLD');
INSERT INTO `lz_countries` VALUES (85, '荷属安地列斯', 'ANT');
INSERT INTO `lz_countries` VALUES (86, '赫德和麦克唐纳群岛', 'HMD');
INSERT INTO `lz_countries` VALUES (87, '洪都拉斯', 'HND');
INSERT INTO `lz_countries` VALUES (88, '基里巴斯', 'KIR');
INSERT INTO `lz_countries` VALUES (89, '吉布提', 'DJI');
INSERT INTO `lz_countries` VALUES (90, '吉尔吉斯斯坦', 'KGZ');
INSERT INTO `lz_countries` VALUES (91, '几内亚', 'GIN');
INSERT INTO `lz_countries` VALUES (92, '几内亚比绍', 'GNB');
INSERT INTO `lz_countries` VALUES (93, '加拿大', 'CAN');
INSERT INTO `lz_countries` VALUES (94, '加纳', 'GHA');
INSERT INTO `lz_countries` VALUES (95, '加蓬', 'GAB');
INSERT INTO `lz_countries` VALUES (96, '柬埔寨', 'KHM');
INSERT INTO `lz_countries` VALUES (97, '捷克共和国', 'CZE');
INSERT INTO `lz_countries` VALUES (98, '津巴布韦', 'ZWE');
INSERT INTO `lz_countries` VALUES (99, '喀麦隆', 'CMR');
INSERT INTO `lz_countries` VALUES (100, '卡塔尔', 'QAT');
INSERT INTO `lz_countries` VALUES (101, '开曼群岛', 'CYM');
INSERT INTO `lz_countries` VALUES (102, '科科斯群岛', 'CCK');
INSERT INTO `lz_countries` VALUES (103, '科摩罗', 'COM');
INSERT INTO `lz_countries` VALUES (104, '科特迪瓦', 'CIV');
INSERT INTO `lz_countries` VALUES (105, '科威特', 'KWT');
INSERT INTO `lz_countries` VALUES (106, '克罗地亚', 'HRV');
INSERT INTO `lz_countries` VALUES (107, '肯尼亚', 'KEN');
INSERT INTO `lz_countries` VALUES (108, '库克群岛', 'COK');
INSERT INTO `lz_countries` VALUES (109, '拉脱维亚', 'LVA');
INSERT INTO `lz_countries` VALUES (110, '莱索托', 'LSO');
INSERT INTO `lz_countries` VALUES (111, '老挝', 'LAO');
INSERT INTO `lz_countries` VALUES (112, '黎巴嫩', 'LBN');
INSERT INTO `lz_countries` VALUES (113, '立陶宛', 'LTU');
INSERT INTO `lz_countries` VALUES (114, '利比里亚', 'LBR');
INSERT INTO `lz_countries` VALUES (115, '利比亚', 'LBY');
INSERT INTO `lz_countries` VALUES (116, '列支敦士登', 'LIE');
INSERT INTO `lz_countries` VALUES (117, '留尼旺岛', 'REU');
INSERT INTO `lz_countries` VALUES (118, '卢森堡', 'LUX');
INSERT INTO `lz_countries` VALUES (119, '卢旺达', 'RWA');
INSERT INTO `lz_countries` VALUES (120, '罗马尼亚', 'ROU');
INSERT INTO `lz_countries` VALUES (121, '马达加斯加', 'MDG');
INSERT INTO `lz_countries` VALUES (122, '马尔代夫', 'MDV');
INSERT INTO `lz_countries` VALUES (123, '马耳他', 'MLT');
INSERT INTO `lz_countries` VALUES (124, '马拉维', 'MWI');
INSERT INTO `lz_countries` VALUES (125, '马来西亚', 'MYS');
INSERT INTO `lz_countries` VALUES (126, '马里', 'MLI');
INSERT INTO `lz_countries` VALUES (127, '马其顿', 'MKD');
INSERT INTO `lz_countries` VALUES (128, '马绍尔群岛', 'MHL');
INSERT INTO `lz_countries` VALUES (129, '马提尼克', 'MTQ');
INSERT INTO `lz_countries` VALUES (130, '马约特岛', 'MYT');
INSERT INTO `lz_countries` VALUES (131, '曼岛', 'IMN');
INSERT INTO `lz_countries` VALUES (132, '毛里求斯', 'MUS');
INSERT INTO `lz_countries` VALUES (133, '毛里塔尼亚', 'MRT');
INSERT INTO `lz_countries` VALUES (134, '美国', 'USA');
INSERT INTO `lz_countries` VALUES (135, '美属萨摩亚', 'ASM');
INSERT INTO `lz_countries` VALUES (136, '美属外岛', 'UMI');
INSERT INTO `lz_countries` VALUES (137, '蒙古', 'MNG');
INSERT INTO `lz_countries` VALUES (138, '蒙特塞拉特', 'MSR');
INSERT INTO `lz_countries` VALUES (139, '孟加拉', 'BGD');
INSERT INTO `lz_countries` VALUES (140, '秘鲁', 'PER');
INSERT INTO `lz_countries` VALUES (141, '密克罗尼西亚', 'FSM');
INSERT INTO `lz_countries` VALUES (142, '缅甸', 'MMR');
INSERT INTO `lz_countries` VALUES (143, '摩尔多瓦', 'MDA');
INSERT INTO `lz_countries` VALUES (144, '摩洛哥', 'MAR');
INSERT INTO `lz_countries` VALUES (145, '摩纳哥', 'MCO');
INSERT INTO `lz_countries` VALUES (146, '莫桑比克', 'MOZ');
INSERT INTO `lz_countries` VALUES (147, '墨西哥', 'MEX');
INSERT INTO `lz_countries` VALUES (148, '纳米比亚', 'NAM');
INSERT INTO `lz_countries` VALUES (149, '南非', 'ZAF');
INSERT INTO `lz_countries` VALUES (150, '南极洲', 'ATA');
INSERT INTO `lz_countries` VALUES (151, '南乔治亚和南桑德威奇群岛', 'SGS');
INSERT INTO `lz_countries` VALUES (152, '瑙鲁', 'NRU');
INSERT INTO `lz_countries` VALUES (153, '尼泊尔', 'NPL');
INSERT INTO `lz_countries` VALUES (154, '尼加拉瓜', 'NIC');
INSERT INTO `lz_countries` VALUES (155, '尼日尔', 'NER');
INSERT INTO `lz_countries` VALUES (156, '尼日利亚', 'NGA');
INSERT INTO `lz_countries` VALUES (157, '纽埃', 'NIU');
INSERT INTO `lz_countries` VALUES (158, '挪威', 'idR');
INSERT INTO `lz_countries` VALUES (159, '诺福克', 'NFK');
INSERT INTO `lz_countries` VALUES (160, '帕劳群岛', 'PLW');
INSERT INTO `lz_countries` VALUES (161, '皮特凯恩', 'PCN');
INSERT INTO `lz_countries` VALUES (162, '葡萄牙', 'PRT');
INSERT INTO `lz_countries` VALUES (163, '乔治亚', 'GEO');
INSERT INTO `lz_countries` VALUES (164, '日本', 'JPN');
INSERT INTO `lz_countries` VALUES (165, '瑞典', 'SWE');
INSERT INTO `lz_countries` VALUES (166, '瑞士', 'CHE');
INSERT INTO `lz_countries` VALUES (167, '萨尔瓦多', 'SLV');
INSERT INTO `lz_countries` VALUES (168, '萨摩亚', 'WSM');
INSERT INTO `lz_countries` VALUES (169, '塞尔维亚,黑山', 'SCG');
INSERT INTO `lz_countries` VALUES (170, '塞拉利昂', 'SLE');
INSERT INTO `lz_countries` VALUES (171, '塞内加尔', 'SEN');
INSERT INTO `lz_countries` VALUES (172, '塞浦路斯', 'CYP');
INSERT INTO `lz_countries` VALUES (173, '塞舌尔', 'SYC');
INSERT INTO `lz_countries` VALUES (174, '沙特阿拉伯', 'SAU');
INSERT INTO `lz_countries` VALUES (175, '圣诞岛', 'CXR');
INSERT INTO `lz_countries` VALUES (176, '圣多美和普林西比', 'STP');
INSERT INTO `lz_countries` VALUES (177, '圣赫勒拿', 'SHN');
INSERT INTO `lz_countries` VALUES (178, '圣基茨和尼维斯', 'KNA');
INSERT INTO `lz_countries` VALUES (179, '圣卢西亚', 'LCA');
INSERT INTO `lz_countries` VALUES (180, '圣马力诺', 'SMR');
INSERT INTO `lz_countries` VALUES (181, '圣皮埃尔和米克隆群岛', 'SPM');
INSERT INTO `lz_countries` VALUES (182, '圣文森特和格林纳丁斯', 'VCT');
INSERT INTO `lz_countries` VALUES (183, '斯里兰卡', 'LKA');
INSERT INTO `lz_countries` VALUES (184, '斯洛伐克', 'SVK');
INSERT INTO `lz_countries` VALUES (185, '斯洛文尼亚', 'SVN');
INSERT INTO `lz_countries` VALUES (186, '斯瓦尔巴和扬马廷', 'SJM');
INSERT INTO `lz_countries` VALUES (187, '斯威士兰', 'SWZ');
INSERT INTO `lz_countries` VALUES (188, '苏丹', 'SDN');
INSERT INTO `lz_countries` VALUES (189, '苏里南', 'SUR');
INSERT INTO `lz_countries` VALUES (190, '所罗门群岛', 'SLB');
INSERT INTO `lz_countries` VALUES (191, '索马里', 'SOM');
INSERT INTO `lz_countries` VALUES (192, '塔吉克斯坦', 'TJK');
INSERT INTO `lz_countries` VALUES (193, '泰国', 'THA');
INSERT INTO `lz_countries` VALUES (194, '坦桑尼亚', 'TZA');
INSERT INTO `lz_countries` VALUES (195, '汤加', 'TON');
INSERT INTO `lz_countries` VALUES (196, '特克斯和凯克特斯群岛', 'TCA');
INSERT INTO `lz_countries` VALUES (197, '特里斯坦达昆哈', 'TAA');
INSERT INTO `lz_countries` VALUES (198, '特立尼达和多巴哥', 'TTO');
INSERT INTO `lz_countries` VALUES (199, '突尼斯', 'TUN');
INSERT INTO `lz_countries` VALUES (200, '图瓦卢', 'TUV');
INSERT INTO `lz_countries` VALUES (201, '土耳其', 'TUR');
INSERT INTO `lz_countries` VALUES (202, '土库曼斯坦', 'TKM');
INSERT INTO `lz_countries` VALUES (203, '托克劳', 'TKL');
INSERT INTO `lz_countries` VALUES (204, '瓦利斯和福图纳', 'WLF');
INSERT INTO `lz_countries` VALUES (205, '瓦努阿图', 'VUT');
INSERT INTO `lz_countries` VALUES (206, '危地马拉', 'GTM');
INSERT INTO `lz_countries` VALUES (207, '维尔京群岛，美属', 'VIR');
INSERT INTO `lz_countries` VALUES (208, '维尔京群岛，英属', 'VGB');
INSERT INTO `lz_countries` VALUES (209, '委内瑞拉', 'VEN');
INSERT INTO `lz_countries` VALUES (210, '文莱', 'BRN');
INSERT INTO `lz_countries` VALUES (211, '乌干达', 'UGA');
INSERT INTO `lz_countries` VALUES (212, '乌克兰', 'UKR');
INSERT INTO `lz_countries` VALUES (213, '乌拉圭', 'URY');
INSERT INTO `lz_countries` VALUES (214, '乌兹别克斯坦', 'UZB');
INSERT INTO `lz_countries` VALUES (215, '西班牙', 'ESP');
INSERT INTO `lz_countries` VALUES (216, '希腊', 'GRC');
INSERT INTO `lz_countries` VALUES (217, '新加坡', 'SGP');
INSERT INTO `lz_countries` VALUES (218, '新喀里多尼亚', 'NCL');
INSERT INTO `lz_countries` VALUES (219, '新西兰', 'NZL');
INSERT INTO `lz_countries` VALUES (220, '匈牙利', 'HUN');
INSERT INTO `lz_countries` VALUES (221, '叙利亚', 'SYR');
INSERT INTO `lz_countries` VALUES (222, '牙买加', 'JAM');
INSERT INTO `lz_countries` VALUES (223, '亚美尼亚', 'ARM');
INSERT INTO `lz_countries` VALUES (224, '也门', 'YEM');
INSERT INTO `lz_countries` VALUES (225, '伊拉克', 'IRQ');
INSERT INTO `lz_countries` VALUES (226, '伊朗', 'IRN');
INSERT INTO `lz_countries` VALUES (227, '以色列', 'ISR');
INSERT INTO `lz_countries` VALUES (228, '意大利', 'ITA');
INSERT INTO `lz_countries` VALUES (229, '印度', 'IND');
INSERT INTO `lz_countries` VALUES (230, '印度尼西亚', 'IDN');
INSERT INTO `lz_countries` VALUES (231, '英国', 'GBR');
INSERT INTO `lz_countries` VALUES (232, '英属印度洋领地', 'IOT');
INSERT INTO `lz_countries` VALUES (233, '约旦', 'JOR');
INSERT INTO `lz_countries` VALUES (234, '越南', 'VNM');
INSERT INTO `lz_countries` VALUES (235, '赞比亚', 'ZMB');
INSERT INTO `lz_countries` VALUES (236, '泽西岛', 'JEY');
INSERT INTO `lz_countries` VALUES (237, '乍得', 'TCD');
INSERT INTO `lz_countries` VALUES (238, '直布罗陀', 'GIB');
INSERT INTO `lz_countries` VALUES (239, '智利', 'CHL');
INSERT INTO `lz_countries` VALUES (240, '中非共和国', 'CAF');