全国省市数据

创建表

create table Zone (
   ZoneId               int                  not null,
   Nm                   varchar(128)         null,
   ParentId             int                  null,
   constraint PK_ZONE primary key (ZoneId)
)

 

sqlserver数据库的插入

INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES 
    (1, '北京', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (2, '上海', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (3, '天津', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (4, '重庆', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (5, '广东', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (6, '广西', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (7, '湖北', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (8, '湖南', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (9, '山东', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (10, '山西', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (11, '河北', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (12, '河南', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (13, '四川', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (14, '浙江', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (15, '江苏', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (16, '福建', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (17, '江西', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (18, '安徽', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (19, '海南', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (20, '云南', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (21, '青海', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (22, '陕西', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (23, '甘肃', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (24, '贵州', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (25, '宁夏', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (26, '黑龙江', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (27, '吉林', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (28, '辽宁', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (29, '西藏', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (30, '***', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (31, '内蒙古', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (32, '香港', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (33, '澳门', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (34, '台湾', 0);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES

    (100, '北京', 1);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(101, '上海', 2);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(102, '天津', 3);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(103, '重庆', 4);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (104, '广州', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(105, '深圳', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(106, '珠海', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(107, '汕头', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(108, '韶关', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(109, '佛山', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(110, '江门', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(111, '湛江', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(112, '茂名', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(113, '肇庆', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(114, '惠州', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(115, '梅州', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(116, '汕尾', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(117, '河源', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(118, '阳江', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(119, '清远', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(120, '东莞', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(121, '中山', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(122, '潮州', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(123, '揭阳', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(124, '云浮', 5);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (125, '南宁', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(126, '柳州', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(127, '桂林', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(128, '梧州', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(129, '北海', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(130, '防城港', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(131, '钦州', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(132, '贵港', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(133, '玉林', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(134, '百色', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(135, '贺州', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(136, '河池', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(137, '来宾', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(138, '崇左', 6);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (139, '武汉', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(140, '黄石', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(141, '襄樊', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(142, '十堰', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(143, '荆州', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(144, '宜昌', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(145, '荆门', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(146, '鄂州', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(147, '孝感', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(148, '黄冈', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(149, '咸宁', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(150, '随州', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(151, '仙桃', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(152, '天门', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(153, '潜江', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(154, '神农架', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(155, '恩施土家族苗族自治州', 7);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (156, '长沙', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(157, '株洲', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(158, '湘潭', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(159, '衡阳', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(160, '邵阳', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(161, '岳阳', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(162, '常德', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(163, '张家界', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(164, '益阳', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(165, '郴州', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(166, '怀化', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(167, '娄底', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(168, '湘西土家族苗族自治州', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(169, '永州', 8);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (170, '济南', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(171, '青岛', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(172, '淄博', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(173, '枣庄', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(174, '东营', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(175, '潍坊', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(176, '烟台', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(177, '威海', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(178, '济宁', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(179, '泰安', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(180, '日照', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(181, '莱芜', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(182, '德州', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(183, '临沂', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(184, '聊城', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(185, '滨州', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(186, '菏泽', 9);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (187, '太原', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(188, '大同', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(189, '阳泉', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(190, '长治', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(191, '晋城', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(192, '朔州', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(193, '普中', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(194, '运城', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(195, '忻州', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(196, '临汾', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(197, '吕梁', 10);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (198, '石家庄', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(199, '唐山', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(200, '秦皇岛', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(201, '邯郸', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(202, '邢台', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(203, '保定', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(204, '张家口', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(205, '承德', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(206, '沧州', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(207, '廊坊', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(208, '衡水', 11);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (209, '郑州', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(210, '开封', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(211, '洛阳', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(212, '平顶山', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(213, '焦作', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(214, '鹤壁', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(215, '新乡', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(216, '安阳', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(217, '濮阳', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(218, '许昌', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(219, '漯河', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(220, '三门峡', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(221, '南阳', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(222, '商丘', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(223, '信阳', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(224, '周口', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(225, '驻马店', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(226, '济源', 12);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (227, '成都', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(228, '自贡', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(229, '攀枝花', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(230, '泸州', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(231, '德阳', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(232, '绵阳', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(233, '广元', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(234, '遂宁', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(235, '内江', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(236, '乐山', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(237, '南充', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(238, '宜宾', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(239, '广安', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(240, '达州', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(241, '眉山', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(242, '雅安', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(243, '巴中', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(244, '资阳', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(245, '阿坝藏族羌族自治州', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(246, '甘孜藏族自治州', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(247, '凉山彝族自治州', 13);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (248, '杭州', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(249, '宁波', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(250, '温州', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(251, '嘉兴', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(252, '湖州', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(253, '绍兴', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(254, '金华', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(255, '衢州', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(256, '舟山', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(257, '台州', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(258, '丽水', 14);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (259, '南京', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(260, '无锡', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(261, '徐州', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(262, '常州', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(263, '苏州', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(264, '南通', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(265, '连云港', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(266, '淮安', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(267, '盐城', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(268, '扬州', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(269, '镇江', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(270, '泰州', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(271, '宿迁', 15);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (272, '福州', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(273, '厦门', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(274, '莆田', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(275, '三明', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(276, '泉州', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(277, '漳州', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(278, '南平', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(279, '龙岩', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(280, '宁德', 16);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (281, '南昌', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(282, '景德镇', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(283, '萍乡', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(284, '新余', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(285, '九江', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(286, '鹰潭', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(287, '赣州', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(288, '吉安', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(289, '宜春', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(290, '抚州', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(291, '上饶', 17);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (292, '合肥', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(293, '芜湖', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(294, '蚌埠', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(295, '淮南', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(296, '马鞍山', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(297, '淮北', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(298, '铜陵', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(299, '安庆', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(300, '黄山', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(301, '滁州', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(302, '阜阳', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(303, '宿州', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(304, '巢湖', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(305, '六安', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(306, '毫州', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(307, '池州', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(308, '宣城', 18);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (309, '海口', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(310, '三亚', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(311, '五指山', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(312, '琼海', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(313, '儋州', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(314, '文昌', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(315, '万宁', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(316, '东方', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(317, '澄迈', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(318, '定安', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(319, '屯昌', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(320, '临高', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(321, '白沙黎族自治县', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(322, '昌江黎族自治县', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(323, '乐东黎族自治县', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(324, '陵水黎族自治县', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(325, '保亭黎族苗族自治县', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(326, '琼中黎族苗族自治县', 19);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (327, '昆明', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(328, '曲靖', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(329, '玉溪', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(330, '保山', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(331, '昭通', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(332, '丽江', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(333, '思茅', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(334, '临沧', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(335, '文山壮族苗族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(336, '红河哈尼族彝族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(337, '西双版纳傣族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(338, '楚雄彝族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(339, '大理白族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(340, '德宏傣族景颇族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(341, '怒江傈僳族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(342, '迪庆藏族自治州', 20);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (343, '西宁', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(344, '海东', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(345, '海北藏族自治区', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(346, '黄南藏族自治区', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(347, '海南藏族自治区', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(348, '果洛藏族自治区', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(349, '玉树藏族自治区', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(350, '海西蒙古族藏族自治区', 21);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (351, '西安', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(352, '铜川', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(353, '宝鸡', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(354, '咸阳', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(355, '渭南', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(356, '延安', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(357, '汉中', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(358, '榆林', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(359, '安康', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(360, '商洛', 22);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (361, '兰州', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(362, '金昌', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(363, '白银', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(364, '天水', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(365, '嘉峪关', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(366, '武威', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(367, '张掖', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(368, '平凉', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(369, '酒泉', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(370, '庆阳', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(371, '定西', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(372, '陇南', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(373, '临夏回族自治州', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(374, '甘南藏族自治州', 23);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (375, '贵阳', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(376, '六盘水', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(377, '遵义', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(378, '安顺', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(379, '铜仁', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(380, '毕节', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(381, '黔西南而布依族苗族自治州', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(382, '黔东南而苗族侗族自治州', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(383, '黔南而布依族苗族自治州', 24);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (384, '银川', 25);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(385, '石嘴山', 25);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(386, '吴忠', 25);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(387, '固原', 25);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (388, '哈尔滨', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(389, '齐齐哈尔', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(390, '鹤岗', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(391, '双鸭山', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(392, '鸡西', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(393, '大庆', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(394, '伊春', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(395, '牡丹江', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(396, '佳木斯', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(397, '七台河', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(398, '黑河', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(399, '绥化', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(400, '大兴安岭', 26);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (401, '长春', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(402, '吉林市', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(403, '四平', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(404, '辽源', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(405, '通化', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(406, '白山', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(407, '松原', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(408, '白城', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(409, '延边朝鲜族自治州', 27);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (410, '沈阳', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(411, '大连', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(412, '鞍山', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(413, '抚顺', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(414, '本溪', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(415, '丹东', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(416, '锦州', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(417, '葫芦岛', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(418, '营口', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(419, '盘锦', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(420, '阜新', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(421, '辽阳', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(422, '铁岭', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(423, '朝阳', 28);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (424, '拉萨', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(425, '那曲', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(426, '昌都', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(427, '山南', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(428, '日喀则', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(429, '阿里', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(430, '林芝', 29);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (431, '乌鲁木齐', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(432, '克拉玛依', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(433, '石河子', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(434, '阿拉尔', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(435, '图木舒克', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(436, '五家渠', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(437, '吐鲁番', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(438, '哈密', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(439, '和田', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(440, '阿克苏', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(441, '喀什', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(442, '克孜勒苏柯尔克孜自治州', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(443, '巴音郭楞蒙古自治州', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(444, '昌吉回族自治州', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(445, '博尔塔拉蒙古自治州', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(446, '伊犁哈萨克自治州', 30);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (447, '呼和浩特', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(448, '包头', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(449, '乌海', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(450, '赤峰', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(451, '通辽', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(452, '鄂尔多斯', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(453, '呼伦贝尔', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(454, '乌兰察布盟', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(455, '锡林郭勒盟', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(456, '巴彦淖尔盟', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(457, '阿拉善盟', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(458, '兴安盟', 31);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (459, '香港', 32);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (460, '澳门', 33);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES
    (461, '台北', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(462, '高雄', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(463, '基隆', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(464, '台中', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(465, '台南', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(466, '新竹', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(467, '嘉义', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(468, '台北县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(469, '宜兰县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(470, '新竹县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(471, '桃园县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(472, '苗栗县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(473, '台中县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(474, '彰化县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(475, '南投县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(476, '嘉义县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(477, '云林县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(478, '台南县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(479, '高雄县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(480, '屏东县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(481, '台东县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(482, '花莲县', 34);INSERT INTO Zone (ZoneId, Nm, ParentId) VALUES(483, '澎湖县', 34);

 

oracle数据库的插入

INSERT INTO Zone ('ZoneId', 'Nm', 'ParentId') VALUES 
    (1, '北京', 0),
    (2, '上海', 0),
    (3, '天津', 0),
    (4, '重庆', 0),
    (5, '广东', 0),
    (6, '广西', 0),
    (7, '湖北', 0),
    (8, '湖南', 0),
    (9, '山东', 0),
    (10, '山西', 0),
    (11, '河北', 0),
    (12, '河南', 0),
    (13, '四川', 0),
    (14, '浙江', 0),
    (15, '江苏', 0),
    (16, '福建', 0),
    (17, '江西', 0),
    (18, '安徽', 0),
    (19, '海南', 0),
    (20, '云南', 0),
    (21, '青海', 0),
    (22, '陕西', 0),
    (23, '甘肃', 0),
    (24, '贵州', 0),
    (25, '宁夏', 0),
    (26, '黑龙江', 0),
    (27, '吉林', 0),
    (28, '辽宁', 0),
    (29, '西藏', 0),
    (30, '***', 0),
    (31, '内蒙古', 0),
    (32, '香港', 0),
    (33, '澳门', 0),
    (34, '台湾', 0),

    (100, '北京', 1),(101, '上海', 2),(102, '天津', 3),(103, '重庆', 4),
    (104, '广州', 5),(105, '深圳', 5),(106, '珠海', 5),(107, '汕头', 5),(108, '韶关', 5),(109, '佛山', 5),(110, '江门', 5),(111, '湛江', 5),(112, '茂名', 5),(113, '肇庆', 5),(114, '惠州', 5),(115, '梅州', 5),(116, '汕尾', 5),(117, '河源', 5),(118, '阳江', 5),(119, '清远', 5),(120, '东莞', 5),(121, '中山', 5),(122, '潮州', 5),(123, '揭阳', 5),(124, '云浮', 5),
    (125, '南宁', 6),(126, '柳州', 6),(127, '桂林', 6),(128, '梧州', 6),(129, '北海', 6),(130, '防城港', 6),(131, '钦州', 6),(132, '贵港', 6),(133, '玉林', 6),(134, '百色', 6),(135, '贺州', 6),(136, '河池', 6),(137, '来宾', 6),(138, '崇左', 6),
    (139, '武汉', 7),(140, '黄石', 7),(141, '襄樊', 7),(142, '十堰', 7),(143, '荆州', 7),(144, '宜昌', 7),(145, '荆门', 7),(146, '鄂州', 7),(147, '孝感', 7),(148, '黄冈', 7),(149, '咸宁', 7),(150, '随州', 7),(151, '仙桃', 7),(152, '天门', 7),(153, '潜江', 7),(154, '神农架', 7),(155, '恩施土家族苗族自治州', 7),
    (156, '长沙', 8),(157, '株洲', 8),(158, '湘潭', 8),(159, '衡阳', 8),(160, '邵阳', 8),(161, '岳阳', 8),(162, '常德', 8),(163, '张家界', 8),(164, '益阳', 8),(165, '郴州', 8),(166, '怀化', 8),(167, '娄底', 8),(168, '湘西土家族苗族自治州', 8),(169, '永州', 8),
    (170, '济南', 9),(171, '青岛', 9),(172, '淄博', 9),(173, '枣庄', 9),(174, '东营', 9),(175, '潍坊', 9),(176, '烟台', 9),(177, '威海', 9),(178, '济宁', 9),(179, '泰安', 9),(180, '日照', 9),(181, '莱芜', 9),(182, '德州', 9),(183, '临沂', 9),(184, '聊城', 9),(185, '滨州', 9),(186, '菏泽', 9),
    (187, '太原', 10),(188, '大同', 10),(189, '阳泉', 10),(190, '长治', 10),(191, '晋城', 10),(192, '朔州', 10),(193, '普中', 10),(194, '运城', 10),(195, '忻州', 10),(196, '临汾', 10),(197, '吕梁', 10),
    (198, '石家庄', 11),(199, '唐山', 11),(200, '秦皇岛', 11),(201, '邯郸', 11),(202, '邢台', 11),(203, '保定', 11),(204, '张家口', 11),(205, '承德', 11),(206, '沧州', 11),(207, '廊坊', 11),(208, '衡水', 11),
    (209, '郑州', 12),(210, '开封', 12),(211, '洛阳', 12),(212, '平顶山', 12),(213, '焦作', 12),(214, '鹤壁', 12),(215, '新乡', 12),(216, '安阳', 12),(217, '濮阳', 12),(218, '许昌', 12),(219, '漯河', 12),(220, '三门峡', 12),(221, '南阳', 12),(222, '商丘', 12),(223, '信阳', 12),(224, '周口', 12),(225, '驻马店', 12),(226, '济源', 12),
    (227, '成都', 13),(228, '自贡', 13),(229, '攀枝花', 13),(230, '泸州', 13),(231, '德阳', 13),(232, '绵阳', 13),(233, '广元', 13),(234, '遂宁', 13),(235, '内江', 13),(236, '乐山', 13),(237, '南充', 13),(238, '宜宾', 13),(239, '广安', 13),(240, '达州', 13),(241, '眉山', 13),(242, '雅安', 13),(243, '巴中', 13),(244, '资阳', 13),(245, '阿坝藏族羌族自治州', 13),(246, '甘孜藏族自治州', 13),(247, '凉山彝族自治州', 13),
    (248, '杭州', 14),(249, '宁波', 14),(250, '温州', 14),(251, '嘉兴', 14),(252, '湖州', 14),(253, '绍兴', 14),(254, '金华', 14),(255, '衢州', 14),(256, '舟山', 14),(257, '台州', 14),(258, '丽水', 14),
    (259, '南京', 15),(260, '无锡', 15),(261, '徐州', 15),(262, '常州', 15),(263, '苏州', 15),(264, '南通', 15),(265, '连云港', 15),(266, '淮安', 15),(267, '盐城', 15),(268, '扬州', 15),(269, '镇江', 15),(270, '泰州', 15),(271, '宿迁', 15),
    (272, '福州', 16),(273, '厦门', 16),(274, '莆田', 16),(275, '三明', 16),(276, '泉州', 16),(277, '漳州', 16),(278, '南平', 16),(279, '龙岩', 16),(280, '宁德', 16),
    (281, '南昌', 17),(282, '景德镇', 17),(283, '萍乡', 17),(284, '新余', 17),(285, '九江', 17),(286, '鹰潭', 17),(287, '赣州', 17),(288, '吉安', 17),(289, '宜春', 17),(290, '抚州', 17),(291, '上饶', 17),
    (292, '合肥', 18),(293, '芜湖', 18),(294, '蚌埠', 18),(295, '淮南', 18),(296, '马鞍山', 18),(297, '淮北', 18),(298, '铜陵', 18),(299, '安庆', 18),(300, '黄山', 18),(301, '滁州', 18),(302, '阜阳', 18),(303, '宿州', 18),(304, '巢湖', 18),(305, '六安', 18),(306, '毫州', 18),(307, '池州', 18),(308, '宣城', 18),
    (309, '海口', 19),(310, '三亚', 19),(311, '五指山', 19),(312, '琼海', 19),(313, '儋州', 19),(314, '文昌', 19),(315, '万宁', 19),(316, '东方', 19),(317, '澄迈', 19),(318, '定安', 19),(319, '屯昌', 19),(320, '临高', 19),(321, '白沙黎族自治县', 19),(322, '昌江黎族自治县', 19),(323, '乐东黎族自治县', 19),(324, '陵水黎族自治县', 19),(325, '保亭黎族苗族自治县', 19),(326, '琼中黎族苗族自治县', 19),
    (327, '昆明', 20),(328, '曲靖', 20),(329, '玉溪', 20),(330, '保山', 20),(331, '昭通', 20),(332, '丽江', 20),(333, '思茅', 20),(334, '临沧', 20),(335, '文山壮族苗族自治州', 20),(336, '红河哈尼族彝族自治州', 20),(337, '西双版纳傣族自治州', 20),(338, '楚雄彝族自治州', 20),(339, '大理白族自治州', 20),(340, '德宏傣族景颇族自治州', 20),(341, '怒江傈僳族自治州', 20),(342, '迪庆藏族自治州', 20),
    (343, '西宁', 21),(344, '海东', 21),(345, '海北藏族自治区', 21),(346, '黄南藏族自治区', 21),(347, '海南藏族自治区', 21),(348, '果洛藏族自治区', 21),(349, '玉树藏族自治区', 21),(350, '海西蒙古族藏族自治区', 21),
    (351, '西安', 22),(352, '铜川', 22),(353, '宝鸡', 22),(354, '咸阳', 22),(355, '渭南', 22),(356, '延安', 22),(357, '汉中', 22),(358, '榆林', 22),(359, '安康', 22),(360, '商洛', 22),
    (361, '兰州', 23),(362, '金昌', 23),(363, '白银', 23),(364, '天水', 23),(365, '嘉峪关', 23),(366, '武威', 23),(367, '张掖', 23),(368, '平凉', 23),(369, '酒泉', 23),(370, '庆阳', 23),(371, '定西', 23),(372, '陇南', 23),(373, '临夏回族自治州', 23),(374, '甘南藏族自治州', 23),
    (375, '贵阳', 24),(376, '六盘水', 24),(377, '遵义', 24),(378, '安顺', 24),(379, '铜仁', 24),(380, '毕节', 24),(381, '黔西南而布依族苗族自治州', 24),(382, '黔东南而苗族侗族自治州', 24),(383, '黔南而布依族苗族自治州', 24),
    (384, '银川', 25),(385, '石嘴山', 25),(386, '吴忠', 25),(387, '固原', 25),
    (388, '哈尔滨', 26),(389, '齐齐哈尔', 26),(390, '鹤岗', 26),(391, '双鸭山', 26),(392, '鸡西', 26),(393, '大庆', 26),(394, '伊春', 26),(395, '牡丹江', 26),(396, '佳木斯', 26),(397, '七台河', 26),(398, '黑河', 26),(399, '绥化', 26),(400, '大兴安岭', 26),
    (401, '长春', 27),(402, '吉林市', 27),(403, '四平', 27),(404, '辽源', 27),(405, '通化', 27),(406, '白山', 27),(407, '松原', 27),(408, '白城', 27),(409, '延边朝鲜族自治州', 27),
    (410, '沈阳', 28),(411, '大连', 28),(412, '鞍山', 28),(413, '抚顺', 28),(414, '本溪', 28),(415, '丹东', 28),(416, '锦州', 28),(417, '葫芦岛', 28),(418, '营口', 28),(419, '盘锦', 28),(420, '阜新', 28),(421, '辽阳', 28),(422, '铁岭', 28),(423, '朝阳', 28),
    (424, '拉萨', 29),(425, '那曲', 29),(426, '昌都', 29),(427, '山南', 29),(428, '日喀则', 29),(429, '阿里', 29),(430, '林芝', 29),
    (431, '乌鲁木齐', 30),(432, '克拉玛依', 30),(433, '石河子', 30),(434, '阿拉尔', 30),(435, '图木舒克', 30),(436, '五家渠', 30),(437, '吐鲁番', 30),(438, '哈密', 30),(439, '和田', 30),(440, '阿克苏', 30),(441, '喀什', 30),(442, '克孜勒苏柯尔克孜自治州', 30),(443, '巴音郭楞蒙古自治州', 30),(444, '昌吉回族自治州', 30),(445, '博尔塔拉蒙古自治州', 30),(446, '伊犁哈萨克自治州', 30),
    (447, '呼和浩特', 31),(448, '包头', 31),(449, '乌海', 31),(450, '赤峰', 31),(451, '通辽', 31),(452, '鄂尔多斯', 31),(453, '呼伦贝尔', 31),(454, '乌兰察布盟', 31),(455, '锡林郭勒盟', 31),(456, '巴彦淖尔盟', 31),(457, '阿拉善盟', 31),(458, '兴安盟', 31),
    (459, '香港', 32),
    (460, '澳门', 33),
    (461, '台北', 34),(462, '高雄', 34),(463, '基隆', 34),(464, '台中', 34),(465, '台南', 34),(466, '新竹', 34),(467, '嘉义', 34),(468, '台北县', 34),(469, '宜兰县', 34),(470, '新竹县', 34),(471, '桃园县', 34),(472, '苗栗县', 34),(473, '台中县', 34),(474, '彰化县', 34),(475, '南投县', 34),(476, '嘉义县', 34),(477, '云林县', 34),(478, '台南县', 34),(479, '高雄县', 34),(480, '屏东县', 34),(481, '台东县', 34),(482, '花莲县', 34),(483, '澎湖县', 34);

 数据虽然有些乱但是不影响使用，sqlserver的数据我试过了没有问题，oracle的数据没有测试。