最新最完整的中英法文ISO3166世界行政区划MySQL级联表

-- phpMyAdmin SQL Dump -- version 4.7.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: 2018-01-29 13:13:52 -- 服务器版本： 5.7.18-log -- PHP Version: 5.6.30 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `mashupapi` -- -- -------------------------------------------------------- -- -- 表的结构 `API_location_city` -- CREATE TABLE `API_location_city` ( `id` int(11) NOT NULL, `name_en` varchar(50) DEFAULT NULL COMMENT '英文名', `name_zh-Hans` varchar(255) DEFAULT NULL COMMENT '简体中文名', `code` varchar(50) DEFAULT NULL COMMENT '代号', `stateId` int(11) DEFAULT NULL COMMENT '所属二级行政区', `countryId` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='三级行政区'; -- -- 转存表中的数据 `API_location_city` -- INSERT INTO `API_location_city` (`id`, `name_en`, `name_zh-Hans`, `code`, `stateId`, `countryId`) VALUES (1, 'Canberra', '堪培拉', 'CBR', 148, 15), (2, 'Newcastle', '纽卡斯尔', 'NTL', 149, 15), (3, 'Sydney', '悉尼', 'HBS', 149, 15), (4, 'Wollongong', '伍伦贡', 'WOL', 149, 15), (5, 'Darwin', '达尔文', 'DRW', 150, 15), (6, 'Palmerston', '北帕默斯顿', 'PAL', 150, 15), (7, 'Brisbane', '布里斯班', 'BNE', 151, 15), (8, 'Cairns', '凯恩斯', 'CNS', 151, 15), (9, 'Caloundra', '日光海岸', 'CUD', 151, 15), (10, 'Gold Coast', '黄金海岸', 'OOL', 151, 15), (11, 'Toowoomba', '图文巴', 'TWB', 151, 15), (12, 'Townsville', '汤斯维尔', 'TSV', 151, 15), (13, 'Adelaide', '阿德莱德', 'ADL', 152, 15), (14, 'Mount Gambier', '甘比亚山', 'MGB', 152, 15), (15, 'Murray Bridge', '默里布里奇', 'MYB', 152, 15), (16, 'Port Augusta', '奥古斯塔港', 'PUG', 152, 15), (17, 'Port Lincoln', '林肯港', 'PLO', 152, 15), (18, 'Port Pirie', '皮里港', 'PPI', 152, 15), (19, 'Victor Harbor', '维克托港', 'VHA', 152, 15), (20, 'Whyalla', '怀阿拉', 'WAY', 152, 15), (21, 'Burnie', '伯尼港', 'BWT', 153, 15), (22, 'Devonport', '德文波特', 'DPO', 153, 15), (23, 'Hobart', '霍巴特', 'HBA', 153, 15), (24, 'Launceston', '朗塞斯顿', 'LST', 153, 15), (25, 'Geelong', '吉朗', 'GEX', 154, 15), (26, 'Melbourne', '墨尔本', 'MEL', 154, 15), (27, 'Albany', '奥尔巴尼', 'ALH', 155, 15), (28, 'Bunbury', '班伯里', 'BUY', 155, 15), (29, 'Fremantle', '弗里曼特尔港', 'FRE', 155, 15), (30, 'Geraldton', '杰拉尔顿', 'GET', 155, 15), (31, 'Kalgoorlie', '卡尔古利', 'KGI', 155, 15), (32, 'Mandurah', '曼哲拉', 'MDU', 155, 15), (33, 'Perth', '珀斯', 'PER', 155, 15), (34, 'Anqing', '安庆', '8', 461, 45), (35, 'Bengbu', '蚌埠', '3', 461, 45), (36, 'Bozhou', '亳州', '16', 461, 45), (37, 'Chizhou', '池州', '17', 461, 45), (38, 'Chuzhou', '滁州', '11', 461, 45), (39, 'Fuyang', '阜阳', '12', 461, 45), (40, 'Hefei', '合肥', '1', 461, 45), (41, 'Huaibei', '淮北', '6', 461, 45), (42, 'Huainan', '淮南', '4', 461, 45), (43, 'Huangshan', '黄山', '10', 461, 45), (44, 'Lu\'an', '六安', '15', 461, 45), (45, 'Ma\'anshan', '马鞍山', '5', 461, 45), (46, 'Suzhou', '宿州', '13', 461, 45), (47, 'Tongling', '铜陵', '7', 461, 45), (48, 'Wuhu', '芜湖', '2', 461, 45), (49, 'Xuancheng', '宣城', '18', 461, 45), (50, 'Changping', '昌平', '21', 462, 45), (51, 'Chaoyang', '朝阳', '5', 462, 45), (52, 'Chongwen', '崇文', '3', 462, 45), (53, 'Daxing', '大兴', '24', 462, 45), (54, 'Dongcheng', '东城', '1', 462, 45), (55, 'Fangshan', '房山', '11', 462, 45), (56, 'Fengtai', '丰台', '6', 462, 45), (57, 'Haidian', '海淀', '8', 462, 45), (58, 'Huairou', '怀柔', '27', 462, 45), (59, 'Mentougou', '门头沟', '9', 462, 45), (60, 'Miyun', '密云', '28', 462, 45), (61, 'Pinggu', '平谷', '26', 462, 45), (62, 'Shijingshan', '石景山', '7', 462, 45), (63, 'Shunyi', '顺义', '13', 462, 45), (64, 'Tongzhou', '通州', '12', 462, 45), (65, 'Xicheng', '西城', '2', 462, 45), (66, 'Yanqing', '延庆', '29', 462, 45), (67, 'Ba\'nan', '巴南', '13', 463, 45), (68, 'Beibei', '北碚', '9', 463, 45), (69, 'Bishan', '璧山', '27', 463, 45), (70, 'Changshou', '长寿', '21', 463, 45), (71, 'Chengkou', '城口', '29', 463, 45), (72, 'Dadukou', '大渡口', '4', 463, 45), (73, 'Dazu', '大足', '25', 463, 45), (74, 'Dianjiang', '垫江', '31', 463, 45), (75, 'Fengdu', '丰都', '30', 463, 45), (76, 'Fengjie', '奉节', '36', 463, 45), (77, 'Fuling', '涪陵', '2', 463, 45), (78, 'Hechuan', '合川', '82', 463, 45), (79, 'Jiangbei', '江北', '5', 463, 45), (80, 'Jiangjin', '江津', '81', 463, 45), (81, 'Jiulongpo', '九龙坡', '7', 463, 45), (82, 'Kaixian', '开县', '34', 463, 45), (83, 'Kaixian', '两江新区', '85', 463, 45), (84, 'Liangping', '梁平', '28', 463, 45), (85, 'Nan\'an', '南岸', '8', 463, 45), (86, 'Liangjiangxinqu', '南川', '84', 463, 45), (87, 'Pengshui Miao-Tujia Autonomous Country', '彭水', '43', 463, 45), (88, 'Qianjiang', '黔江', '39', 463, 45), (89, 'Qijiang', '綦江', '22', 463, 45), (90, 'Rongchang', '荣昌', '26', 463, 45), (91, 'Shapingba', '沙坪坝', '6', 463, 45), (92, 'Shizhu Tujia Autonomous Country', '石柱', '40', 463, 45), (93, 'Shuangqiao', '双桥', '11', 463, 45), (94, 'Tongliang', '铜梁', '24', 463, 45), (95, 'Tongnan', '潼南', '23', 463, 45), (96, 'Wansheng', '万盛', '10', 463, 45), (97, 'Wanzhou', '万州', '1', 463, 45), (98, 'Wulong', '武隆', '32', 463, 45), (99, 'Wushan', '巫山', '37', 463, 45), (100, 'Wuxi', '巫溪', '38', 463, 45), (101, 'Xiushan Tujia-Miao Autonomous Country', '秀山', '41', 463, 45), (102, 'Yongchuan', '永川', '83', 463, 45), (103, 'Youyang Tujia-Miao Autonomous Country', '酉阳', '42', 463, 45), (104, 'Yubei', '渝北', '12', 463, 45), (105, 'Yunyang', '云阳', '35', 463, 45), (106, 'Yuzhong', '渝中', '3', 463, 45), (107, 'Zhongxian', '忠县', '33', 463, 45), (108, 'Fuzhou', '福州', '1', 464, 45), (109, 'Longyan', '龙岩', '8', 464, 45), (110, 'Nanping', '南平', '7', 464, 45), (111, 'Ningde', '宁德', '9', 464, 45), (112, 'Putian', '莆田', '3', 464, 45), (113, 'Quanzhou', '泉州', '5', 464, 45), (114, 'Sanming', '三明', '4', 464, 45), (115, 'Xiamen', '厦门', '2', 464, 45), (116, 'Zhangzhou', '漳州', '6', 464, 45), (117, 'Baiyin', '金昌', '3', 465, 45), (118, 'Dingxi', '定西', '11', 465, 45), (119, 'Gannan Tibetan Autonomous Prefecture', '甘南', '30', 465, 45), (120, 'Jiayuguan', '天水', '5', 465, 45), (121, 'Jinchang', '嘉峪关', '2', 465, 45), (122, 'Jiuquan', '酒泉', '9', 465, 45), (123, 'Lanzhou', '兰州市', '1', 465, 45), (124, 'Linxia Hui Autonomous Prefecture', '临夏', '29', 465, 45), (125, 'Longnan', '陇南', '12', 465, 45), (126, 'Pingliang', '平凉', '8', 465, 45), (127, 'Qingyang', '庆阳', '10', 465, 45), (128, 'Tianshui', '白银', '4', 465, 45), (129, 'Wuwei', '武威', '6', 465, 45), (130, 'Zhangye', '张掖', '7', 465, 45), (131, 'Chaozhou', '潮州', '51', 466, 45), (132, 'Dongguan', '东莞', '19', 466, 45), (133, 'Foshan', '佛山', '6', 466, 45), (134, 'Guangzhou', '广州', '1', 466, 45), (135, 'Heyuan', '河源', '16', 466, 45), (136, 'Huizhou', '惠州', '13', 466, 45), (137, 'Jiangmen', '江门', '7', 466, 45), (138, 'Jieyang', '揭阳', '52', 466, 45), (139, 'Maoming', '茂名', '9', 466, 45), (140, 'Meizhou', '梅州', '14', 466, 45), (141, 'Qingyuan', '清远', '18', 466, 45), (142, 'Shantou', '汕头', '5', 466, 45), (143, 'Shanwei', '汕尾', '15', 466, 45), (144, 'Shaoguan', '韶关', '2', 466, 45), (145, 'Shenzhen', '深圳', '3', 466, 45), (146, 'Yangjiang', '阳江', '17', 466, 45), (147, 'Yunfu', '云浮', '53', 466, 45), (148, 'Zhanjiang', '湛江', '8', 466, 45), (149, 'Zhaoqing', '肇庆', '12', 466, 45), (150, 'Zhongshan', '中山', '20', 466, 45),