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);
