中国各省市sql.txt

最新推荐文章于 2018-01-17 15:57:26 发布
最新推荐文章于 2018-01-17 15:57:26 发布
阅读量1.9k 收藏 1
点赞数
分类专栏： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/nsrainbow/article/details/9464917
版权 
create table code_city
(
   id                   smallint not null,
   name                 varchar(50),
   pos                  tinyint,
   active_status        tinyint,
   province_id          smallint comment '省份id',
   primary key (id)
);

create table code_province
(
   id                   smallint not null,
   name                 varchar(20),
   pos                  tinyint,
   active_status        tinyint,
   primary key (id)
);

INSERT INTO code_province(id,name)VALUES(1,'北京');
  INSERT INTO code_city(id,name,province_id)VALUES(1,'东城区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(2,'西城区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(3,'宣武区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(4,'崇文区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(5,'朝阳区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(6,'海淀区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(7,'丰台区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(8,'石景山区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(9,'门头沟区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(10,'昌平区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(11,'大兴区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(12,'怀柔区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(13,'密云县',1);
  INSERT INTO code_city(id,name,province_id)VALUES(14,'平谷区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(15,'顺义区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(16,'通州区',1);
  INSERT INTO code_city(id,name,province_id)VALUES(17,'延庆县',1);
  INSERT INTO code_city(id,name,province_id)VALUES(103,'房山区',1);
INSERT INTO code_province(id,name)VALUES(2,'上海');
  INSERT INTO code_city(id,name,province_id)VALUES(18,'黄浦区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(19,'南市区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(20,'卢湾区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(21,'徐汇区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(22,'长宁区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(23,'静安区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(24,'普陀区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(25,'金山区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(26,'闸北区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(27,'虹口区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(28,'杨浦区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(29,'宝山区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(30,'闵行区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(31,'嘉定区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(32,'松江区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(33,'浦东新区',2);
  INSERT INTO code_city(id,name,province_id)VALUES(34,'青浦县',2);
  INSERT INTO code_city(id,name,province_id)VALUES(35,'奉贤县',2);
  INSERT INTO code_city(id,name,province_id)VALUES(36,'南汇县',2);
  INSERT INTO code_city(id,name,province_id)VALUES(37,'崇明县',2);
INSERT INTO code_province(id,name)VALUES(3,'天津');
  INSERT INTO code_city(id,name,province_id)VALUES(38,'和平区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(39,'河东区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(40,'河西区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(41,'河北区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(42,'南开区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(43,'红桥区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(44,'塘沽区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(45,'汉沽区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(105,'大港区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(106,'东丽区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(107,'西青区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(108,'津南区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(109,'北辰区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(110,' 武清区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(111,'宝坻区',3);
  INSERT INTO code_city(id,name,province_id)VALUES(112,'蓟 县',3);
  INSERT INTO code_city(id,name,province_id)VALUES(113,'宁河县',3);
  INSERT INTO code_city(id,name,province_id)VALUES(114,'静海县',3);
INSERT INTO code_province(id,name)VALUES(4,' 重庆');
  INSERT INTO code_city(id,name,province_id)VALUES(46,'永川市',4);
  INSERT INTO code_city(id,name,province_id)VALUES(47,'黔江区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(48,'涪陵区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(49,'万洲区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(115,'渝中区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(116,'大渡口区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(117,'江北区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(118,'沙坪坝区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(119,'九龙坡区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(120,'南岸区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(121,'北碚区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(122,' 万盛区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(123,'双桥区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(124,'渝北区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(125,'巴南区',4);
  INSERT INTO code_city(id,name,province_id)VALUES(126,'长寿区',4);
INSERT INTO code_province(id,name)VALUES(5,' 黑龙江');
  INSERT INTO code_city(id,name,province_id)VALUES(50,'哈尔滨',5);
  INSERT INTO code_city(id,name,province_id)VALUES(51,'齐齐哈尔',5);
  INSERT INTO code_city(id,name,province_id)VALUES(52,'牡丹江',5);
  INSERT INTO code_city(id,name,province_id)VALUES(127,'鹤岗',5);
  INSERT INTO code_city(id,name,province_id)VALUES(128,'双鸭山',5);
  INSERT INTO code_city(id,name,province_id)VALUES(129,'鸡西',5);
  INSERT INTO code_city(id,name,province_id)VALUES(130,'大庆',5);
  INSERT INTO code_city(id,name,province_id)VALUES(131,'伊春',5);
  INSERT INTO code_city(id,name,province_id)VALUES(132,'佳木斯',5);
  INSERT INTO code_city(id,name,province_id)VALUES(133,'七台河',5);
  INSERT INTO code_city(id,name,province_id)VALUES(134,'黑河',5);
  INSERT INTO code_city(id,name,province_id)VALUES(135,'绥化',5);
  INSERT INTO code_city(id,name,province_id)VALUES(136,'大兴安岭地区',5);
INSERT INTO code_province(id,name)VALUES(6,'吉林');
  INSERT INTO code_city(id,name,province_id)VALUES(53,'长春',6);
  INSERT INTO code_city(id,name,province_id)VALUES(54,'吉林',6);
  INSERT INTO code_city(id,name,province_id)VALUES(137,'四平',6);
  INSERT INTO code_city(id,name,province_id)VALUES(138,'辽源',6);
  INSERT INTO code_city(id,name,province_id)VALUES(139,'通化',6);
  INSERT INTO code_city(id,name,province_id)VALUES(140,'白山',6);
  INSERT INTO code_city(id,name,province_id)VALUES(141,'松原',6);
  INSERT INTO code_city(id,name,province_id)VALUES(142,'白城',6);
  INSERT INTO code_city(id,name,province_id)VALUES(143,'延边朝鲜族自治州',6);
  INSERT INTO code_city(id,name,province_id)VALUES(449,'高新',6);
  INSERT INTO code_city(id,name,province_id)VALUES(450,'延吉',6);
  INSERT INTO code_city(id,name,province_id)VALUES(451,'梅河口',6);
INSERT INTO code_province(id,name)VALUES(7,'辽宁');
  INSERT INTO code_city(id,name,province_id)VALUES(55,'沈阳',7);
  INSERT INTO code_city(id,name,province_id)VALUES(56,'大连',7);
  INSERT INTO code_city(id,name,province_id)VALUES(57,'锦州',7);
  INSERT INTO code_city(id,name,province_id)VALUES(144,'鞍山',7);
  INSERT INTO code_city(id,name,province_id)VALUES(145,'抚顺',7);
  INSERT INTO code_city(id,name,province_id)VALUES(146,'本溪',7);
  INSERT INTO code_city(id,name,province_id)VALUES(147,'丹东',7);
  INSERT INTO code_city(id,name,province_id)VALUES(148,'葫芦岛',7);
  INSERT INTO code_city(id,name,province_id)VALUES(149,'营口',7);
  INSERT INTO code_city(id,name,province_id)VALUES(150,'盘锦',7);
  INSERT INTO code_city(id,name,province_id)VALUES(151,'阜新',7);
  INSERT INTO code_city(id,name,province_id)VALUES(152,'辽阳',7);
  INSERT INTO code_city(id,name,province_id)VALUES(153,'铁岭',7);
  INSERT INTO code_city(id,name,province_id)VALUES(154,'朝阳',7);
  INSERT INTO code_city(id,name,province_id)VALUES(467,'瓦房店',7);
INSERT INTO code_province(id,name)VALUES(8,'内蒙古');
  INSERT INTO code_city(id,name,province_id)VALUES(58,'呼和浩特',8);
  INSERT INTO code_city(id,name,province_id)VALUES(59,'包头',8);
  INSERT INTO code_city(id,name,province_id)VALUES(155,'乌海',8);
  INSERT INTO code_city(id,name,province_id)VALUES(156,'赤峰',8);
  INSERT INTO code_city(id,name,province_id)VALUES(157,'通辽',8);
  INSERT INTO code_city(id,name,province_id)VALUES(158,'鄂尔多斯',8);
  INSERT INTO code_city(id,name,province_id)VALUES(160,'乌兰察布盟',8);
  INSERT INTO code_city(id,name,province_id)VALUES(161,'锡林郭勒盟',8);
  INSERT INTO code_city(id,name,province_id)VALUES(162,'巴彦淖尔盟',8);
  INSERT INTO code_city(id,name,province_id)VALUES(163,'阿拉善盟',8);
  INSERT INTO code_city(id,name,province_id)VALUES(164,'兴安盟',8);
  INSERT INTO code_city(id,name,province_id)VALUES(468,'巴彦淖尔',8);
  INSERT INTO code_city(id,name,province_id)VALUES(469,'呼伦贝尔',8);
  INSERT INTO code_city(id,name,province_id)VALUES(470,'集宁',8);
  INSERT INTO code_city(id,name,province_id)VALUES(471,' 乌兰浩特',8);
  INSERT INTO code_city(id,name,province_id)VALUES(472,'锡林浩特',8);
INSERT INTO code_province(id,name)VALUES(9,'宁夏');
  INSERT INTO code_city(id,name,province_id)VALUES(60,'银川',9);
  INSERT INTO code_city(id,name,province_id)VALUES(165,'石嘴山',9);
  INSERT INTO code_city(id,name,province_id)VALUES(166,'吴忠',9);
  INSERT INTO code_city(id,name,province_id)VALUES(167,'固原',9);
INSERT INTO code_province(id,name)VALUES(10,'新疆');
  INSERT INTO code_city(id,name,province_id)VALUES(61,'乌鲁木齐',10);
  INSERT INTO code_city(id,name,province_id)VALUES(168,'克拉玛依',10);
  INSERT INTO code_city(id,name,province_id)VALUES(169,'吐鲁番地区',10);
  INSERT INTO code_city(id,name,province_id)VALUES(170,'哈密地区',10);
  INSERT INTO code_city(id,name,province_id)VALUES(171,'和田地区',10);
  INSERT INTO code_city(id,name,province_id)VALUES(172,'阿克苏地区',10);
  INSERT INTO code_city(id,name,province_id)VALUES(173,'喀什地区',10);
  INSERT INTO code_city(id,name,province_id)VALUES(174,'克孜勒苏柯尔克孜自治州',10);
  INSERT INTO code_city(id,name,province_id)VALUES(175,'巴音郭楞蒙古自治州',10);
  INSERT INTO code_city(id,name,province_id)VALUES(176,'昌吉回族自治州',10);
  INSERT INTO code_city(id,name,province_id)VALUES(177,'博尔塔拉蒙古自治州',10);
  INSERT INTO code_city(id,name,province_id)VALUES(178,'伊犁哈萨克自治州',10);
  INSERT INTO code_city(id,name,province_id)VALUES(500,'阿克苏',10);
  INSERT INTO code_city(id,name,province_id)VALUES(501,'昌吉',10);
  INSERT INTO code_city(id,name,province_id)VALUES(502,'哈密',10);
  INSERT INTO code_city(id,name,province_id)VALUES(503,'和田',10);
  INSERT INTO code_city(id,name,province_id)VALUES(504,'喀什',10);
  INSERT INTO code_city(id,name,province_id)VALUES(505,'克拉马依',10);
  INSERT INTO code_city(id,name,province_id)VALUES(506,'库尔勒',10);
  INSERT INTO code_city(id,name,province_id)VALUES(507,'石河子',10);
  INSERT INTO code_city(id,name,province_id)VALUES(508,'吐鲁番',10);
  INSERT INTO code_city(id,name,province_id)VALUES(509,' 乌市',10);
  INSERT INTO code_city(id,name,province_id)VALUES(510,'奎屯',10);
  INSERT INTO code_city(id,name,province_id)VALUES(511,'伊犁',10);
  INSERT INTO code_city(id,name,province_id)VALUES(512,'伊宁',10);
INSERT INTO code_province(id,name)VALUES(11,'青海');
  INSERT INTO code_city(id,name,province_id)VALUES(62,'西宁',11);
  INSERT INTO code_city(id,name,province_id)VALUES(179,'海东地区',11);
  INSERT INTO code_city(id,name,province_id)VALUES(180,' 海北藏族自治州',11);
  INSERT INTO code_city(id,name,province_id)VALUES(181,'黄南藏族自治州',11);
  INSERT INTO code_city(id,name,province_id)VALUES(182,'海南藏族自治州',11);
  INSERT INTO code_city(id,name,province_id)VALUES(183,'果洛藏族自治州',11);
  INSERT INTO code_city(id,name,province_id)VALUES(184,'玉树藏族自治州',11);
  INSERT INTO code_city(id,name,province_id)VALUES(185,'海西蒙古族藏族自治州',11);
  INSERT INTO code_city(id,name,province_id)VALUES(473,'格尔木',11);
INSERT INTO code_province(id,name)VALUES(12,'甘肃');
  INSERT INTO code_city(id,name,province_id)VALUES(63,'兰州',12);
  INSERT INTO code_city(id,name,province_id)VALUES(64,'天水',12);
  INSERT INTO code_city(id,name,province_id)VALUES(186,'金昌',12);
  INSERT INTO code_city(id,name,province_id)VALUES(187,'白银',12);
  INSERT INTO code_city(id,name,province_id)VALUES(188,'嘉峪关',12);
  INSERT INTO code_city(id,name,province_id)VALUES(189,'武 威 ',12);
  INSERT INTO code_city(id,name,province_id)VALUES(190,'张掖',12);
  INSERT INTO code_city(id,name,province_id)VALUES(191,'平凉',12);
  INSERT INTO code_city(id,name,province_id)VALUES(192,'酒泉',12);
  INSERT INTO code_city(id,name,province_id)VALUES(193,'庆阳',12);
  INSERT INTO code_city(id,name,province_id)VALUES(194,'定西地区',12);
  INSERT INTO code_city(id,name,province_id)VALUES(195,'陇南地区',12);
  INSERT INTO code_city(id,name,province_id)VALUES(196,'甘南藏族自治州',12);
  INSERT INTO code_city(id,name,province_id)VALUES(197,'临夏回族自治州',12);
  INSERT INTO code_city(id,name,province_id)VALUES(422,'嘉峪',12);
  INSERT INTO code_city(id,name,province_id)VALUES(423,'武威',12);
INSERT INTO code_province(id,name)VALUES(13,'陕西');
  INSERT INTO code_city(id,name,province_id)VALUES(65,'西安',13);
  INSERT INTO code_city(id,name,province_id)VALUES(66,'宝鸡',13);
  INSERT INTO code_city(id,name,province_id)VALUES(67,'延安',13);
  INSERT INTO code_city(id,name,province_id)VALUES(198,'铜川',13);
  INSERT INTO code_city(id,name,province_id)VALUES(199,'咸阳',13);
  INSERT INTO code_city(id,name,province_id)VALUES(200,'渭南',13);
  INSERT INTO code_city(id,name,province_id)VALUES(201,'汉中',13);
  INSERT INTO code_city(id,name,province_id)VALUES(202,'榆林',13);
  INSERT INTO code_city(id,name,province_id)VALUES(203,'安康',13);
  INSERT INTO code_city(id,name,province_id)VALUES(204,'商洛',13);
  INSERT INTO code_city(id,name,province_id)VALUES(496,'韩城',13);
INSERT INTO code_province(id,name)VALUES(14,'河北');
  INSERT INTO code_city(id,name,province_id)VALUES(68,'石家庄',14);
  INSERT INTO code_city(id,name,province_id)VALUES(69,'保定',14);
  INSERT INTO code_city(id,name,province_id)VALUES(205,'唐山',14);
  INSERT INTO code_city(id,name,province_id)VALUES(206,'秦皇岛',14);
  INSERT INTO code_city(id,name,province_id)VALUES(207,'邯郸',14);
  INSERT INTO code_city(id,name,province_id)VALUES(208,'邢台',14);
  INSERT INTO code_city(id,name,province_id)VALUES(209,'张家口',14);
  INSERT INTO code_city(id,name,province_id)VALUES(210,'承德',14);
  INSERT INTO code_city(id,name,province_id)VALUES(211,'沧州',14);
  INSERT INTO code_city(id,name,province_id)VALUES(212,'廊坊',14);
  INSERT INTO code_city(id,name,province_id)VALUES(213,'衡水',14);
  INSERT INTO code_city(id,name,province_id)VALUES(436,'霸州',14);
  INSERT INTO code_city(id,name,province_id)VALUES(437,'青县',14);
  INSERT INTO code_city(id,name,province_id)VALUES(438,'任丘',14);
  INSERT INTO code_city(id,name,province_id)VALUES(439,'涿州',14);
INSERT INTO code_province(id,name)VALUES(15,'河南');
  INSERT INTO code_city(id,name,province_id)VALUES(70,'郑州',15);
  INSERT INTO code_city(id,name,province_id)VALUES(71,'洛阳',15);
  INSERT INTO code_city(id,name,province_id)VALUES(214,'开封',15);
  INSERT INTO code_city(id,name,province_id)VALUES(215,'平顶山',15);
  INSERT INTO code_city(id,name,province_id)VALUES(216,'焦作',15);
  INSERT INTO code_city(id,name,province_id)VALUES(217,'鹤壁',15);
  INSERT INTO code_city(id,name,province_id)VALUES(218,'新乡',15);
  INSERT INTO code_city(id,name,province_id)VALUES(219,'安阳',15);
  INSERT INTO code_city(id,name,province_id)VALUES(220,'濮阳',15);
  INSERT INTO code_city(id,name,province_id)VALUES(221,'许昌',15);
  INSERT INTO code_city(id,name,province_id)VALUES(222,'漯河',15);
  INSERT INTO code_city(id,name,province_id)VALUES(223,'三门峡',15);
  INSERT INTO code_city(id,name,province_id)VALUES(224,'南阳',15);
  INSERT INTO code_city(id,name,province_id)VALUES(225,'商丘',15);
  INSERT INTO code_city(id,name,province_id)VALUES(226,'信阳',15);
  INSERT INTO code_city(id,name,province_id)VALUES(227,'周口',15);
  INSERT INTO code_city(id,name,province_id)VALUES(228,'驻马店',15);
INSERT INTO code_province(id,name)VALUES(16,'山东');
  INSERT INTO code_city(id,name,province_id)VALUES(72,'济南',16);
  INSERT INTO code_city(id,name,province_id)VALUES(73,'青岛',16);
  INSERT INTO code_city(id,name,province_id)VALUES(74,'烟台',16);
  INSERT INTO code_city(id,name,province_id)VALUES(229,'淄博',16);
  INSERT INTO code_city(id,name,province_id)VALUES(230,'枣庄',16);
  INSERT INTO code_city(id,name,province_id)VALUES(231,'东营',16);
  INSERT INTO code_city(id,name,province_id)VALUES(232,'潍坊',16);
  INSERT INTO code_city(id,name,province_id)VALUES(233,'威海',16);
  INSERT INTO code_city(id,name,province_id)VALUES(234,'济宁',16);
  INSERT INTO code_city(id,name,province_id)VALUES(235,'泰安',16);
  INSERT INTO code_city(id,name,province_id)VALUES(236,'日照',16);
  INSERT INTO code_city(id,name,province_id)VALUES(237,'莱芜',16);
  INSERT INTO code_city(id,name,province_id)VALUES(238,'德州',16);
  INSERT INTO code_city(id,name,province_id)VALUES(239,'临沂',16);
  INSERT INTO code_city(id,name,province_id)VALUES(240,'聊城',16);
  INSERT INTO code_city(id,name,province_id)VALUES(241,'滨州',16);
  INSERT INTO code_city(id,name,province_id)VALUES(242,'菏泽',16);
  INSERT INTO code_city(id,name,province_id)VALUES(474,'高密',16);
  INSERT INTO code_city(id,name,province_id)VALUES(475,'荷泽',16);
  INSERT INTO code_city(id,name,province_id)VALUES(476,'淮坊',16);
  INSERT INTO code_city(id,name,province_id)VALUES(477,'即墨',16);
  INSERT INTO code_city(id,name,province_id)VALUES(478,'胶南',16);
  INSERT INTO code_city(id,name,province_id)VALUES(479,'莱州',16);
  INSERT INTO code_city(id,name,province_id)VALUES(480,'林沂',16);
  INSERT INTO code_city(id,name,province_id)VALUES(481,'临忻',16);
  INSERT INTO code_city(id,name,province_id)VALUES(482,'龙口',16);
  INSERT INTO code_city(id,name,province_id)VALUES(483,'蓬莱',16);
  INSERT INTO code_city(id,name,province_id)VALUES(484,'青州',16);
  INSERT INTO code_city(id,name,province_id)VALUES(485,'乳山',16);
  INSERT INTO code_city(id,name,province_id)VALUES(486,'寿光',16);
  INSERT INTO code_city(id,name,province_id)VALUES(487,'滕州',16);
  INSERT INTO code_city(id,name,province_id)VALUES(488,'文登',16);
  INSERT INTO code_city(id,name,province_id)VALUES(489,'招远',16);
INSERT INTO code_province(id,name)VALUES(17,'山西');
  INSERT INTO code_city(id,name,province_id)VALUES(75,'太原',17);
  INSERT INTO code_city(id,name,province_id)VALUES(76,'大同',17);
  INSERT INTO code_city(id,name,province_id)VALUES(243,'朔州',17);
  INSERT INTO code_city(id,name,province_id)VALUES(244,'阳泉',17);
  INSERT INTO code_city(id,name,province_id)VALUES(245,'长治',17);
  INSERT INTO code_city(id,name,province_id)VALUES(246,'晋城',17);
  INSERT INTO code_city(id,name,province_id)VALUES(247,'忻州',17);
  INSERT INTO code_city(id,name,province_id)VALUES(248,'晋中',17);
  INSERT INTO code_city(id,name,province_id)VALUES(249,'临汾',17);
  INSERT INTO code_city(id,name,province_id)VALUES(250,'运城',17);
  INSERT INTO code_city(id,name,province_id)VALUES(251,'吕梁地区',17);
  INSERT INTO code_city(id,name,province_id)VALUES(491,'河津',17);
  INSERT INTO code_city(id,name,province_id)VALUES(492,'侯马',17);
  INSERT INTO code_city(id,name,province_id)VALUES(494,'孝义',17);
  INSERT INTO code_city(id,name,province_id)VALUES(495,'榆次',17);
INSERT INTO code_province(id,name)VALUES(18,'湖北');
  INSERT INTO code_city(id,name,province_id)VALUES(77,'武汉',18);
  INSERT INTO code_city(id,name,province_id)VALUES(252,'黄石',18);
  INSERT INTO code_city(id,name,province_id)VALUES(253,'襄樊',18);
  INSERT INTO code_city(id,name,province_id)VALUES(254,'十堰',18);
  INSERT INTO code_city(id,name,province_id)VALUES(255,'荆州',18);
  INSERT INTO code_city(id,name,province_id)VALUES(256,'宜昌',18);
  INSERT INTO code_city(id,name,province_id)VALUES(257,'荆门',18);
  INSERT INTO code_city(id,name,province_id)VALUES(258,'鄂州',18);
  INSERT INTO code_city(id,name,province_id)VALUES(259,'孝感',18);
  INSERT INTO code_city(id,name,province_id)VALUES(260,'黄冈',18);
  INSERT INTO code_city(id,name,province_id)VALUES(261,'咸宁',18);
  INSERT INTO code_city(id,name,province_id)VALUES(262,'随州',18);
  INSERT INTO code_city(id,name,province_id)VALUES(263,'恩施土家族苗族自治州',18);
  INSERT INTO code_city(id,name,province_id)VALUES(440,'安陆',18);
  INSERT INTO code_city(id,name,province_id)VALUES(441,'恩施',18);
  INSERT INTO code_city(id,name,province_id)VALUES(442,'汉口',18);
  INSERT INTO code_city(id,name,province_id)VALUES(443,'汉阳',18);
  INSERT INTO code_city(id,name,province_id)VALUES(444,'潜江',18);
  INSERT INTO code_city(id,name,province_id)VALUES(445,'仙桃',18);
  INSERT INTO code_city(id,name,province_id)VALUES(446,'株州',18);
INSERT INTO code_province(id,name)VALUES(19,'湖南');
  INSERT INTO code_city(id,name,province_id)VALUES(78,'长沙',19);
  INSERT INTO code_city(id,name,province_id)VALUES(264,'株洲',19);
  INSERT INTO code_city(id,name,province_id)VALUES(265,'湘潭',19);
  INSERT INTO code_city(id,name,province_id)VALUES(266,'衡阳',19);
  INSERT INTO code_city(id,name,province_id)VALUES(267,'邵阳',19);
  INSERT INTO code_city(id,name,province_id)VALUES(268,'岳阳',19);
  INSERT INTO code_city(id,name,province_id)VALUES(269,'常德',19);
  INSERT INTO code_city(id,name,province_id)VALUES(270,'张家界',19);
  INSERT INTO code_city(id,name,province_id)VALUES(271,'益阳',19);
  INSERT INTO code_city(id,name,province_id)VALUES(272,'郴州',19);
  INSERT INTO code_city(id,name,province_id)VALUES(273,'永州',19);
  INSERT INTO code_city(id,name,province_id)VALUES(274,'怀化',19);
  INSERT INTO code_city(id,name,province_id)VALUES(275,'娄底',19);
  INSERT INTO code_city(id,name,province_id)VALUES(276,'湘西土家族苗族自治州',19);
  INSERT INTO code_city(id,name,province_id)VALUES(447,'株州',19);
  INSERT INTO code_city(id,name,province_id)VALUES(448,'邵东',19);
INSERT INTO code_province(id,name)VALUES(20,'安徽');
  INSERT INTO code_city(id,name,province_id)VALUES(79,'合肥',20);
  INSERT INTO code_city(id,name,province_id)VALUES(80,'芜湖',20);
  INSERT INTO code_city(id,name,province_id)VALUES(277,'蚌埠',20);
  INSERT INTO code_city(id,name,province_id)VALUES(278,'淮南',20);
  INSERT INTO code_city(id,name,province_id)VALUES(279,'马鞍山',20);
  INSERT INTO code_city(id,name,province_id)VALUES(280,'淮北',20);
  INSERT INTO code_city(id,name,province_id)VALUES(281,'铜陵',20);
  INSERT INTO code_city(id,name,province_id)VALUES(282,'安庆',20);
  INSERT INTO code_city(id,name,province_id)VALUES(283,'黄山',20);
  INSERT INTO code_city(id,name,province_id)VALUES(284,'滁州',20);
  INSERT INTO code_city(id,name,province_id)VALUES(285,'阜阳',20);
  INSERT INTO code_city(id,name,province_id)VALUES(286,'宿州',20);
  INSERT INTO code_city(id,name,province_id)VALUES(287,'巢湖',20);
  INSERT INTO code_city(id,name,province_id)VALUES(288,'六安',20);
  INSERT INTO code_city(id,name,province_id)VALUES(289,'亳州',20);
  INSERT INTO code_city(id,name,province_id)VALUES(290,'池州',20);
  INSERT INTO code_city(id,name,province_id)VALUES(291,'宣城',20);
  INSERT INTO code_city(id,name,province_id)VALUES(412,'蒙城',20);
  INSERT INTO code_city(id,name,province_id)VALUES(413,'宁国',20);
  INSERT INTO code_city(id,name,province_id)VALUES(414,'桐城',20);
INSERT INTO code_province(id,name)VALUES(21,'江苏');
  INSERT INTO code_city(id,name,province_id)VALUES(81,'南京',21);
  INSERT INTO code_city(id,name,province_id)VALUES(292,'徐州',21);
  INSERT INTO code_city(id,name,province_id)VALUES(293,'连云港',21);
  INSERT INTO code_city(id,name,province_id)VALUES(294,'淮安',21);
  INSERT INTO code_city(id,name,province_id)VALUES(295,'宿迁',21);
  INSERT INTO code_city(id,name,province_id)VALUES(296,'盐城',21);
  INSERT INTO code_city(id,name,province_id)VALUES(297,'扬州',21);
  INSERT INTO code_city(id,name,province_id)VALUES(298,'泰州',21);
  INSERT INTO code_city(id,name,province_id)VALUES(299,'南通',21);
  INSERT INTO code_city(id,name,province_id)VALUES(300,'镇江',21);
  INSERT INTO code_city(id,name,province_id)VALUES(301,'常州',21);
  INSERT INTO code_city(id,name,province_id)VALUES(302,'无锡',21);
  INSERT INTO code_city(id,name,province_id)VALUES(303,'苏州',21);
  INSERT INTO code_city(id,name,province_id)VALUES(452,'常熟',21);
  INSERT INTO code_city(id,name,province_id)VALUES(453,'丹阳',21);
  INSERT INTO code_city(id,name,province_id)VALUES(454,'海门',21);
  INSERT INTO code_city(id,name,province_id)VALUES(455,'江都',21);
  INSERT INTO code_city(id,name,province_id)VALUES(456,'江阴',21);
  INSERT INTO code_city(id,name,province_id)VALUES(457,'靖江',21);
  INSERT INTO code_city(id,name,province_id)VALUES(458,'昆山',21);
  INSERT INTO code_city(id,name,province_id)VALUES(459,'溧阳',21);
  INSERT INTO code_city(id,name,province_id)VALUES(460,'太仓',21);
  INSERT INTO code_city(id,name,province_id)VALUES(461,'泰州华',21);
  INSERT INTO code_city(id,name,province_id)VALUES(462,'吴江',21);
  INSERT INTO code_city(id,name,province_id)VALUES(463,'吴县',21);
  INSERT INTO code_city(id,name,province_id)VALUES(464,'宜兴',21);
  INSERT INTO code_city(id,name,province_id)VALUES(465,'张家港',21);


INSERT INTO code_province(id,name)VALUES(22,' 浙江');
  INSERT INTO code_city(id,name,province_id)VALUES(82,'杭州',22);
  INSERT INTO code_city(id,name,province_id)VALUES(304,'宁波',22);
  INSERT INTO code_city(id,name,province_id)VALUES(305,'温州',22);
  INSERT INTO code_city(id,name,province_id)VALUES(306,'嘉兴',22);
  INSERT INTO code_city(id,name,province_id)VALUES(307,'湖州',22);
  INSERT INTO code_city(id,name,province_id)VALUES(308,'绍兴',22);
  INSERT INTO code_city(id,name,province_id)VALUES(309,'金华',22);
  INSERT INTO code_city(id,name,province_id)VALUES(310,'衢州',22);
  INSERT INTO code_city(id,name,province_id)VALUES(311,'舟山',22);
  INSERT INTO code_city(id,name,province_id)VALUES(312,'台州',22);
  INSERT INTO code_city(id,name,province_id)VALUES(313,'丽水',22);
  INSERT INTO code_city(id,name,province_id)VALUES(514,'慈溪',22);
  INSERT INTO code_city(id,name,province_id)VALUES(515,'东阳',22);
  INSERT INTO code_city(id,name,province_id)VALUES(516,'奉化',22);
  INSERT INTO code_city(id,name,province_id)VALUES(517,'乐清',22);
  INSERT INTO code_city(id,name,province_id)VALUES(518,'临安',22);
  INSERT INTO code_city(id,name,province_id)VALUES(519,'临海',22);
  INSERT INTO code_city(id,name,province_id)VALUES(520,'平湖',22);
  INSERT INTO code_city(id,name,province_id)VALUES(521,'瑞安',22);
  INSERT INTO code_city(id,name,province_id)VALUES(522,'上虞',22);
  INSERT INTO code_city(id,name,province_id)VALUES(523,'嵊州',22);
  INSERT INTO code_city(id,name,province_id)VALUES(524,'温岭',22);
  INSERT INTO code_city(id,name,province_id)VALUES(525,'义乌',22);
  INSERT INTO code_city(id,name,province_id)VALUES(526,'永康',22);
  INSERT INTO code_city(id,name,province_id)VALUES(527,'余姚',22);
  INSERT INTO code_city(id,name,province_id)VALUES(528,'诸暨',22);
  INSERT INTO code_city(id,name,province_id)VALUES(529,'新昌',22);
INSERT INTO code_province(id,name)VALUES(23,'江西');
  INSERT INTO code_city(id,name,province_id)VALUES(83,'南昌',23);
  INSERT INTO code_city(id,name,province_id)VALUES(314,'景德镇',23);
  INSERT INTO code_city(id,name,province_id)VALUES(315,'萍乡',23);
  INSERT INTO code_city(id,name,province_id)VALUES(316,'新余',23);
  INSERT INTO code_city(id,name,province_id)VALUES(317,'九江',23);
  INSERT INTO code_city(id,name,province_id)VALUES(318,'鹰潭',23);
  INSERT INTO code_city(id,name,province_id)VALUES(319,'赣州',23);
  INSERT INTO code_city(id,name,province_id)VALUES(320,'吉安',23);
  INSERT INTO code_city(id,name,province_id)VALUES(321,'宜春',23);
  INSERT INTO code_city(id,name,province_id)VALUES(322,'抚州',23);
  INSERT INTO code_city(id,name,province_id)VALUES(323,'上饶',23);
  INSERT INTO code_city(id,name,province_id)VALUES(466,'高安',23);
INSERT INTO code_province(id,name)VALUES(24,'广东');
  INSERT INTO code_city(id,name,province_id)VALUES(84,'广州',24);
  INSERT INTO code_city(id,name,province_id)VALUES(85,'深圳',24);
  INSERT INTO code_city(id,name,province_id)VALUES(324,'珠海',24);
  INSERT INTO code_city(id,name,province_id)VALUES(325,'汕头',24);
  INSERT INTO code_city(id,name,province_id)VALUES(326,'韶关',24);
  INSERT INTO code_city(id,name,province_id)VALUES(327,'河源',24);
  INSERT INTO code_city(id,name,province_id)VALUES(328,'梅州',24);
  INSERT INTO code_city(id,name,province_id)VALUES(329,'惠州',24);
  INSERT INTO code_city(id,name,province_id)VALUES(330,'汕尾',24);
  INSERT INTO code_city(id,name,province_id)VALUES(331,'东莞',24);
  INSERT INTO code_city(id,name,province_id)VALUES(332,'中山',24);
  INSERT INTO code_city(id,name,province_id)VALUES(333,'江门',24);
  INSERT INTO code_city(id,name,province_id)VALUES(334,'佛山',24);
  INSERT INTO code_city(id,name,province_id)VALUES(335,'阳江',24);
  INSERT INTO code_city(id,name,province_id)VALUES(336,'湛江',24);
  INSERT INTO code_city(id,name,province_id)VALUES(337,'茂名',24);
  INSERT INTO code_city(id,name,province_id)VALUES(338,'肇庆',24);
  INSERT INTO code_city(id,name,province_id)VALUES(339,'清远',24);
  INSERT INTO code_city(id,name,province_id)VALUES(340,'潮州',24);
  INSERT INTO code_city(id,name,province_id)VALUES(341,'揭阳',24);
  INSERT INTO code_city(id,name,province_id)VALUES(342,'云浮',24);
  INSERT INTO code_city(id,name,province_id)VALUES(424,'花都',24);
  INSERT INTO code_city(id,name,province_id)VALUES(425,'开平',24);
  INSERT INTO code_city(id,name,province_id)VALUES(426,'南海',24);
  INSERT INTO code_city(id,name,province_id)VALUES(427,'顺德',24);
  INSERT INTO code_city(id,name,province_id)VALUES(428,'台山',24);
  INSERT INTO code_city(id,name,province_id)VALUES(429,'增城',24);
  INSERT INTO code_city(id,name,province_id)VALUES(431,'市梅',24);
INSERT INTO code_province(id,name)VALUES(25,'广西');
  INSERT INTO code_city(id,name,province_id)VALUES(86,'南宁',25);
  INSERT INTO code_city(id,name,province_id)VALUES(343,'柳州',25);
  INSERT INTO code_city(id,name,province_id)VALUES(344,'桂林',25);
  INSERT INTO code_city(id,name,province_id)VALUES(345,'梧州',25);
  INSERT INTO code_city(id,name,province_id)VALUES(346,'北海',25);
  INSERT INTO code_city(id,name,province_id)VALUES(347,'防城港',25);
  INSERT INTO code_city(id,name,province_id)VALUES(348,'钦州',25);
  INSERT INTO code_city(id,name,province_id)VALUES(349,'贵港',25);
  INSERT INTO code_city(id,name,province_id)VALUES(350,'玉林',25);
  INSERT INTO code_city(id,name,province_id)VALUES(351,'百色',25);
  INSERT INTO code_city(id,name,province_id)VALUES(352,'贺州',25);
  INSERT INTO code_city(id,name,province_id)VALUES(353,'河池',25);
  INSERT INTO code_city(id,name,province_id)VALUES(354,'来宾',25);
  INSERT INTO code_city(id,name,province_id)VALUES(355,'崇左',25);
INSERT INTO code_province(id,name)VALUES(26,'福建');
  INSERT INTO code_city(id,name,province_id)VALUES(87,'福州',26);
  INSERT INTO code_city(id,name,province_id)VALUES(88,'厦门',26);
  INSERT INTO code_city(id,name,province_id)VALUES(356,'三明',26);
  INSERT INTO code_city(id,name,province_id)VALUES(357,'莆田',26);
  INSERT INTO code_city(id,name,province_id)VALUES(358,'泉州',26);
  INSERT INTO code_city(id,name,province_id)VALUES(359,'漳州',26);
  INSERT INTO code_city(id,name,province_id)VALUES(360,'南平',26);
  INSERT INTO code_city(id,name,province_id)VALUES(361,'龙岩',26);
  INSERT INTO code_city(id,name,province_id)VALUES(362,'宁德',26);
  INSERT INTO code_city(id,name,province_id)VALUES(415,'福清',26);
  INSERT INTO code_city(id,name,province_id)VALUES(416,'建瓯',26);
  INSERT INTO code_city(id,name,province_id)VALUES(417,'晋江',26);
  INSERT INTO code_city(id,name,province_id)VALUES(418,'南安',26);
  INSERT INTO code_city(id,name,province_id)VALUES(419,'邵武',26);
  INSERT INTO code_city(id,name,province_id)VALUES(420,'石狮',26);
  INSERT INTO code_city(id,name,province_id)VALUES(421,'仙游',26);


INSERT INTO code_province(id,name)VALUES(27,'四川');
  INSERT INTO code_city(id,name,province_id)VALUES(89,'成都',27);
  INSERT INTO code_city(id,name,province_id)VALUES(363,'自贡',27);
  INSERT INTO code_city(id,name,province_id)VALUES(364,'攀枝花',27);
  INSERT INTO code_city(id,name,province_id)VALUES(365,'泸州',27);
  INSERT INTO code_city(id,name,province_id)VALUES(366,'德阳',27);
  INSERT INTO code_city(id,name,province_id)VALUES(367,'绵阳',27);
  INSERT INTO code_city(id,name,province_id)VALUES(368,'广元',27);
  INSERT INTO code_city(id,name,province_id)VALUES(369,'遂宁',27);
  INSERT INTO code_city(id,name,province_id)VALUES(370,'内江',27);
  INSERT INTO code_city(id,name,province_id)VALUES(371,'乐山',27);
  INSERT INTO code_city(id,name,province_id)VALUES(372,'南充',27);
  INSERT INTO code_city(id,name,province_id)VALUES(373,'宜宾',27);
  INSERT INTO code_city(id,name,province_id)VALUES(374,'广安',27);
  INSERT INTO code_city(id,name,province_id)VALUES(375,'达州',27);
  INSERT INTO code_city(id,name,province_id)VALUES(376,'巴中',27);
  INSERT INTO code_city(id,name,province_id)VALUES(377,'雅安',27);
  INSERT INTO code_city(id,name,province_id)VALUES(378,'眉山',27);
  INSERT INTO code_city(id,name,province_id)VALUES(379,'资阳',27);
  INSERT INTO code_city(id,name,province_id)VALUES(380,'阿坝藏族羌族自治州',27);
  INSERT INTO code_city(id,name,province_id)VALUES(381,'甘孜藏族自治州',27);
  INSERT INTO code_city(id,name,province_id)VALUES(382,'凉山彝族自治州',27);
  INSERT INTO code_city(id,name,province_id)VALUES(497,'广汉',27);
  INSERT INTO code_city(id,name,province_id)VALUES(498,'锦阳',27);
  INSERT INTO code_city(id,name,province_id)VALUES(499,'西昌',27);
INSERT INTO code_province(id,name)VALUES(28,'云南');
  INSERT INTO code_city(id,name,province_id)VALUES(90,'昆明',28);
  INSERT INTO code_city(id,name,province_id)VALUES(383,'曲靖',28);
  INSERT INTO code_city(id,name,province_id)VALUES(384,'玉溪',28);
  INSERT INTO code_city(id,name,province_id)VALUES(385,'保山',28);
  INSERT INTO code_city(id,name,province_id)VALUES(386,'昭通',28);
  INSERT INTO code_city(id,name,province_id)VALUES(387,'思茅地区',28);
  INSERT INTO code_city(id,name,province_id)VALUES(388,'临沧地区',28);
  INSERT INTO code_city(id,name,province_id)VALUES(389,'丽江',28);
  INSERT INTO code_city(id,name,province_id)VALUES(390,' 文山壮族苗族自治州',28);
  INSERT INTO code_city(id,name,province_id)VALUES(391,'红河哈尼族彝族自治州',28);
  INSERT INTO code_city(id,name,province_id)VALUES(392,'西双版纳傣族自治州',28);
  INSERT INTO code_city(id,name,province_id)VALUES(393,'楚雄彝族自治州',28);
  INSERT INTO code_city(id,name,province_id)VALUES(394,'大理白族自治州',28);
  INSERT INTO code_city(id,name,province_id)VALUES(395,'德宏傣族景颇族自治州',28);
  INSERT INTO code_city(id,name,province_id)VALUES(396,'怒江傈傈族自治州',28);
  INSERT INTO code_city(id,name,province_id)VALUES(397,'迪庆藏族自治州',28);
  INSERT INTO code_city(id,name,province_id)VALUES(513,'大理',28);
INSERT INTO code_province(id,name)VALUES(29,'贵州');
  INSERT INTO code_city(id,name,province_id)VALUES(91,'贵阳',29);
  INSERT INTO code_city(id,name,province_id)VALUES(398,'六盘水',29);
  INSERT INTO code_city(id,name,province_id)VALUES(399,'遵义',29);
  INSERT INTO code_city(id,name,province_id)VALUES(400,'安顺',29);
  INSERT INTO code_city(id,name,province_id)VALUES(401,'铜仁地区',29);
  INSERT INTO code_city(id,name,province_id)VALUES(402,'毕节地区',29);
  INSERT INTO code_city(id,name,province_id)VALUES(403,'黔西南布依族苗族自治州',29);
  INSERT INTO code_city(id,name,province_id)VALUES(404,'黔东南苗族侗族自治州',29);
  INSERT INTO code_city(id,name,province_id)VALUES(405,'黔南布依族苗族自治州',29);
  INSERT INTO code_city(id,name,province_id)VALUES(432,'都匀',29);
  INSERT INTO code_city(id,name,province_id)VALUES(433,'贵恙',29);
  INSERT INTO code_city(id,name,province_id)VALUES(434,'凯里',29);
  INSERT INTO code_city(id,name,province_id)VALUES(435,'铜仁',29);
INSERT INTO code_province(id,name)VALUES(30,'西藏');
  INSERT INTO code_city(id,name,province_id)VALUES(92,'拉萨',30);
  INSERT INTO code_city(id,name,province_id)VALUES(406,'那曲地区',30);
  INSERT INTO code_city(id,name,province_id)VALUES(407,'昌都地区',30);
  INSERT INTO code_city(id,name,province_id)VALUES(408,'山南地区',30);
  INSERT INTO code_city(id,name,province_id)VALUES(409,'日喀则地区',30);
  INSERT INTO code_city(id,name,province_id)VALUES(410,'阿里地区',30);
  INSERT INTO code_city(id,name,province_id)VALUES(411,'林芝地区',30);
INSERT INTO code_province(id,name)VALUES(31,'海南');
  INSERT INTO code_city(id,name,province_id)VALUES(93,'海口',31);
  INSERT INTO code_city(id,name,province_id)VALUES(94,'三亚',31);
INSERT INTO code_province(id,name)VALUES(32,'香港');
  INSERT INTO code_city(id,name,province_id)VALUES(95,'香港',32);
INSERT INTO code_province(id,name)VALUES(33,'澳门');
  INSERT INTO code_city(id,name,province_id)VALUES(96,'澳门',33);
INSERT INTO code_province(id,name)VALUES(34,'台湾');
  INSERT INTO code_city(id,name,province_id)VALUES(97,'台北',34);
  INSERT INTO code_city(id,name,province_id)VALUES(98,'高雄',34);
  INSERT INTO code_city(id,name,province_id)VALUES(99,'台中',34);
  INSERT INTO code_city(id,name,province_id)VALUES(100,'台南',34);
  INSERT INTO code_city(id,name,province_id)VALUES(101,'基隆',34);
  INSERT INTO code_city(id,name,province_id)VALUES(102,'新竹',34);

alexxiyang
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
中国各省市sql
04-05
中国各省市sql提供目前中国互联网上最前面的sql省市资料
2022年最新全国各省五级行政区划代码及mysql数据库代码（省市区县乡镇村）
web18334137065的博客
05-31 2万+
2022年最新全国各省五级行政区划代码及mysql数据库代码（省/市/区县/乡镇/村） “原创不易，如有遗漏请留言” 1、全国统计用区划代码和城乡划分代码更新维护的标准时点为2021年10月31日。 2、全国31省、多达 61W + 行数据。 3、mysql 数据结构： SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for town_zoning_code
最新省市区数据，sql插入语句
06-23 599
--省数据 insert into Province (ProvinceName) values('北京市'); insert into Province (ProvinceName) values('天津市'); insert into Province (ProvinceName) values('上海市'); insert into Province (Provinc...
中国所有城市名称.txt
05-10
中国所有城市名称，用空格隔开，txt文档，方便读取。
全国各地省市区分布数据库SQL文件数据库
11-23
全国各地省市区分布数据库SQL文件数据库
天气城市id
09-29
中国城市，天气网上的cityId，查询城市对应的id
全国省份城市区县表（sql版）
06-30
根据国家统计局网站上整理的全国省市区县，生成的SQL脚本 ；
中国省市区.txt
06-11
CREATE TABLE sys_city ( id int NOT NULL , areaname varchar(24) NULL , parentid int DEFAULT NULL, ) INSERT INTO sys_city VALUES ('110000', '北京市', '0'); INSERT INTO sys_city VALUES ('110101', '东城区', '110100'); INSERT INTO sys_city VALUES ('110102', '西城区', '110100'); INSERT INTO sys_city VALUES ('110105', '朝阳区', '110100'); INSERT INTO sys_city VALUES ('110106', '丰台区', '110100'); INSERT INTO sys_city VALUES ('110107', '石景山区', '110100'); INSERT INTO sys_city VALUES ('110108', '海淀区', '110100'); INSERT INTO sys_city VALUES ('110109', '门头沟区', '110100'); INSERT INTO sys_city VALUES ('110111', '房山区', '110100'); INSERT INTO sys_city VALUES ('110112', '通州区', '110100'); INSERT INTO sys_city VALUES ('110113', '顺义区', '110100'); INSERT INTO sys_city VALUES ('110114', '昌平区', '110100'); INSERT INTO sys_city VALUES ('110115', '大兴区', '110100'); INSERT INTO sys_city VALUES ('110116', '怀柔区', '110100'); INSERT INTO sys_city VALUES ('110117', '平谷区', '110100'); INSERT INTO sys_city VALUES ('110228', '密云区', '110200'); INSERT INTO sys_city VALUES ('110229', '延庆区', '110200'); INSERT INTO sys_city VALUES ('120000', '天津市', '0'); INSERT INTO sys_city VALUES ('120101', '和平区', '120100'); INSERT INTO sys_city VALUES ('120102', '河东区', '120100'); INSERT INTO sys_city VALUES ('120103', '河西区', '120100'); INSERT INTO sys_city VALUES ('120104', '南开区', '120100'); INSERT INTO sys_city VALUES ('120105', '河北区', '120100'); INSERT INTO sys_city VALUES ('120106', '红桥区', '120100'); INSERT INTO sys_city VALUES ('120110', '东丽区', '120100'); INSERT INTO sys_city VALUES ('120111', '西青区', '120100'); INSERT INTO sys_city VALUES ('120112', '津南区', '120100'); INSERT INTO sys_city VALUES ('120113', '北辰区', '120100'); INSERT INTO sys_city VALUES ('120114', '武清区', '120100'); INSERT INTO sys_city VALUES ('120115', '宝坻区', '120100'); INSERT INTO sys_city VALUES ('120116', '滨海新区', '120100'); INSERT INTO sys_city VALUES ('120221', '宁河区', '120200'); INSERT INTO sys_city VALUES ('120223', '静海区', '120200'); INSERT INTO sys_city VALUES ('120225', '蓟县', '120200'); INSERT INTO sys_city VALUES ('130000', '河北省', '0'); INSERT INTO sys_city VALUES ('130100', '石家庄市', '130000'); INSERT INTO sys_city VALUES ('130102', '长安区', '130100'); INSERT INTO sys_city VALUES ('130104', '桥西区', '130100'); INSERT INTO sys_city VALUES ('130105', '新华区', '130100'); INSERT INTO sys_city VALUES ('130107', '井陉矿区', '130100'); INSERT INTO sys_city VALUES ('130108', '裕华区', '130100'); INSERT INTO sys_city VALUES ('130109', '藁城区', '130100'); INSERT INTO sys_city VALUES ('130110', '鹿泉区', '130100'); INSERT INTO sys_city VALUES ('130111', '栾城区', '130100'); INSERT INTO sys_city VALUES ('130121', '井陉县', '130100'); INSERT INTO sys_city VALUES ('130123', '正定县', '130100'); INSERT INTO sys_city VALUES ('130125', '行唐县', '130100'); INSERT INTO sys_city VALUES ('130126', '灵寿县', '130100'); INSERT INTO sys_city VALUES ('130127', '高邑县', '130100'); INSERT INTO sys_city VALUES ('130128', '深泽县', '130100'); INSERT INTO sys_city VALUES ('130129', '赞皇县', '130100'); INSERT INTO sys_city VALUES ('130130', '无极县', '130100'); INSERT INTO sys_city VALUES ('130131', '平山县', '130100'); INSERT INTO sys_city VALUES ('130132', '元氏县', '130100'); INSERT INTO sys_city VALUES ('130133', '赵县', '130100'); INSERT INTO sys_city VALUES ('130181', '辛集市', '130100'); INSERT INTO sys_city VALUES ('130183', '晋州市', '130100'); INSERT INTO sys_city VALUES ('130184', '新乐市', '130100'); INSERT INTO sys_city VALUES ('130200', '唐山市', '130000'); INSERT INTO sys_city VALUES ('130202', '路南区', '130200'); INSERT INTO sys_city VALUES ('130203', '路北区', '130200'); INSERT INTO sys_city VALUES ('130204', '古冶区', '130200'); INSERT INTO sys_city VALUES ('130205', '开平区', '130200'); INSERT INTO sys_city VALUES ('130207', '丰南区', '130200'); INSERT INTO sys_city VALUES ('130208', '丰润区', '130200'); INSERT INTO sys_city VALUES ('130209', '曹妃甸区', '130200'); INSERT INTO sys_city VALUES ('130223', '滦县', '130200'); INSERT INTO sys_city VALUES ('130224', '滦南县', '130200'); INSERT INTO sys_city VALUES ('130225', '乐亭县', '130200'); INSERT INTO sys_city VALUES ('130227', '迁西县', '130200'); INSERT INTO sys_city VALUES ('130229', '玉田县', '130200'); INSERT INTO sys_city VALUES ('130281', '遵化市', '130200'); INSERT INTO sys_city VALUES ('130283', '迁安市', '130200'); INSERT INTO sys_city VALUES ('130300', '秦皇岛市', '130000'); INSERT INTO sys_city VALUES ('130302', '海港区', '130300'); INSERT INTO sys_city VALUES ('130303', '山海关区', '130300'); INSERT INTO sys_city VALUES ('130304', '北戴河区', '130300'); INSERT INTO sys_city VALUES ('130321', '青龙满族自治县', '130300'); INSERT INTO sys_city VALUES ('130322', '昌黎县', '130300'); INSERT INTO sys_city VALUES ('130323', '抚宁县', '130300'); INSERT INTO sys_city VALUES ('130324', '卢龙县', '130300'); INSERT INTO sys_city VALUES ('130400', '邯郸市', '130000'); INSERT INTO sys_city VALUES ('130402', '邯山区', '130400'); INSERT INTO sys_city VALUES ('130403', '丛台区', '130400'); INSERT INTO sys_city VALUES ('130404', '复兴区', '130400'); INSERT INTO sys_city VALUES ('130406', '峰峰矿区', '130400'); INSERT INTO sys_city VALUES ('130421', '邯郸县', '130400'); INSERT INTO sys_city VALUES ('130423', '临漳县', '130400'); INSERT INTO sys_city VALUES ('130424', '成安县', '130400'); INSERT INTO sys_city VALUES ('130425', '大名县', '130400'); INSERT INTO sys_city VALUES ('130426', '涉县', '130400'); INSERT INTO sys_city VALUES ('130427', '磁县', '130400'); INSERT INTO sys_city VALUES ('130428', '肥乡县', '130400'); INSERT INTO sys_city VALUES ('130429', '永年县', '130400'); INSERT INTO sys_city VALUES ('130430', '邱县', '130400'); INSERT INTO sys_city VALUES ('130431', '鸡泽县', '130400'); INSERT INTO sys_city VALUES ('130432', '广平县', '130400'); INSERT INTO sys_city VALUES ('130433', '馆陶县', '130400'); INSERT INTO sys_city VALUES ('130434', '魏县', '130400'); INSERT INTO sys_city VALUES ('130435', '曲周县', '130400'); INSERT INTO sys_city VALUES ('130481', '武安市', '130400'); INSERT INTO sys_city VALUES ('130500', '邢台市', '130000'); INSERT INTO sys_city VALUES ('130502', '桥东区', '130500'); INSERT INTO sys_city VALUES ('130503', '桥西区', '130500'); INSERT INTO sys_city VALUES ('130521', '邢台县', '130500'); INSERT INTO sys_city VALUES ('130522', '临城县', '130500'); INSERT INTO sys_city VALUES ('130523', '内丘县', '130500'); INSERT INTO sys_city VALUES ('130524', '柏乡县', '130500'); INSERT INTO sys_city VALUES ('130525', '隆尧县', '130500'); INSERT INTO sys_city VALUES ('130526', '任县', '130500'); INSERT INTO sys_city VALUES ('130527', '南和县', '130500'); INSERT INTO sys_city VALUES ('130528', '宁晋县', '130500'); INSERT INTO sys_city VALUES ('130529', '巨鹿县', '130500'); INSERT INTO sys_city VALUES ('130530', '新河县', '130500'); INSERT INTO sys_city VALUES ('130531', '广宗县', '130500'); INSERT INTO sys_city VALUES ('130532', '平乡县', '130500'); INSERT INTO sys_city VALUES ('130533', '威县', '130500'); INSERT INTO sys_city VALUES ('130534', '清河县', '130500'); INSERT INTO sys_city VALUES ('130535', '临西县', '130500'); INSERT INTO sys_city VALUES ('130581', '南宫市', '130500'); INSERT INTO sys_city VALUES ('130582', '沙河市', '130500'); INSERT INTO sys_city VALUES ('130600', '保定市', '130000'); INSERT INTO sys_city VALUES ('130602', '竞秀区', '130600'); INSERT INTO sys_city VALUES ('130604', '南市区', '130600'); INSERT INTO sys_city VALUES ('130606', '莲池区', '130600'); INSERT INTO sys_city VALUES ('130607', '满城区', '130600'); INSERT INTO sys_city VALUES ('130608', '清苑区', '130600'); INSERT INTO sys_city VALUES ('130609', '徐水区', '130600'); INSERT INTO sys_city VALUES ('130623', '涞水县', '130600'); INSERT INTO sys_city VALUES ('130624', '阜平县', '130600'); INSERT INTO sys_city VALUES ('130626', '定兴县', '130600'); INSERT INTO sys_city VALUES ('130627', '唐县', '130600'); INSERT INTO sys_city VALUES ('130628', '高阳县', '130600'); INSERT INTO sys_city VALUES ('130629', '容城县', '130600'); INSERT INTO sys_city VALUES ('130630', '涞源县', '130600'); INSERT INTO sys_city VALUES ('130631', '望都县', '130600'); INSERT INTO sys_city VALUES ('130632', '安新县', '130600'); INSERT INTO sys_city VALUES ('130633', '易县', '130600'); INSERT INTO sys_city VALUES ('130634', '曲阳县', '130600'); INSERT INTO sys_city VALUES ('130635', '蠡县', '130600'); INSERT INTO sys_city VALUES ('130636', '顺平县', '130600'); INSERT INTO sys_city VALUES ('130637', '博野县', '130600'); INSERT INTO sys_city VALUES ('130638', '雄县', '130600'); INSERT INTO sys_city VALUES ('130681', '涿州市', '130600'); INSERT INTO sys_city VALUES ('130682', '定州市', '130600'); INSERT INTO sys_city VALUES ('130683', '安国市', '130600'); INSERT INTO sys_city VALUES ('130684', '高碑店市', '130600'); INSERT INTO sys_city VALUES ('130700', '张家口市', '130000'); INSERT INTO sys_city VALUES ('130702', '桥东区', '130700'); INSERT INTO sys_city VALUES ('130703', '桥西区', '130700'); INSERT INTO sys_city VALUES ('130705', '宣化区', '130700'); INSERT INTO sys_city VALUES ('130706', '下花园区', '130700'); INSERT INTO sys_city VALUES ('130721', '宣化县', '130700'); INSERT INTO sys_city VALUES ('130722', '张北县', '130700'); INSERT INTO sys_city VALUES ('130723', '康保县', '130700'); INSERT INTO sys_city VALUES ('130724', '沽源县', '130700'); INSERT INTO sys_city VALUES ('130725', '尚义县', '130700'); INSERT INTO sys_city VALUES ('130726', '蔚县', '130700'); INSERT INTO sys_city VALUES ('130727', '阳原县', '130700'); INSERT INTO sys_city VALUES ('130728', '怀安县', '130700'); INSERT INTO sys_city VALUES ('130729', '万全县', '130700'); INSERT INTO sys_city VALUES ('130730', '怀来县', '130700'); INSERT INTO sys_city VALUES ('130731', '涿鹿县', '130700'); INSERT INTO sys_city VALUES ('130732', '赤城县', '130700'); INSERT INTO sys_city VALUES ('130733', '崇礼县', '130700'); INSERT INTO sys_city VALUES ('130800', '承德市', '130000'); INSERT INTO sys_city VALUES ('130802', '双桥区', '130800'); INSERT INTO sys_city VALUES ('130803', '双滦区', '130800'); INSERT INTO sys_city VALUES ('130804', '鹰手营子矿区', '130800'); INSERT INTO sys_city VALUES ('130821', '承德县', '130800'); INSERT INTO sys_city VALUES ('130822', '兴隆县', '130800'); INSERT INTO sys_city VALUES ('130823', '平泉县', '130800'); INSERT INTO sys_city VALUES ('130824', '滦平县', '130800'); INSERT INTO sys_city VALUES ('130825', '隆化县', '130800'); INSERT INTO sys_city VALUES ('130826', '丰宁满族自治县', '130800'); INSERT INTO sys_city VALUES ('130827', '宽城满族自治县', '130800'); INSERT INTO sys_city VALUES ('130828', '围场满族蒙古族自治县', '130800'); INSERT INTO sys_city VALUES ('130900', '沧州市', '130000'); INSERT INTO sys_city VALUES ('130902', '新华区', '130900'); INSERT INTO sys_city VALUES ('130903', '运河区', '130900'); INSERT INTO sys_city VALUES ('130921', '沧县', '130900'); INSERT INTO sys_city VALUES ('130922', '青县', '130900'); INSERT INTO sys_city VALUES ('130923', '东光县', '130900'); INSERT INTO sys_city VALUES ('130924', '海兴县', '130900'); INSERT INTO sys_city VALUES ('130925', '盐山县', '130900'); INSERT INTO sys_city VALUES ('130926', '肃宁县', '130900'); INSERT INTO sys_city VALUES ('130927', '南皮县', '130900'); INSERT INTO sys_city VALUES ('130928', '吴桥县', '130900'); INSERT INTO sys_city VALUES ('130929', '献县', '130900'); INSERT INTO sys_city VALUES ('130930', '孟村回族自治县', '130900'); INSERT INTO sys_city VALUES ('130981', '泊头市', '130900'); INSERT INTO sys_city VALUES ('130982', '任丘市', '130900'); INSERT INTO sys_city VALUES ('130983', '黄骅市', '130900'); INSERT INTO sys_city VALUES ('130984', '河间市', '130900'); INSERT INTO sys_city VALUES ('131000', '廊坊市', '130000'); INSERT INTO sys_city VALUES ('131002', '安次区', '131000'); INSERT INTO sys_city VALUES ('131003', '广阳区', '131000'); INSERT INTO sys_city VALUES ('131022', '固安县', '131000'); INSERT INTO sys_city VALUES ('131023', '永清县', '131000'); INSERT INTO sys_city VALUES ('131024', '香河县', '131000'); INSERT INTO sys_city VALUES ('131025', '大城县', '131000'); INSERT INTO sys_city VALUES ('131026', '文安县', '131000'); INSERT INTO sys_city VALUES ('131028', '大厂回族自治县', '131000'); INSERT INTO sys_city VALUES ('131081', '霸州市', '131000'); INSERT INTO sys_city VALUES ('131082', '三河市', '131000'); INSERT INTO sys_city VALUES ('131100', '衡水市', '130000'); INSERT INTO sys_city VALUES ('131102', '桃城区', '131100'); INSERT INTO sys_city VALUES ('131121', '枣强县', '131100'); INSERT INTO sys_city VALUES ('131122', '武邑县', '131100'); INSERT INTO sys_city VALUES ('131123', '武强县', '131100'); INSERT INTO sys_city VALUES ('131124', '饶阳县', '131100'); INSERT INTO sys_city VALUES ('131125', '安平县', '131100'); INSERT INTO sys_city VALUES ('131126', '故城县', '131100'); INSERT INTO sys_city VALUES ('131127', '景县', '131100'); INSERT INTO sys_city VALUES ('131128', '阜城县', '131100'); INSERT INTO sys_city VALUES ('131181', '冀州市', '131100'); INSERT INTO sys_city VALUES ('131182', '深州市', '131100'); INSERT INTO sys_city VALUES ('140000', '山西省', '0'); INSERT INTO sys_city VALUES ('140100', '太原市', '140000'); INSERT INTO sys_city VALUES ('140105', '小店区', '140100'); INSERT INTO sys_city VALUES ('140106', '迎泽区', '140100'); INSERT INTO sys_city VALUES ('140107', '杏花岭区', '140100'); INSERT INTO sys_city VALUES ('140108', '尖草坪区', '140100'); INSERT INTO sys_city VALUES ('140109', '万柏林区', '140100'); INSERT INTO sys_city VALUES ('140110', '晋源区', '140100'); INSERT INTO sys_city VALUES ('140121', '清徐县', '140100'); INSERT INTO sys_city VALUES ('140122', '阳曲县', '140100'); INSERT INTO sys_city VALUES ('140123', '娄烦县', '140100'); INSERT INTO sys_city VALUES ('140181', '古交市', '140100'); INSERT INTO sys_city VALUES ('140200', '大同市', '140000'); INSERT INTO sys_city VALUES ('140202', '城区', '140200'); INSERT INTO sys_city VALUES ('140203', '矿区', '140200'); INSERT INTO sys_city VALUES ('140211', '南郊区', '140200'); INSERT INTO sys_city VALUES ('140212', '新荣区', '140200'); INSERT INTO sys_city VALUES ('140221', '阳高县', '140200'); INSERT INTO sys_city VALUES ('140222', '天镇县', '140200'); INSERT INTO sys_city VALUES ('140223', '广灵县', '140200'); INSERT INTO sys_city VALUES ('140224', '灵丘县', '140200'); INSERT INTO sys_city VALUES ('140225', '浑源县', '140200'); INSERT INTO sys_city VALUES ('140226', '左云县', '140200'); INSERT INTO sys_city VALUES ('140227', '大同县', '140200'); INSERT INTO sys_city VALUES ('140300', '阳泉市', '140000'); INSERT INTO sys_city VALUES ('140302', '城区', '140300'); INSERT INTO sys_city VALUES ('140303', '矿区', '140300'); INSERT INTO sys_city VALUES ('140311', '郊区', '140300'); INSERT INTO sys_city VALUES ('140321', '平定县', '140300'); INSERT INTO sys_city VALUES ('140322', '盂县', '140300'); INSERT INTO sys_city VALUES ('140400', '长治市', '140000'); INSERT INTO sys_city VALUES ('140402', '城区', '140400'); INSERT INTO sys_city VALUES ('140411', '郊区', '140400'); INSERT INTO sys_city VALUES ('140421', '长治县', '140400'); INSERT INTO sys_city VALUES ('140423', '襄垣县', '140400'); INSERT INTO sys_city VALUES ('140424', '屯留县', '140400'); INSERT INTO sys_city VALUES ('140425', '平顺县', '140400'); INSERT INTO sys_city VALUES ('140426', '黎城县', '140400'); INSERT INTO sys_city VALUES ('140427', '壶关县', '140400'); INSERT INTO sys_city VALUES ('140428', '长子县', '140400'); INSERT INTO sys_city VALUES ('140429', '武乡县', '140400'); INSERT INTO sys_city VALUES ('140430', '沁县', '140400'); INSERT INTO sys_city VALUES ('140431', '沁源县', '140400'); INSERT INTO sys_city VALUES ('140481', '潞城市', '140400'); INSERT INTO sys_city VALUES ('140500', '晋城市', '140000'); INSERT INTO sys_city VALUES ('140502', '城区', '140500'); INSERT INTO sys_city VALUES ('140521', '沁水县', '140500'); INSERT INTO sys_city VALUES ('140522', '阳城县', '140500'); INSERT INTO sys_city VALUES ('140524', '陵川县', '140500'); INSERT INTO sys_city VALUES ('140525', '泽州县', '140500'); INSERT INTO sys_city VALUES ('140581', '高平市', '140500'); INSERT INTO sys_city VALUES ('140600', '朔州市', '140000'); INSERT INTO sys_city VALUES ('140602', '朔城区', '140600'); INSERT INTO sys_city VALUES ('140603', '平鲁区', '140600'); INSERT INTO sys_city VALUES ('140621', '山阴县', '140600'); INSERT INTO sys_city VALUES ('140622', '应县', '140600'); INSERT INTO sys_city VALUES ('140623', '右玉县', '140600'); INSERT INTO sys_city VALUES ('140624', '怀仁县', '140600'); INSERT INTO sys_city VALUES ('140700', '晋中市', '140000'); INSERT INTO sys_city VALUES ('140702', '榆次区', '140700'); INSERT INTO sys_city VALUES ('140721', '榆社县', '140700'); INSERT INTO sys_city VALUES ('140722', '左权县', '140700'); INSERT INTO sys_city VALUES ('140723', '和顺县', '140700'); INSERT INTO sys_city VALUES ('140724', '昔阳县', '140700'); INSERT INTO sys_city VALUES ('140725', '寿阳县', '140700'); INSERT INTO sys_city VALUES ('140726', '太谷县', '140700'); INSERT INTO sys_city VALUES ('140727', '祁县', '140700'); INSERT INTO sys_city VALUES ('140728', '平遥县', '140700'); INSERT INTO sys_city VALUES ('140729', '灵石县', '140700'); INSERT INTO sys_city VALUES ('140781', '介休市', '140700'); INSERT INTO sys_city VALUES ('140800', '运城市', '140000'); INSERT INTO sys_city VALUES ('140802', '盐湖区', '140800'); INSERT INTO sys_city VALUES ('140821', '临猗县', '140800'); INSERT INTO sys_city VALUES ('140822', '万荣县', '140800'); INSERT INTO sys_city VALUES ('140823', '闻喜县', '140800'); INSERT INTO sys_city VALUES ('140824', '稷山县', '140800'); INSERT INTO sys_city VALUES ('140825', '新绛县', '140800'); INSERT INTO sys_city VALUES ('140826', '绛县', '140800'); INSERT INTO sys_city VALUES ('140827', '垣曲县', '140800'); INSERT INTO sys_city VALUES ('140828', '夏县', '140800'); INSERT INTO sys_city VALUES ('140829', '平陆县', '140800'); INSERT INTO sys_city VALUES ('140830', '芮城县', '140800'); INSERT INTO sys_city VALUES ('140881', '永济市', '140800'); INSERT INTO sys_city VALUES ('140882', '河津市', '140800'); INSERT INTO sys_city VALUES ('140900', '忻州市', '140000'); INSERT INTO sys_city VALUES ('140902', '忻府区', '140900'); INSERT INTO sys_city VALUES ('140921', '定襄县', '140900'); INSERT INTO sys_city VALUES ('140922', '五台县', '140900'); INSERT INTO sys_city VALUES ('140923', '代县', '140900'); INSERT INTO sys_city VALUES ('140924', '繁峙县', '140900'); INSERT INTO sys_city VALUES ('140925', '宁武县', '140900'); INSERT INTO sys_city VALUES ('140926', '静乐县', '140900'); INSERT INTO sys_city VALUES ('140927', '神池县', '140900'); INSERT INTO sys_city VALUES ('140928', '五寨县', '140900'); INSERT INTO sys_city VALUES ('140929', '岢岚县', '140900'); INSERT INTO sys_city VALUES ('140930', '河曲县', '140900'); INSERT INTO sys_city VALUES ('140931', '保德县', '140900'); INSERT INTO sys_city VALUES ('140932', '偏关县', '140900'); INSERT INTO sys_city VALUES ('140981', '原平市', '140900'); INSERT INTO sys_city VALUES ('141000', '临汾市', '140000'); INSERT INTO sys_city VALUES ('141002', '尧都区', '141000'); INSERT INTO sys_city VALUES ('141021', '曲沃县', '141000'); INSERT INTO sys_city VALUES ('141022', '翼城县', '141000'); INSERT INTO sys_city VALUES ('141023', '襄汾县', '141000'); INSERT INTO sys_city VALUES ('141024', '洪洞县', '141000'); INSERT INTO sys_city VALUES ('141025', '古县', '141000'); INSERT INTO sys_city VALUES ('141026', '安泽县', '141000'); INSERT INTO sys_city VALUES ('141027', '浮山县', '141000'); INSERT INTO sys_city VALUES ('141028', '吉县', '141000'); INSERT INTO sys_city VALUES ('141029', '乡宁县', '141000'); INSERT INTO sys_city VALUES ('141030', '大宁县', '141000'); INSERT INTO sys_city VALUES ('141031', '隰县', '141000'); INSERT INTO sys_city VALUES ('141032', '永和县', '141000'); INSERT INTO sys_city VALUES ('141033', '蒲县', '141000'); INSERT INTO sys_city VALUES ('141034', '汾西县', '141000'); INSERT INTO sys_city VALUES ('141081', '侯马市', '141000'); INSERT INTO sys_city VALUES ('141082', '霍州市', '141000'); INSERT INTO sys_city VALUES ('141100', '吕梁市', '140000'); INSERT INTO sys_city VALUES ('141102', '离石区', '141100'); INSERT INTO sys_city VALUES ('141121', '文水县', '141100'); INSERT INTO sys_city VALUES ('141122', '交城县', '141100'); INSERT INTO sys_city VALUES ('141123', '兴县', '141100'); INSERT INTO sys_city VALUES ('141124', '临县', '141100'); INSERT INTO sys_city VALUES ('141125', '柳林县', '141100'); INSERT INTO sys_city VALUES ('141126', '石楼县', '141100'); INSERT INTO sys_city VALUES ('141127', '岚县', '141100'); INSERT INTO sys_city VALUES ('141128', '方山县', '141100'); INSERT INTO sys_city VALUES ('141129', '中阳县', '141100'); INSERT INTO sys_city VALUES ('141130', '交口县', '141100'); INSERT INTO sys_city VALUES ('141181', '孝义市', '141100'); INSERT INTO sys_city VALUES ('141182', '汾阳市', '141100'); INSERT INTO sys_city VALUES ('150000', '内蒙古自治区', '0'); INSERT INTO sys_city VALUES ('150100', '呼和浩特市', '150000'); INSERT INTO sys_city VALUES ('150102', '新城区', '150100'); INSERT INTO sys_city VALUES ('150103', '回民区', '150100'); INSERT INTO sys_city VALUES ('150104', '玉泉区', '150100'); INSERT INTO sys_city VALUES ('150105', '赛罕区', '150100'); INSERT INTO sys_city VALUES ('150121', '土默特左旗', '150100'); INSERT INTO sys_city VALUES ('150122', '托克托县', '150100'); INSERT INTO sys_city VALUES ('150123', '和林格尔县', '150100'); INSERT INTO sys_city VALUES ('150124', '清水河县', '150100'); INSERT INTO sys_city VALUES ('150125', '武川县', '150100'); INSERT INTO sys_city VALUES ('150200', '包头市', '150000'); INSERT INTO sys_city VALUES ('150202', '东河区', '150200'); INSERT INTO sys_city VALUES ('150203', '昆都仑区', '150200'); INSERT INTO sys_city VALUES ('150204', '青山区', '150200'); INSERT INTO sys_city VALUES ('150205', '石拐区', '150200'); INSERT INTO sys_city VALUES ('150206', '白云鄂博矿区', '150200'); INSERT INTO sys_city VALUES ('150207', '九原区', '150200'); INSERT INTO sys_city VALUES ('150221', '土默特右旗', '150200'); INSERT INTO sys_city VALUES ('150222', '固阳县', '150200'); INSERT INTO sys_city VALUES ('150223', '达尔罕茂明安联合旗', '150200'); INSERT INTO sys_city VALUES ('150300', '乌海市', '150000'); INSERT INTO sys_city VALUES ('150302', '海勃湾区', '150300'); INSERT INTO sys_city VALUES ('150303', '海南区', '150300'); INSERT INTO sys_city VALUES ('150304', '乌达区', '150300'); INSERT INTO sys_city VALUES ('150400', '赤峰市', '150000'); INSERT INTO sys_city VALUES ('150402', '红山区', '150400'); INSERT INTO sys_city VALUES ('150403', '元宝山区', '150400'); INSERT INTO sys_city VALUES ('150404', '松山区', '150400'); INSERT INTO sys_city VALUES ('150421', '阿鲁科尔沁旗', '150400'); INSERT INTO sys_city VALUES ('150422', '巴林左旗', '150400'); INSERT INTO sys_city VALUES ('150423', '巴林右旗', '150400'); INSERT INTO sys_city VALUES ('150424', '林西县', '150400'); INSERT INTO sys_city VALUES ('150425', '克什克腾旗', '150400'); INSERT INTO sys_city VALUES ('150426', '翁牛特旗', '150400'); INSERT INTO sys_city VALUES ('150428', '喀喇沁旗', '150400'); INSERT INTO sys_city VALUES ('150429', '宁城县', '150400'); INSERT INTO sys_city VALUES ('150430', '敖汉旗', '150400'); INSERT INTO sys_city VALUES ('150500', '通辽市', '150000'); INSERT INTO sys_city VALUES ('150502', '科尔沁区', '150500'); INSERT INTO sys_city VALUES ('150521', '科尔沁左翼中旗', '150500'); INSERT INTO sys_city VALUES ('150522', '科尔沁左翼后旗', '150500'); INSERT INTO sys_city VALUES ('150523', '开鲁县', '150500'); INSERT INTO sys_city VALUES ('150524', '库伦旗', '150500'); INSERT INTO sys_city VALUES ('150525', '奈曼旗', '150500'); INSERT INTO sys_city VALUES ('150526', '扎鲁特旗', '150500'); INSERT INTO sys_city VALUES ('150581', '霍林郭勒市', '150500'); INSERT INTO sys_city VALUES ('150600', '鄂尔多斯市', '150000'); INSERT INTO sys_city VALUES ('150602', '东胜区', '150600'); INSERT INTO sys_city VALUES ('150621', '达拉特旗', '150600'); INSERT INTO sys_city VALUES ('150622', '准格尔旗', '150600'); INSERT INTO sys_city VALUES ('150623', '鄂托克前旗', '150600'); INSERT INTO sys_city VALUES ('150624', '鄂托克旗', '150600'); INSERT INTO sys_city VALUES ('150625', '杭锦旗', '150600'); INSERT INTO sys_city VALUES ('150626', '乌审旗', '150600'); INSERT INTO sys_city VALUES ('150627', '伊金霍洛旗', '150600'); INSERT INTO sys_city VALUES ('150700', '呼伦贝尔市', '150000'); INSERT INTO sys_city VALUES ('150702', '海拉尔区', '150700'); INSERT INTO sys_city VALUES ('150703', '扎赉诺尔区', '150700'); INSERT INTO sys_city VALUES ('150721', '阿荣旗', '150700'); INSERT INTO sys_city VALUES ('150722', '莫力达瓦达斡尔族自治旗', '150700'); INSERT INTO sys_city VALUES ('150723', '鄂伦春自治旗', '150700'); INSERT INTO sys_city VALUES ('150724', '鄂温克族自治旗', '150700'); INSERT INTO sys_city VALUES ('150725', '陈巴尔虎旗', '150700'); INSERT INTO sys_city VALUES ('150726', '新巴尔虎左旗', '150700'); INSERT INTO sys_city VALUES ('150727', '新巴尔虎右旗', '150700'); INSERT INTO sys_city VALUES ('150781', '满洲里市', '150700'); INSERT INTO sys_city VALUES ('150782', '牙克石市', '150700'); INSERT INTO sys_city VALUES ('150783', '扎兰屯市', '150700'); INSERT INTO sys_city VALUES ('150784', '额尔古纳市', '150700'); INSERT INTO sys_city VALUES ('150785', '根河市', '150700'); INSERT INTO sys_city VALUES ('150800', '巴彦淖尔市', '150000'); INSERT INTO sys_city VALUES ('150802', '临河区', '150800'); INSERT INTO sys_city VALUES ('150821', '五原县', '150800'); INSERT INTO sys_city VALUES ('150822', '磴口县', '150800'); INSERT INTO sys_city VALUES ('150823', '乌拉特前旗', '150800'); INSERT INTO sys_city VALUES ('150824', '乌拉特中旗', '150800'); INSERT INTO sys_city VALUES ('150825', '乌拉特后旗', '150800'); INSERT INTO sys_city VALUES ('150826', '杭锦后旗', '150800'); INSERT INTO sys_city VALUES ('150900', '乌兰察布市', '150000'); INSERT INTO sys_city VALUES ('150902', '集宁区', '150900'); INSERT INTO sys_city VALUES ('150921', '卓资县', '150900'); INSERT INTO sys_city VALUES ('150922', '化德县', '150900'); INSERT INTO sys_city VALUES ('150923', '商都县', '150900'); INSERT INTO sys_city VALUES ('150924', '兴和县', '150900'); INSERT INTO sys_city VALUES ('150925', '凉城县', '150900'); INSERT INTO sys_city VALUES ('150926', '察哈尔右翼前旗', '150900'); INSERT INTO sys_city VALUES ('150927', '察哈尔右翼中旗', '150900'); INSERT INTO sys_city VALUES ('150928', '察哈尔右翼后旗', '150900'); INSERT INTO sys_city VALUES ('150929', '四子王旗', '150900'); INSERT INTO sys_city VALUES ('150981', '丰镇市', '150900'); INSERT INTO sys_city VALUES ('152200', '兴安盟', '150000'); INSERT INTO sys_city VALUES ('152201', '乌兰浩特市', '152200'); INSERT INTO sys_city VALUES ('152202', '阿尔山市', '152200'); INSERT INTO sys_city VALUES ('152221', '科尔沁右翼前旗', '152200'); INSERT INTO sys_city VALUES ('152222', '科尔沁右翼中旗', '152200'); INSERT INTO sys_city VALUES ('152223', '扎赉特旗', '152200'); INSERT INTO sys_city VALUES ('152224', '突泉县', '152200'); INSERT INTO sys_city VALUES ('152500', '锡林郭勒盟', '150000'); INSERT INTO sys_city VALUES ('152501', '二连浩特市', '152500'); INSERT INTO sys_city VALUES ('152502', '锡林浩特市', '152500'); INSERT INTO sys_city VALUES ('152522', '阿巴嘎旗', '152500'); INSERT INTO sys_city VALUES ('152523', '苏尼特左旗', '152500'); INSERT INTO sys_city VALUES ('152524', '苏尼特右旗', '152500'); INSERT INTO sys_city VALUES ('152525', '东乌珠穆沁旗', '152500'); INSERT INTO sys_city VALUES ('152526', '西乌珠穆沁旗', '152500'); INSERT INTO sys_city VALUES ('152527', '太仆寺旗', '152500'); INSERT INTO sys_city VALUES ('152528', '镶黄旗', '152500'); INSERT INTO sys_city VALUES ('152529', '正镶白旗', '152500'); INSERT INTO sys_city VALUES ('152530', '正蓝旗', '152500'); INSERT INTO sys_city VALUES ('152531', '多伦县', '152500'); INSERT INTO sys_city VALUES ('152900', '阿拉善盟', '150000'); INSERT INTO sys_city VALUES ('152921', '阿拉善左旗', '152900'); INSERT INTO sys_city VALUES ('152922', '阿拉善右旗', '152900'); INSERT INTO sys_city VALUES ('152923', '额济纳旗', '152900'); INSERT INTO sys_city VALUES ('210000', '辽宁省', '0'); INSERT INTO sys_city VALUES ('210100', '沈阳市', '210000'); INSERT INTO sys_city VALUES ('210102', '和平区', '210100'); INSERT INTO sys_city VALUES ('210103', '沈河区', '210100'); INSERT INTO sys_city VALUES ('210104', '大东区', '210100'); INSERT INTO sys_city VALUES ('210105', '皇姑区', '210100'); INSERT INTO sys_city VALUES ('210106', '铁西区', '210100'); INSERT INTO sys_city VALUES ('210111', '苏家屯区', '210100'); INSERT INTO sys_city VALUES ('210112', '东陵区', '210100'); INSERT INTO sys_city VALUES ('210113', '沈北新区', '210100'); INSERT INTO sys_city VALUES ('210114', '于洪区', '210100'); INSERT INTO sys_city VALUES ('210122', '辽中县', '210100'); INSERT INTO sys_city VALUES ('210123', '康平县', '210100'); INSERT INTO sys_city VALUES ('210124', '法库县', '210100'); INSERT INTO sys_city VALUES ('210181', '新民市', '210100'); INSERT INTO sys_city VALUES ('210200', '大连市', '210000'); INSERT INTO sys_city VALUES ('210202', '中山区', '210200'); INSERT INTO sys_city VALUES ('210203', '西岗区', '210200'); INSERT INTO sys_city VALUES ('210204', '沙河口区', '210200'); INSERT INTO sys_city VALUES ('210211', '甘井子区', '210200'); INSERT INTO sys_city VALUES ('210212', '旅顺口区', '210200'); INSERT INTO sys_city VALUES ('210213', '金州区', '210200'); INSERT INTO sys_city VALUES ('210224', '长海县', '210200'); INSERT INTO sys_city VALUES ('210281', '瓦房店市', '210200'); INSERT INTO sys_city VALUES ('210282', '普兰店市', '210200'); INSERT INTO sys_city VALUES ('210283', '庄河市', '210200'); INSERT INTO sys_city VALUES ('210300', '鞍山市', '210000'); INSERT INTO sys_city VALUES ('210302', '铁东区', '210300'); INSERT INTO sys_city VALUES ('210303', '铁西区', '210300'); INSERT INTO sys_city VALUES ('210304', '立山区', '210300'); INSERT INTO sys_city VALUES ('210311', '千山区', '210300'); INSERT INTO sys_city VALUES ('210321', '台安县', '210300'); INSERT INTO sys_city VALUES ('210323', '岫岩满族自治县', '210300'); INSERT INTO sys_city VALUES ('210381', '海城市', '210300'); INSERT INTO sys_city VALUES ('210400', '抚顺市', '210000'); INSERT INTO sys_city VALUES ('210402', '新抚区', '210400'); INSERT INTO sys_city VALUES ('210403', '东洲区', '210400'); INSERT INTO sys_city VALUES ('210404', '望花区', '210400'); INSERT INTO sys_city VALUES ('210411', '顺城区', '210400'); INSERT INTO sys_city VALUES ('210421', '抚顺县', '210400'); INSERT INTO sys_city VALUES ('210422', '新宾满族自治县', '210400'); INSERT INTO sys_city VALUES ('210423', '清原满族自治县', '210400'); INSERT INTO sys_city VALUES ('210500', '本溪市', '210000'); INSERT INTO sys_city VALUES ('210502', '平山区', '210500'); INSERT INTO sys_city VALUES ('210503', '溪湖区', '210500'); INSERT INTO sys_city VALUES ('210504', '明山区', '210500'); INSERT INTO sys_city VALUES ('210505', '南芬区', '210500'); INSERT INTO sys_city VALUES ('210521', '本溪满族自治县', '210500'); INSERT INTO sys_city VALUES ('210522', '桓仁满族自治县', '210500'); INSERT INTO sys_city VALUES ('210600', '丹东市', '210000'); INSERT INTO sys_city VALUES ('210602', '元宝区', '210600'); INSERT INTO sys_city VALUES ('210603', '振兴区', '210600'); INSERT INTO sys_city VALUES ('210604', '振安区', '210600'); INSERT INTO sys_city VALUES ('210624', '宽甸满族自治县', '210600'); INSERT INTO sys_city VALUES ('210681', '东港市', '210600'); INSERT INTO sys_city VALUES ('210682', '凤城市', '210600'); INSERT INTO sys_city VALUES ('210700', '锦州市', '210000'); INSERT INTO sys_city VALUES ('210702', '古塔区', '210700'); INSERT INTO sys_city VALUES ('210703', '凌河区', '210700'); INSERT INTO sys_city VALUES ('210711', '太和区', '210700'); INSERT INTO sys_city VALUES ('210726', '黑山县', '210700'); INSERT INTO sys_city VALUES ('210727', '义县', '210700'); INSERT INTO sys_city VALUES ('210781', '凌海市', '210700'); INSERT INTO sys_city VALUES ('210782', '北镇市', '210700'); INSERT INTO sys_city VALUES ('210800', '营口市', '210000'); INSERT INTO sys_city VALUES ('210802', '站前区', '210800'); INSERT INTO sys_city VALUES ('210803', '西市区', '210800'); INSERT INTO sys_city VALUES ('210804', '鲅鱼圈区', '210800'); INSERT INTO sys_city VALUES ('210811', '老边区', '210800'); INSERT INTO sys_city VALUES ('210881', '盖州市', '210800'); INSERT INTO sys_city VALUES ('210882', '大石桥市', '210800'); INSERT INTO sys_city VALUES ('210900', '阜新市', '210000'); INSERT INTO sys_city VALUES ('210902', '海州区', '210900'); INSERT INTO sys_city VALUES ('210903', '新邱区', '210900'); INSERT INTO sys_city VALUES ('210904', '太平区', '210900'); INSERT INTO sys_city VALUES ('210905', '清河门区', '210900'); INSERT INTO sys_city VALUES ('210911', '细河区', '210900'); INSERT INTO sys_city VALUES ('210921', '阜新蒙古族自治县', '210900'); INSERT INTO sys_city VALUES ('210922', '彰武县', '210900'); INSERT INTO sys_city VALUES ('211000', '辽阳市', '210000'); INSERT INTO sys_city VALUES ('211002', '白塔区', '211000'); INSERT INTO sys_city VALUES ('211003', '文圣区', '211000'); INSERT INTO sys_city VALUES ('211004', '宏伟区', '211000'); INSERT INTO sys_city VALUES ('211005', '弓长岭区', '211000'); INSERT INTO sys_city VALUES ('211011', '太子河区', '211000'); INSERT INTO sys_city VALUES ('211021', '辽阳县', '211000'); INSERT INTO sys_city VALUES ('211081', '灯塔市', '211000'); INSERT INTO sys_city VALUES ('211100', '盘锦市', '210000'); INSERT INTO sys_city VALUES ('211102', '双台子区', '211100'); INSERT INTO sys_city VALUES ('211103', '兴隆台区', '211100'); INSERT INTO sys_city VALUES ('211121', '大洼县', '211100'); INSERT INTO sys_city VALUES ('211122', '盘山县', '211100'); INSERT INTO sys_city VALUES ('211200', '铁岭市', '210000'); INSERT INTO sys_city VALUES ('211202', '银州区', '211200'); INSERT INTO sys_city VALUES ('211204', '清河区', '211200'); INSERT INTO sys_city VALUES ('211221', '铁岭县', '211200'); INSERT INTO sys_city VALUES ('211223', '西丰县', '211200'); INSERT INTO sys_city VALUES ('211224', '昌图县', '211200'); INSERT INTO sys_city VALUES ('211281', '调兵山市', '211200'); INSERT INTO sys_city VALUES ('211282', '开原市', '211200'); INSERT INTO sys_city VALUES ('211300', '朝阳市', '210000'); INSERT INTO sys_city VALUES ('211302', '双塔区', '211300'); INSERT INTO sys_city VALUES ('211303', '龙城区', '211300'); INSERT INTO sys_city VALUES ('211321', '朝阳县', '211300'); INSERT INTO sys_city VALUES ('211322', '建平县', '211300'); INSERT INTO sys_city VALUES ('211324', '喀喇沁左翼蒙古族自治县', '211300'); INSERT INTO sys_city VALUES ('211381', '北票市', '211300'); INSERT INTO sys_city VALUES ('211382', '凌源市', '211300'); INSERT INTO sys_city VALUES ('211400', '葫芦岛市', '210000'); INSERT INTO sys_city VALUES ('211402', '连山区', '211400'); INSERT INTO sys_city VALUES ('211403', '龙港区', '211400'); INSERT INTO sys_city VALUES ('211404', '南票区', '211400'); INSERT INTO sys_city VALUES ('211421', '绥中县', '211400'); INSERT INTO sys_city VALUES ('211422', '建昌县', '211400'); INSERT INTO sys_city VALUES ('211481', '兴城市', '211400'); INSERT INTO sys_city VALUES ('220000', '吉林省', '0'); INSERT INTO sys_city VALUES ('220100', '长春市', '220000'); INSERT INTO sys_city VALUES ('220102', '南关区', '220100'); INSERT INTO sys_city VALUES ('220103', '宽城区', '220100'); INSERT INTO sys_city VALUES ('220104', '朝阳区', '220100'); INSERT INTO sys_city VALUES ('220105', '二道区', '220100'); INSERT INTO sys_city VALUES ('220106', '绿园区', '220100'); INSERT INTO sys_city VALUES ('220112', '双阳区', '220100'); INSERT INTO sys_city VALUES ('220113', '九台区', '220100'); INSERT INTO sys_city VALUES ('220122', '农安县', '220100'); INSERT INTO sys_city VALUES ('220182', '榆树市', '220100'); INSERT INTO sys_city VALUES ('220183', '德惠市', '220100'); INSERT INTO sys_city VALUES ('220200', '吉林市', '220000'); INSERT INTO sys_city VALUES ('220202', '昌邑区', '220200'); INSERT INTO sys_city VALUES ('220203', '龙潭区', '220200'); INSERT INTO sys_city VALUES ('220204', '船营区', '220200'); INSERT INTO sys_city VALUES ('220211', '丰满区', '220200'); INSERT INTO sys_city VALUES ('220221', '永吉县', '220200'); INSERT INTO sys_city VALUES ('220281', '蛟河市', '220200'); INSERT INTO sys_city VALUES ('220282', '桦甸市', '220200'); INSERT INTO sys_city VALUES ('220283', '舒兰市', '220200'); INSERT INTO sys_city VALUES ('220284', '磐石市', '220200'); INSERT INTO sys_city VALUES ('220300', '四平市', '220000'); INSERT INTO sys_city VALUES ('220302', '铁西区', '220300'); INSERT INTO sys_city VALUES ('220303', '铁东区', '220300'); INSERT INTO sys_city VALUES ('220322', '梨树县', '220300'); INSERT INTO sys_city VALUES ('220323', '伊通满族自治县', '220300'); INSERT INTO sys_city VALUES ('220381', '公主岭市', '220300'); INSERT INTO sys_city VALUES ('220382', '双辽市', '220300'); INSERT INTO sys_city VALUES ('220400', '辽源市', '220000'); INSERT INTO sys_city VALUES ('220402', '龙山区', '220400'); INSERT INTO sys_city VALUES ('220403', '西安区', '220400'); INSERT INTO sys_city VALUES ('220421', '东丰县', '220400'); INSERT INTO sys_city VALUES ('220422', '东辽县', '220400'); INSERT INTO sys_city VALUES ('220500', '通化市', '220000'); INSERT INTO sys_city VALUES ('220502', '东昌区', '220500'); INSERT INTO sys_city VALUES ('220503', '二道江区', '220500'); INSERT INTO sys_city VALUES ('220521', '通化县', '220500'); INSERT INTO sys_city VALUES ('220523', '辉南县', '220500'); INSERT INTO sys_city VALUES ('220524', '柳河县', '220500'); INSERT INTO sys_city VALUES ('220581', '梅河口市', '220500'); INSERT INTO sys_city VALUES ('220582', '集安市', '220500'); INSERT INTO sys_city VALUES ('220600', '白山市', '220000'); INSERT INTO sys_city VALUES ('220602', '浑江区', '220600'); INSERT INTO sys_city VALUES ('220605', '江源区', '220600'); INSERT INTO sys_city VALUES ('220621', '抚松县', '220600'); INSERT INTO sys_city VALUES ('220622', '靖宇县', '220600'); INSERT INTO sys_city VALUES ('220623', '长白朝鲜族自治县', '220600'); INSERT INTO sys_city VALUES ('220681', '临江市', '220600'); INSERT INTO sys_city VALUES ('220700', '松原市', '220000'); INSERT INTO sys_city VALUES ('220702', '宁江区', '220700'); INSERT INTO sys_city VALUES ('220721', '前郭尔罗斯蒙古族自治县', '220700'); INSERT INTO sys_city VALUES ('220722', '长岭县', '220700'); INSERT INTO sys_city VALUES ('220723', '乾安县', '220700'); INSERT INTO sys_city VALUES ('220781', '扶余市', '220700'); INSERT INTO sys_city VALUES ('220800', '白城市', '220000'); INSERT INTO sys_city VALUES ('220802', '洮北区', '220800'); INSERT INTO sys_city VALUES ('220821', '镇赉县', '220800'); INSERT INTO sys_city VALUES ('220822', '通榆县', '220800'); INSERT INTO sys_city VALUES ('220881', '洮南市', '220800'); INSERT INTO sys_city VALUES ('220882', '大安市', '220800'); INSERT INTO sys_city VALUES ('222400', '延边朝鲜族自治州', '220000'); INSERT INTO sys_city VALUES ('222401', '延吉市', '222400'); INSERT INTO sys_city VALUES ('222402', '图们市', '222400'); INSERT INTO sys_city VALUES ('222403', '敦化市', '222400'); INSERT INTO sys_city VALUES ('222404', '珲春市', '222400'); INSERT INTO sys_city VALUES ('222405', '龙井市', '222400'); INSERT INTO sys_city VALUES ('222406', '和龙市', '222400'); INSERT INTO sys_city VALUES ('222424', '汪清县', '222400'); INSERT INTO sys_city VALUES ('222426', '安图县', '222400'); INSERT INTO sys_city VALUES ('230000', '黑龙江省', '0'); INSERT INTO sys_city VALUES ('230100', '哈尔滨市', '230000'); INSERT INTO sys_city VALUES ('230102', '道里区', '230100'); INSERT INTO sys_city VALUES ('230103', '南岗区', '230100'); INSERT INTO sys_city VALUES ('230104', '道外区', '230100'); INSERT INTO sys_city VALUES ('230108', '平房区', '230100'); INSERT INTO sys_city VALUES ('230109', '松北区', '230100'); INSERT INTO sys_city VALUES ('230110', '香坊区', '230100'); INSERT INTO sys_city VALUES ('230111', '呼兰区', '230100'); INSERT INTO sys_city VALUES ('230112', '阿城区', '230100'); INSERT INTO sys_city VALUES ('230113', '双城区', '230100'); INSERT INTO sys_city VALUES ('230123', '依兰县', '230100'); INSERT INTO sys_city VALUES ('230124', '方正县', '230100'); INSERT INTO sys_city VALUES ('230125', '宾县', '230100'); INSERT INTO sys_city VALUES ('230126', '巴彦县', '230100'); INSERT INTO sys_city VALUES ('230127', '木兰县', '230100'); INSERT INTO sys_city VALUES ('230128', '通河县', '230100'); INSERT INTO sys_city VALUES ('230129', '延寿县', '230100'); INSERT INTO sys_city VALUES ('230183', '尚志市', '230100'); INSERT INTO sys_city VALUES ('230184', '五常市', '230100'); INSERT INTO sys_city VALUES ('230200', '齐齐哈尔市', '230000'); INSERT INTO sys_city VALUES ('230202', '龙沙区', '230200'); INSERT INTO sys_city VALUES ('230203', '建华区', '230200'); INSERT INTO sys_city VALUES ('230204', '铁锋区', '230200'); INSERT INTO sys_city VALUES ('230205', '昂昂溪区', '230200'); INSERT INTO sys_city VALUES ('230206', '富拉尔基区', '230200'); INSERT INTO sys_city VALUES ('230207', '碾子山区', '230200'); INSERT INTO sys_city VALUES ('230208', '梅里斯达斡尔族区', '230200'); INSERT INTO sys_city VALUES ('230221', '龙江县', '230200'); INSERT INTO sys_city VALUES ('230223', '依安县', '230200'); INSERT INTO sys_city VALUES ('230224', '泰来县', '230200'); INSERT INTO sys_city VALUES ('230225', '甘南县', '230200'); INSERT INTO sys_city VALUES ('230227', '富裕县', '230200'); INSERT INTO sys_city VALUES ('230229', '克山县', '230200'); INSERT INTO sys_city VALUES ('230230', '克东县', '230200'); INSERT INTO sys_city VALUES ('230231', '拜泉县', '230200'); INSERT INTO sys_city VALUES ('230281', '讷河市', '230200'); INSERT INTO sys_city VALUES ('230300', '鸡西市', '230000'); INSERT INTO sys_city VALUES ('230302', '鸡冠区', '230300'); INSERT INTO sys_city VALUES ('230303', '恒山区', '230300'); INSERT INTO sys_city VALUES ('230304', '滴道区', '230300'); INSERT INTO sys_city VALUES ('230305', '梨树区', '230300'); INSERT INTO sys_city VALUES ('230306', '城子河区', '230300'); INSERT INTO sys_city VALUES ('230307', '麻山区', '230300'); INSERT INTO sys_city VALUES ('230321', '鸡东县', '230300'); INSERT INTO sys_city VALUES ('230381', '虎林市', '230300'); INSERT INTO sys_city VALUES ('230382', '密山市', '230300'); INSERT INTO sys_city VALUES ('230400', '鹤岗市', '230000'); INSERT INTO sys_city VALUES ('230402', '向阳区', '230400'); INSERT INTO sys_city VALUES ('230403', '工农区', '230400'); INSERT INTO sys_city VALUES ('230404', '南山区', '230400'); INSERT INTO sys_city VALUES ('230405', '兴安区', '230400'); INSERT INTO sys_city VALUES ('230406', '东山区', '230400'); INSERT INTO sys_city VALUES ('230407', '兴山区', '230400'); INSERT INTO sys_city VALUES ('230421', '萝北县', '230400'); INSERT INTO sys_city VALUES ('230422', '绥滨县', '230400'); INSERT INTO sys_city VALUES ('230500', '双鸭山市', '230000'); INSERT INTO sys_city VALUES ('230502', '尖山区', '230500'); INSERT INTO sys_city VALUES ('230503', '岭东区', '230500'); INSERT INTO sys_city VALUES ('230505', '四方台区', '230500'); INSERT INTO sys_city VALUES ('230506', '宝山区', '230500'); INSERT INTO sys_city VALUES ('230521', '集贤县', '230500'); INSERT INTO sys_city VALUES ('230522', '友谊县', '230500'); INSERT INTO sys_city VALUES ('230523', '宝清县', '230500'); INSERT INTO sys_city VALUES ('230524', '饶河县', '230500'); INSERT INTO sys_city VALUES ('230600', '大庆市', '230000'); INSERT INTO sys_city VALUES ('230602', '萨尔图区', '230600'); INSERT INTO sys_city VALUES ('230603', '龙凤区', '230600'); INSERT INTO sys_city VALUES ('230604', '让胡路区', '230600'); INSERT INTO sys_city VALUES ('230605', '红岗区', '230600'); INSERT INTO sys_city VALUES ('230606', '大同区', '230600'); INSERT INTO sys_city VALUES ('230621', '肇州县', '230600'); INSERT INTO sys_city VALUES ('230622', '肇源县', '230600'); INSERT INTO sys_city VALUES ('230623', '林甸县', '230600'); INSERT INTO sys_city VALUES ('230624', '杜尔伯特蒙古族自治县', '230600'); INSERT INTO sys_city VALUES ('230700', '伊春市', '230000'); INSERT INTO sys_city VALUES ('230702', '伊春区', '230700'); INSERT INTO sys_city VALUES ('230703', '南岔区', '230700'); INSERT INTO sys_city VALUES ('230704', '友好区', '230700'); INSERT INTO sys_city VALUES ('230705', '西林区', '230700'); INSERT INTO sys_city VALUES ('230706', '翠峦区', '230700'); INSERT INTO sys_city VALUES ('230707', '新青区', '230700'); INSERT INTO sys_city VALUES ('230708', '美溪区', '230700'); INSERT INTO sys_city VALUES ('230709', '金山屯区', '230700'); INSERT INTO sys_city VALUES ('230710', '五营区', '230700'); INSERT INTO sys_city VALUES ('230711', '乌马河区', '230700'); INSERT INTO sys_city VALUES ('230712', '汤旺河区', '230700'); INSERT INTO sys_city VALUES ('230713', '带岭区', '230700'); INSERT INTO sys_city VALUES ('230714', '乌伊岭区', '230700'); INSERT INTO sys_city VALUES ('230715', '红星区', '230700'); INSERT INTO sys_city VALUES ('230716', '上甘岭区', '230700'); INSERT INTO sys_city VALUES ('230722', '嘉荫县', '230700'); INSERT INTO sys_city VALUES ('230781', '铁力市', '230700'); INSERT INTO sys_city VALUES ('230800', '佳木斯市', '230000'); INSERT INTO sys_city VALUES ('230803', '向阳区', '230800'); INSERT INTO sys_city VALUES ('230804', '前进区', '230800'); INSERT INTO sys_city VALUES ('230805', '东风区', '230800'); INSERT INTO sys_city VALUES ('230811', '郊区', '230800'); INSERT INTO sys_city VALUES ('230822', '桦南县', '230800'); INSERT INTO sys_city VALUES ('230826', '桦川县', '230800'); INSERT INTO sys_city VALUES ('230828', '汤原县', '230800'); INSERT INTO sys_city VALUES ('230833', '抚远县', '230800'); INSERT INTO sys_city VALUES ('230881', '同江市', '230800'); INSERT INTO sys_city VALUES ('230882', '富锦市', '230800'); INSERT INTO sys_city VALUES ('230900', '七台河市', '230000'); INSERT INTO sys_city VALUES ('230902', '新兴区', '230900'); INSERT INTO sys_city VALUES ('230903', '桃山区', '230900'); INSERT INTO sys_city VALUES ('230904', '茄子河区', '230900'); INSERT INTO sys_city VALUES ('230921', '勃利县', '230900'); INSERT INTO sys_city VALUES ('231000', '牡丹江市', '230000'); INSERT INTO sys_city VALUES ('231002', '东安区', '231000'); INSERT INTO sys_city VALUES ('231003', '阳明区', '231000'); INSERT INTO sys_city VALUES ('231004', '爱民区', '231000'); INSERT INTO sys_city VALUES ('231005', '西安区', '231000'); INSERT INTO sys_city VALUES ('231024', '东宁县', '231000'); INSERT INTO sys_city VALUES ('231025', '林口县', '231000'); INSERT INTO sys_city VALUES ('231081', '绥芬河市', '231000'); INSERT INTO sys_city VALUES ('231083', '海林市', '231000'); INSERT INTO sys_city VALUES ('231084', '宁安市', '231000'); INSERT INTO sys_city VALUES ('231085', '穆棱市', '231000'); INSERT INTO sys_city VALUES ('231100', '黑河市', '230000'); INSERT INTO sys_city VALUES ('231102', '爱辉区', '231100'); INSERT INTO sys_city VALUES ('231121', '嫩江县', '231100'); INSERT INTO sys_city VALUES ('231123', '逊克县', '231100'); INSERT INTO sys_city VALUES ('231124', '孙吴县', '231100'); INSERT INTO sys_city VALUES ('231181', '北安市', '231100'); INSERT INTO sys_city VALUES ('231182', '五大连池市', '231100'); INSERT INTO sys_city VALUES ('231200', '绥化市', '230000'); INSERT INTO sys_city VALUES ('231202', '北林区', '231200'); INSERT INTO sys_city VALUES ('231221', '望奎县', '231200'); INSERT INTO sys_city VALUES ('231222', '兰西县', '231200'); INSERT INTO sys_city VALUES ('231223', '青冈县', '231200'); INSERT INTO sys_city VALUES ('231224', '庆安县', '231200'); INSERT INTO sys_city VALUES ('231225', '明水县', '231200'); INSERT INTO sys_city VALUES ('231226', '绥棱县', '231200'); INSERT INTO sys_city VALUES ('231281', '安达市', '231200'); INSERT INTO sys_city VALUES ('231282', '肇东市', '231200'); INSERT INTO sys_city VALUES ('231283', '海伦市', '231200'); INSERT INTO sys_city VALUES ('232700', '大兴安岭地区', '230000'); INSERT INTO sys_city VALUES ('232721', '呼玛县', '232700'); INSERT INTO sys_city VALUES ('232722', '塔河县', '232700'); INSERT INTO sys_city VALUES ('232723', '漠河县', '232700'); INSERT INTO sys_city VALUES ('310000', '上海市', '0'); INSERT INTO sys_city VALUES ('310101', '黄浦区', '310100'); INSERT INTO sys_city VALUES ('310104', '徐汇区', '310100'); INSERT INTO sys_city VALUES ('310105', '长宁区', '310100'); INSERT INTO sys_city VALUES ('310106', '静安区', '310100'); INSERT INTO sys_city VALUES ('310107', '普陀区', '310100'); INSERT INTO sys_city VALUES ('310108', '闸北区', '310100'); INSERT INTO sys_city VALUES ('310109', '虹口区', '310100'); INSERT INTO sys_city VALUES ('310110', '杨浦区', '310100'); INSERT INTO sys_city VALUES ('310112', '闵行区', '310100'); INSERT INTO sys_city VALUES ('310113', '宝山区', '310100'); INSERT INTO sys_city VALUES ('310114', '嘉定区', '310100'); INSERT INTO sys_city VALUES ('310115', '浦东新区', '310100'); INSERT INTO sys_city VALUES ('310116', '金山区', '310100'); INSERT INTO sys_city VALUES ('310117', '松江区', '310100'); INSERT INTO sys_city VALUES ('310118', '青浦区', '310100'); INSERT INTO sys_city VALUES ('310120', '奉贤区', '310100'); INSERT INTO sys_city VALUES ('310230', '崇明县', '310200'); INSERT INTO sys_city VALUES ('320000', '江苏省', '0'); INSERT INTO sys_city VALUES ('320100', '南京市', '320000'); INSERT INTO sys_city VALUES ('320102', '玄武区', '320100'); INSERT INTO sys_city VALUES ('320104', '秦淮区', '320100'); INSERT INTO sys_city VALUES ('320105', '建邺区', '320100'); INSERT INTO sys_city VALUES ('320106', '鼓楼区', '320100'); INSERT INTO sys_city VALUES ('320111', '浦口区', '320100'); INSERT INTO sys_city VALUES ('320113', '栖霞区', '320100'); INSERT INTO sys_city VALUES ('320114', '雨花台区', '320100'); INSERT INTO sys_city VALUES ('320115', '江宁区', '320100'); INSERT INTO sys_city VALUES ('320116', '六合区', '320100'); INSERT INTO sys_city VALUES ('320117', '溧水区', '320100'); INSERT INTO sys_city VALUES ('320118', '高淳区', '320100'); INSERT INTO sys_city VALUES ('320200', '无锡市', '320000'); INSERT INTO sys_city VALUES ('320202', '崇安区', '320200'); INSERT INTO sys_city VALUES ('320203', '南长区', '320200'); INSERT INTO sys_city VALUES ('320204', '北塘区', '320200'); INSERT INTO sys_city VALUES ('320205', '锡山区', '320200'); INSERT INTO sys_city VALUES ('320206', '惠山区', '320200'); INSERT INTO sys_city VALUES ('320211', '滨湖区', '320200'); INSERT INTO sys_city VALUES ('320281', '江阴市', '320200'); INSERT INTO sys_city VALUES ('320282', '宜兴市', '320200'); INSERT INTO sys_city VALUES ('320300', '徐州市', '320000'); INSERT INTO sys_city VALUES ('320302', '鼓楼区', '320300'); INSERT INTO sys_city VALUES ('320303', '云龙区', '320300'); INSERT INTO sys_city VALUES ('320305', '贾汪区', '320300'); INSERT INTO sys_city VALUES ('320311', '泉山区', '320300'); INSERT INTO sys_city VALUES ('320312', '铜山区', '320300'); INSERT INTO sys_city VALUES ('320321', '丰县', '320300'); INSERT INTO sys_city VALUES ('320322', '沛县', '320300'); INSERT INTO sys_city VALUES ('320324', '睢宁县', '320300'); INSERT INTO sys_city VALUES ('320381', '新沂市', '320300'); INSERT INTO sys_city VALUES ('320382', '邳州市', '320300'); INSERT INTO sys_city VALUES ('320400', '常州市', '320000'); INSERT INTO sys_city VALUES ('320402', '天宁区', '320400'); INSERT INTO sys_city VALUES ('320404', '钟楼区', '320400'); INSERT INTO sys_city VALUES ('320411', '新北区', '320400'); INSERT INTO sys_city VALUES ('320412', '武进区', '320400'); INSERT INTO sys_city VALUES ('320413', '金坛区', '320400'); INSERT INTO sys_city VALUES ('320481', '溧阳市', '320400'); INSERT INTO sys_city VALUES ('320500', '苏州市', '320000'); INSERT INTO sys_city VALUES ('320505', '虎丘区', '320500'); INSERT INTO sys_city VALUES ('320506', '吴中区', '320500'); INSERT INTO sys_city VALUES ('320507', '相城区', '320500'); INSERT INTO sys_city VALUES ('320508', '姑苏区', '320500'); INSERT INTO sys_city VALUES ('320509', '吴江区', '320500'); INSERT INTO sys_city VALUES ('320581', '常熟市', '320500'); INSERT INTO sys_city VALUES ('320582', '张家港市', '320500'); INSERT INTO sys_city VALUES ('320583', '昆山市', '320500'); INSERT INTO sys_city VALUES ('320585', '太仓市', '320500'); INSERT INTO sys_city VALUES ('320600', '南通市', '320000'); INSERT INTO sys_city VALUES ('320602', '崇川区', '320600'); INSERT INTO sys_city VALUES ('320611', '港闸区', '320600'); INSERT INTO sys_city VALUES ('320612', '通州区', '320600'); INSERT INTO sys_city VALUES ('320621', '海安县', '320600'); INSERT INTO sys_city VALUES ('320623', '如东县', '320600'); INSERT INTO sys_city VALUES ('320681', '启东市', '320600'); INSERT INTO sys_city VALUES ('320682', '如皋市', '320600'); INSERT INTO sys_city VALUES ('320684', '海门市', '320600'); INSERT INTO sys_city VALUES ('320700', '连云港市', '320000'); INSERT INTO sys_city VALUES ('320703', '连云区', '320700'); INSERT INTO sys_city VALUES ('320706', '海州区', '320700'); INSERT INTO sys_city VALUES ('320707', '赣榆区', '320700'); INSERT INTO sys_city VALUES ('320722', '东海县', '320700'); INSERT INTO sys_city VALUES ('320723', '灌云县', '320700'); INSERT INTO sys_city VALUES ('320724', '灌南县', '320700'); INSERT INTO sys_city VALUES ('320800', '淮安市', '320000'); INSERT INTO sys_city VALUES ('320802', '清河区', '320800'); INSERT INTO sys_city VALUES ('320803', '淮安区', '320800'); INSERT INTO sys_city VALUES ('320804', '淮阴区', '320800'); INSERT INTO sys_city VALUES ('320811', '清浦区', '320800'); INSERT INTO sys_city VALUES ('320826', '涟水县', '320800'); INSERT INTO sys_city VALUES ('320829', '洪泽县', '320800'); INSERT INTO sys_city VALUES ('320830', '盱眙县', '320800'); INSERT INTO sys_city VALUES ('320831', '金湖县', '320800'); INSERT INTO sys_city VALUES ('320900', '盐城市', '320000'); INSERT INTO sys_city VALUES ('320902', '亭湖区', '320900'); INSERT INTO sys_city VALUES ('320903', '盐都区', '320900'); INSERT INTO sys_city VALUES ('320904', '大丰区', '320900'); INSERT INTO sys_city VALUES ('320921', '响水县', '320900'); INSERT INTO sys_city VALUES ('320922', '滨海县', '320900'); INSERT INTO sys_city VALUES ('320923', '阜宁县', '320900'); INSERT INTO sys_city VALUES ('320924', '射阳县', '320900'); INSERT INTO sys_city VALUES ('320925', '建湖县', '320900'); INSERT INTO sys_city VALUES ('320981', '东台市', '320900'); INSERT INTO sys_city VALUES ('321000', '扬州市', '320000'); INSERT INTO sys_city VALUES ('321002', '广陵区', '321000'); INSERT INTO sys_city VALUES ('321003', '邗江区', '321000'); INSERT INTO sys_city VALUES ('321012', '江都区', '321000'); INSERT INTO sys_city VALUES ('321023', '宝应县', '321000'); INSERT INTO sys_city VALUES ('321081', '仪征市', '321000'); INSERT INTO sys_city VALUES ('321084', '高邮市', '321000'); INSERT INTO sys_city VALUES ('321100', '镇江市', '320000'); INSERT INTO sys_city VALUES ('321102', '京口区', '321100'); INSERT INTO sys_city VALUES ('321111', '润州区', '321100'); INSERT INTO sys_city VALUES ('321112', '丹徒区', '321100'); INSERT INTO sys_city VALUES ('321181', '丹阳市', '321100'); INSERT INTO sys_city VALUES ('321182', '扬中市', '321100'); INSERT INTO sys_city VALUES ('321183', '句容市', '321100'); INSERT INTO sys_city VALUES ('321200', '泰州市', '320000'); INSERT INTO sys_city VALUES ('321202', '海陵区', '321200'); INSERT INTO sys_city VALUES ('321203', '高港区', '321200'); INSERT INTO sys_city VALUES ('321204', '姜堰区', '321200'); INSERT INTO sys_city VALUES ('321281', '兴化市', '321200'); INSERT INTO sys_city VALUES ('321282', '靖江市', '321200'); INSERT INTO sys_city VALUES ('321283', '泰兴市', '321200'); INSERT INTO sys_city VALUES ('321300', '宿迁市', '320000'); INSERT INTO sys_city VALUES ('321302', '宿城区', '321300'); INSERT INTO sys_city VALUES ('321311', '宿豫区', '321300'); INSERT INTO sys_city VALUES ('321322', '沭阳县', '321300'); INSERT INTO sys_city VALUES ('321323', '泗阳县', '321300'); INSERT INTO sys_city VALUES ('321324', '泗洪县', '321300'); INSERT INTO sys_city VALUES ('330000', '浙江省', '0'); INSERT INTO sys_city VALUES ('330100', '杭州市', '330000'); INSERT INTO sys_city VALUES ('330102', '上城区', '330100'); INSERT INTO sys_city VALUES ('330103', '下城区', '330100'); INSERT INTO sys_city VALUES ('330104', '江干区', '330100'); INSERT INTO sys_city VALUES ('330105', '拱墅区', '330100'); INSERT INTO sys_city VALUES ('330106', '西湖区', '330100'); INSERT INTO sys_city VALUES ('330108', '滨江区', '330100'); INSERT INTO sys_city VALUES ('330109', '萧山区', '330100'); INSERT INTO sys_city VALUES ('330110', '余杭区', '330100'); INSERT INTO sys_city VALUES ('330111', '富阳区', '330100'); INSERT INTO sys_city VALUES ('330122', '桐庐县', '330100'); INSERT INTO sys_city VALUES ('330127', '淳安县', '330100'); INSERT INTO sys_city VALUES ('330182', '建德市', '330100'); INSERT INTO sys_city VALUES ('330185', '临安市', '330100'); INSERT INTO sys_city VALUES ('330200', '宁波市', '330000'); INSERT INTO sys_city VALUES ('330203', '海曙区', '330200'); INSERT INTO sys_city VALUES ('330204', '江东区', '330200'); INSERT INTO sys_city VALUES ('330205', '江北区', '330200'); INSERT INTO sys_city VALUES ('330206', '北仑区', '330200'); INSERT INTO sys_city VALUES ('330211', '镇海区', '330200'); INSERT INTO sys_city VALUES ('330212', '鄞州区', '330200'); INSERT INTO sys_city VALUES ('330225', '象山县', '330200'); INSERT INTO sys_city VALUES ('330226', '宁海县', '330200'); INSERT INTO sys_city VALUES ('330281', '余姚市', '330200'); INSERT INTO sys_city VALUES ('330282', '慈溪市', '330200'); INSERT INTO sys_city VALUES ('330283', '奉化市', '330200'); INSERT INTO sys_city VALUES ('330300', '温州市', '330000'); INSERT INTO sys_city VALUES ('330302', '鹿城区', '330300'); INSERT INTO sys_city VALUES ('330303', '龙湾区', '330300'); INSERT INTO sys_city VALUES ('330304', '瓯海区', '330300'); INSERT INTO sys_city VALUES ('330305', '洞头区', '330300'); INSERT INTO sys_city VALUES ('330324', '永嘉县', '330300'); INSERT INTO sys_city VALUES ('330326', '平阳县', '330300'); INSERT INTO sys_city VALUES ('330327', '苍南县', '330300'); INSERT INTO sys_city VALUES ('330328', '文成县', '330300'); INSERT INTO sys_city VALUES ('330329', '泰顺县', '330300'); INSERT INTO sys_city VALUES ('330381', '瑞安市', '330300'); INSERT INTO sys_city VALUES ('330382', '乐清市', '330300'); INSERT INTO sys_city VALUES ('330400', '嘉兴市', '330000'); INSERT INTO sys_city VALUES ('330402', '南湖区', '330400'); INSERT INTO sys_city VALUES ('330411', '秀洲区', '330400'); INSERT INTO sys_city VALUES ('330421', '嘉善县', '330400'); INSERT INTO sys_city VALUES ('330424', '海盐县', '330400'); INSERT INTO sys_city VALUES ('330481', '海宁市', '330400'); INSERT INTO sys_city VALUES ('330482', '平湖市', '330400'); INSERT INTO sys_city VALUES ('330483', '桐乡市', '330400'); INSERT INTO sys_city VALUES ('330500', '湖州市', '330000'); INSERT INTO sys_city VALUES ('330502', '吴兴区', '330500'); INSERT INTO sys_city VALUES ('330503', '南浔区', '330500'); INSERT INTO sys_city VALUES ('330521', '德清县', '330500'); INSERT INTO sys_city VALUES ('330522', '长兴县', '330500'); INSERT INTO sys_city VALUES ('330523', '安吉县', '330500'); INSERT INTO sys_city VALUES ('330600', '绍兴市', '330000'); INSERT INTO sys_city VALUES ('330602', '越城区', '330600'); INSERT INTO sys_city VALUES ('330603', '柯桥区', '330600'); INSERT INTO sys_city VALUES ('330604', '上虞区', '330600'); INSERT INTO sys_city VALUES ('330624', '新昌县', '330600'); INSERT INTO sys_city VALUES ('330681', '诸暨市', '330600'); INSERT INTO sys_city VALUES ('330683', '嵊州市', '330600'); INSERT INTO sys_city VALUES ('330700', '金华市', '330000'); INSERT INTO sys_city VALUES ('330702', '婺城区', '330700'); INSERT INTO sys_city VALUES ('330703', '金东区', '330700'); INSERT INTO sys_city VALUES ('330723', '武义县', '330700'); INSERT INTO sys_city VALUES ('330726', '浦江县', '330700'); INSERT INTO sys_city VALUES ('330727', '磐安县', '330700'); INSERT INTO sys_city VALUES ('330781', '兰溪市', '330700'); INSERT INTO sys_city VALUES ('330782', '义乌市', '330700'); INSERT INTO sys_city VALUES ('330783', '东阳市', '330700'); INSERT INTO sys_city VALUES ('330784', '永康市', '330700'); INSERT INTO sys_city VALUES ('330800', '衢州市', '330000'); INSERT INTO sys_city VALUES ('330802', '柯城区', '330800'); INSERT INTO sys_city VALUES ('330803', '衢江区', '330800'); INSERT INTO sys_city VALUES ('330822', '常山县', '330800'); INSERT INTO sys_city VALUES ('330824', '开化县', '330800'); INSERT INTO sys_city VALUES ('330825', '龙游县', '330800'); INSERT INTO sys_city VALUES ('330881', '江山市', '330800'); INSERT INTO sys_city VALUES ('330900', '舟山市', '330000'); INSERT INTO sys_city VALUES ('330902', '定海区', '330900'); INSERT INTO sys_city VALUES ('330903', '普陀区', '330900'); INSERT INTO sys_city VALUES ('330921', '岱山县', '330900'); INSERT INTO sys_city VALUES ('330922', '嵊泗县', '330900'); INSERT INTO sys_city VALUES ('331000', '台州市', '330000'); INSERT INTO sys_city VALUES ('331002', '椒江区', '331000'); INSERT INTO sys_city VALUES ('331003', '黄岩区', '331000'); INSERT INTO sys_city VALUES ('331004', '路桥区', '331000'); INSERT INTO sys_city VALUES ('331021', '玉环县', '331000'); INSERT INTO sys_city VALUES ('331022', '三门县', '331000'); INSERT INTO sys_city VALUES ('331023', '天台县', '331000'); INSERT INTO sys_city VALUES ('331024', '仙居县', '331000'); INSERT INTO sys_city VALUES ('331081', '温岭市', '331000'); INSERT INTO sys_city VALUES ('331082', '临海市', '331000'); INSERT INTO sys_city VALUES ('331100', '丽水市', '330000'); INSERT INTO sys_city VALUES ('331102', '莲都区', '331100'); INSERT INTO sys_city VALUES ('331121', '青田县', '331100'); INSERT INTO sys_city VALUES ('331122', '缙云县', '331100'); INSERT INTO sys_city VALUES ('331123', '遂昌县', '331100'); INSERT INTO sys_city VALUES ('331124', '松阳县', '331100'); INSERT INTO sys_city VALUES ('331125', '云和县', '331100'); INSERT INTO sys_city VALUES ('331126', '庆元县', '331100'); INSERT INTO sys_city VALUES ('331127', '景宁畲族自治县', '331100'); INSERT INTO sys_city VALUES ('331181', '龙泉市', '331100'); INSERT INTO sys_city VALUES ('340000', '安徽省', '0'); INSERT INTO sys_city VALUES ('340100', '合肥市', '340000'); INSERT INTO sys_city VALUES ('340102', '瑶海区', '340100'); INSERT INTO sys_city VALUES ('340103', '庐阳区', '340100'); INSERT INTO sys_city
中国省市区乡镇SQL数据表
04-15
中国省市区乡镇SQL数据表，具体可参考： http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2013/index.html 2018年最新的数据可到这里下载：https://download.csdn.net/download/unicac/12055104
中国所有城市名称大全.txt
11-22
中国所有城市名称大全 合计620个 一行一个 例如 上海 重庆 安徽 合肥 毫州 芜湖 马鞍山 池州 黄山 滁州 安庆 淮南 淮北 蚌埠 巢湖 宿州 宣城 六安 阜阳 ……
全国各省市区城市编码SQL
热门推荐
在路上
01-17 4万+
在做开发的时候相信大家找省市区代码表会非常的蛋疼，在我做的几个App中都使用了地区，在网上找了很多的资源，然而不是这里有问题就是那里有问题，最近做项目的时候狠下心检查了一下，整理出以下内容，直接复制到mysql中执行即可。希望对大家有帮助。 # ************************************************************ # Sequel P
Python3爬虫小程序——爬取各类天气信息（4）
学习容易上瘾
06-19 8254
【爬取动态页面的数据】 更新：已上传到我的GitHub上，点击打开链接 上一次讲到用工具对动态页面进行数据爬取，但是感觉难度不小，而且运行效率简直低下。。。 于是乎从网上查资料，有好多说可以通过获取网站的json数据来进行动态页面爬取，然后我就找到气象数据权威——中央气象台的官网（http://www.nmc.cn/），开始数据的爬取。 然后怎么去找这个json数据呢？在后台开着抓包软件F...
百度地图CityID获取
chongmingnang1682的博客
06-15 1415
//离线地图：用来获取百度地图的cityID，使用完毕后要关掉，否则影响在线地图的显示 @property (nonatomic,strong) BMKOfflineMap* offlineMap; -(BMKOfflineMap *)offlineMap{ if (_offli...
中国省市区--地区SQL表
weixin_34341229的博客
07-18 651
SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for rc_district -- ---------------------------- DROP TABLE IF EXISTS `rc_district`; CREATE TABLE `r...
city.js_js省市联动库
LYBWWP
11-21 1万+
var City = function(id, pid, name) { this.id = id; this.pid = pid; this.name = name; }; var province = [ new City(110000,100000,"北京市"), new City(120000,100000,"天津市"), new City(130000,100000,"河
mysql省市区邮政编码和区号级联sql文件
wyyl1的专栏
05-12 3万+
文章主要内容来源于csdn的lookbbs的资源，是他提供的sql语句，我只是删除了原语句中的“ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3145“因为这句有可能导致部分生成时编码错误。  DROP TABLE IF EXISTS `areas`;CREATE TABLE `areas` (  `id` int(11) NO
全国省市区数据库sql
hurace的专栏
09-05 2万+
内容来源于网络，有部分自己的修改。 /* SQLyog Ultimate v12.08 (64 bit) MySQL - 5.1.69 ********************************************************************* */ /*!40101 SET NAMES utf8 */; create table `wb_region` (
SQL.Cookbook中文版：经典SQL教程详解
《SQL.Cookbook(中文版)》是由美国作者莫利纳罗所著的一本经典SQL教程，这本书以其实用性和深度，深受程序员和数据库管理者的喜爱。它不仅涵盖了SQL的基础知识，如查询构造、数据操作、表设计等，还深入探讨了高级...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值