INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (1,1,'北京市','100000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (2,2,'天津市','100000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (3,3,'石家庄市','050000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (4,3,'唐山市','063000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (5,3,'秦皇岛市','066000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (6,3,'邯郸市','056000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (7,3,'邢台市','054000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (8,3,'保定市','071000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (9,3,'张家口市','075000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (10,3,'承德市','067000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (11,3,'沧州市','061000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (12,3,'廊坊市','065000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (13,3,'衡水市','053000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (14,4,'太原市','030000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (15,4,'大同市','037000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (16,4,'阳泉市','045000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (17,4,'长治市','046000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (18,4,'晋城市','048000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (19,4,'朔州市','036000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (20,4,'晋中市','030600');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (21,4,'运城市','044000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (22,4,'忻州市','034000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (23,4,'临汾市','041000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (24,4,'吕梁市','030500');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (25,5,'呼和浩特市','010000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (26,5,'包头市','014000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (27,5,'乌海市','016000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (28,5,'赤峰市','024000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (29,5,'通辽市','028000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (30,5,'鄂尔多斯市','010300');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (31,5,'呼伦贝尔市','021000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (32,5,'巴彦淖尔市','014400');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (33,5,'乌兰察布市','011800');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34,5,'兴安盟','137500');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (35,5,'锡林郭勒盟','011100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (36,5,'阿拉善盟','016000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (37,6,'沈阳市','110000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (38,6,'大连市','116000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (39,6,'鞍山市','114000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (40,6,'抚顺市','113000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (41,6,'本溪市','117000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (42,6,'丹东市','118000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (43,6,'锦州市','121000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (44,6,'营口市','115000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (45,6,'阜新市','123000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (46,6,'辽阳市','111000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (47,6,'盘锦市','124000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (48,6,'铁岭市','112000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (49,6,'朝阳市','122000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (50,6,'葫芦岛市','125000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (51,7,'长春市','130000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (52,7,'吉林市','132000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (53,7,'四平市','136000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (54,7,'辽源市','136200');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (55,7,'通化市','134000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (56,7,'白山市','134300');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (57,7,'松原市','131100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (58,7,'白城市','137000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (59,7,'延边朝鲜族自治州','133000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (60,8,'哈尔滨市','150000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (61,8,'齐齐哈尔市','161000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (62,8,'鸡西市','158100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (63,8,'鹤岗市','154100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (64,8,'双鸭山市','155100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (65,8,'大庆市','163000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (66,8,'伊春市','152300');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (67,8,'佳木斯市','154000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (68,8,'七台河市','154600');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (69,8,'牡丹江市','157000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (70,8,'黑河市','164300');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (71,8,'绥化市','152000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (72,8,'大兴安岭地区','165000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (73,9,'上海市','200000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (74,10,'南京市','210000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (75,10,'无锡市','214000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (76,10,'徐州市','221000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (77,10,'常州市','213000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (78,10,'苏州市','215000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (79,10,'南通市','226000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (80,10,'连云港市','222000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (81,10,'淮安市','223200');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (82,10,'盐城市','224000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (83,10,'扬州市','225000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (84,10,'镇江市','212000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (85,10,'泰州市','225300');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (86,10,'宿迁市','223800');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (87,11,'杭州市','310000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (88,11,'宁波市','315000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (89,11,'温州市','325000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (90,11,'嘉兴市','314000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (91,11,'湖州市','313000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (92,11,'绍兴市','312000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (93,11,'金华市','321000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (94,11,'衢州市','324000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (95,11,'舟山市','316000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (96,11,'台州市','318000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (97,11,'丽水市','323000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (98,12,'合肥市','230000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (99,12,'芜湖市','241000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (100,12,'蚌埠市','233000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (101,12,'淮南市','232000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (102,12,'马鞍山市','243000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (103,12,'淮北市','235000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (104,12,'铜陵市','244000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (105,12,'安庆市','246000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (106,12,'黄山市','242700');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (107,12,'滁州市','239000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (108,12,'阜阳市','236100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (109,12,'宿州市','234100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (111,12,'六安市','237000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (112,12,'亳州市','236800');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (113,12,'池州市','247100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (114,12,'宣城市','366000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (115,13,'福州市','350000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (116,13,'厦门市','361000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (117,13,'莆田市','351100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (118,13,'三明市','365000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (119,13,'泉州市','362000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (120,13,'漳州市','363000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (121,13,'南平市','353000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (122,13,'龙岩市','364000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (123,13,'宁德市','352100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (124,14,'南昌市','330000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (125,14,'景德镇市','333000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (126,14,'萍乡市','337000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (127,14,'九江市','332000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (128,14,'新余市','338000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (129,14,'鹰潭市','335000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (130,14,'赣州市','341000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (131,14,'吉安市','343000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (132,14,'宜春市','336000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (133,14,'抚州市','332900');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (134,14,'上饶市','334000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (135,15,'济南市','250000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (136,15,'青岛市','266000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (137,15,'淄博市','255000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (138,15,'枣庄市','277100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (139,15,'东营市','257000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (140,15,'烟台市','264000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (141,15,'潍坊市','261000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (142,15,'济宁市','272100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (143,15,'泰安市','271000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (144,15,'威海市','265700');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (145,15,'日照市','276800');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (147,15,'临沂市','276000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (148,15,'德州市','253000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (149,15,'聊城市','252000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (150,15,'滨州市','256600');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (151,15,'荷泽市','255000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (152,16,'郑州市','450000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (153,16,'开封市','475000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (154,16,'洛阳市','471000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (155,16,'平顶山市','467000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (156,16,'安阳市','454900');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (157,16,'鹤壁市','456600');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (158,16,'新乡市','453000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (159,16,'焦作市','454100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (160,16,'濮阳市','457000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (161,16,'许昌市','461000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (162,16,'漯河市','462000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (163,16,'三门峡市','472000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (164,16,'南阳市','473000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (165,16,'商丘市','476000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (166,16,'信阳市','464000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (167,16,'周口市','466000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (168,16,'驻马店市','463000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (169,17,'武汉市','430000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (170,17,'黄石市','435000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (171,17,'十堰市','442000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (172,17,'宜昌市','443000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (173,17,'襄樊市','441000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (174,17,'鄂州市','436000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (175,17,'荆门市','448000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (176,17,'孝感市','432100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (177,17,'荆州市','434000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (178,17,'黄冈市','438000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (179,17,'咸宁市','437000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (180,17,'随州市','441300');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (181,17,'恩施土家族苗族自治州','445000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (182,17,'省直辖县级行政区划','');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (183,18,'长沙市','410000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (184,18,'株洲市','412000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (185,18,'湘潭市','411100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (186,18,'衡阳市','421000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (187,18,'邵阳市','422000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (188,18,'岳阳市','414000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (189,18,'常德市','415000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (190,18,'张家界市','427000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (191,18,'益阳市','413000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (192,18,'郴州市','423000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (193,18,'永州市','425000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (194,18,'怀化市','418000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (195,18,'娄底市','417000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (196,18,'湘西土家族苗族自治州','416000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (197,19,'广州市','510000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (198,19,'韶关市','521000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (199,19,'深圳市','518000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (200,19,'珠海市','519000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (201,19,'汕头市','515000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (202,19,'佛山市','528000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (203,19,'江门市','529000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (204,19,'湛江市','524000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (205,19,'茂名市','525000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (206,19,'肇庆市','526000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (207,19,'惠州市','516000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (208,19,'梅州市','514000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (209,19,'汕尾市','516600');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (210,19,'河源市','517000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (211,19,'阳江市','529500');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (212,19,'清远市','511500');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (213,19,'东莞市','511700');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (214,19,'中山市','528400');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (215,19,'潮州市','515600');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (216,19,'揭阳市','522000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (217,19,'云浮市','527300');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (218,20,'南宁市','530000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (219,20,'柳州市','545000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (220,20,'桂林市','541000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (221,20,'梧州市','543000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (222,20,'北海市','536000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (223,20,'防城港市','538000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (224,20,'钦州市','535000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (225,20,'贵港市','537100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (226,20,'玉林市','537000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (227,20,'百色市','533000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (228,20,'贺州市','542800');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (229,20,'河池市','547000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (230,20,'来宾市','546100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (231,20,'崇左市','532200');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (232,21,'海口市','570000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (233,21,'三亚市','572000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (234,22,'重庆市','400000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (235,23,'成都市','610000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (236,23,'自贡市','643000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (237,23,'攀枝花市','617000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (238,23,'泸州市','646100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (239,23,'德阳市','618000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (240,23,'绵阳市','621000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (241,23,'广元市','628000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (242,23,'遂宁市','629000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (243,23,'内江市','641000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (244,23,'乐山市','614000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (245,23,'南充市','637000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (246,23,'眉山市','612100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (247,23,'宜宾市','644000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (248,23,'广安市','638000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (249,23,'达州市','635000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (250,23,'雅安市','625000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (251,23,'巴中市','635500');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (252,23,'资阳市','641300');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (253,23,'阿坝藏族羌族自治州','624600');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (254,23,'甘孜藏族自治州','626000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (255,23,'凉山彝族自治州','615000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (256,24,'贵阳市','55000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (257,24,'六盘水市','553000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (258,24,'遵义市','563000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (259,24,'安顺市','561000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (260,24,'铜仁市','554300');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (261,24,'黔西南布依族苗族自治州','551500');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (262,24,'毕节市','551700');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (263,24,'黔东南苗族侗族自治州','551500');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (264,24,'黔南布依族苗族自治州','550100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (265,25,'昆明市','650000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (266,25,'曲靖市','655000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (267,25,'玉溪市','653100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (268,25,'保山市','678000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (269,25,'昭通市','657000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (270,25,'丽江市','674100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (271,25,'普洱市','665000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (272,25,'临沧市','677000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (273,25,'楚雄彝族自治州','675000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (274,25,'红河哈尼族彝族自治州','654400');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (275,25,'文山壮族苗族自治州','663000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (276,25,'西双版纳傣族自治州','666200');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (277,25,'大理白族自治州','671000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (278,25,'德宏傣族景颇族自治州','678400');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (279,25,'怒江傈僳族自治州','671400');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (280,25,'迪庆藏族自治州','674400');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (281,26,'拉萨市','850000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (282,26,'昌都市','854000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (283,26,'山南市','856000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (284,26,'日喀则市','857000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (285,26,'那曲地区','852000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (286,26,'阿里地区','859100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (287,26,'林芝市','860100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (288,27,'西安市','710000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (289,27,'铜川市','727000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (290,27,'宝鸡市','721000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (291,27,'咸阳市','712000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (292,27,'渭南市','714000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (293,27,'延安市','716000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (294,27,'汉中市','723000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (295,27,'榆林市','719000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (296,27,'安康市','725000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (297,27,'商洛市','711500');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (298,28,'兰州市','730000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (299,28,'嘉峪关市','735100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (300,28,'金昌市','737100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (301,28,'白银市','730900');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (302,28,'天水市','741000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (303,28,'武威市','733000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (304,28,'张掖市','734000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (305,28,'平凉市','744000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (306,28,'酒泉市','735000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (307,28,'庆阳市','744500');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (308,28,'定西市','743000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (309,28,'陇南市','742100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (310,28,'临夏回族自治州','731100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (311,28,'甘南藏族自治州','747000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (312,29,'西宁市','810000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (313,29,'海东地区','810600');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (314,29,'海北藏族自治州','810300');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (315,29,'黄南藏族自治州','811300');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (316,29,'海南藏族自治州','813000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (317,29,'果洛藏族自治州','814000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (318,29,'玉树藏族自治州','815000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (319,29,'海西蒙古族藏族自治州','817000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (320,30,'银川市','750000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (321,30,'石嘴山市','753000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (322,30,'吴忠市','751100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (323,30,'固原市','756000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (324,30,'中卫市','751700');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (325,31,'乌鲁木齐市','830000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (326,31,'克拉玛依市','834000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (327,31,'吐鲁番地区','838000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (328,31,'哈密市','839000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (329,31,'昌吉回族自治州','831100');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (330,31,'博尔塔拉蒙古自治州','833400');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (331,31,'巴音郭楞蒙古自治州','841000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (332,31,'阿克苏地区','843000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (333,31,'克孜勒苏柯尔克孜自治州','835600');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (334,31,'喀什地区','844000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (335,31,'和田地区','848000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (336,31,'伊犁哈萨克自治州','833200');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (337,31,'塔城地区','834700');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (338,31,'阿勒泰地区','836500');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (339,31,'自治区直辖县级行政区划','');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (343,32,'香港特别行政区','000000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (344,33,'澳门特别行政区','000000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (345,34,'台北市','000000');
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (16001,16,'省直辖县级行政区划',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (21001,21,'三沙市',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (21002,21,'儋州市',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (21003,21,'省直辖县级行政区划',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (22001,22,'县',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34001,34,'高雄市',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34002,34,'台南市',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34003,34,'台中市',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34004,34,'南投县',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34005,34,'基隆市',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34006,34,'新竹市',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34007,34,'嘉义市',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34008,34,'新北市',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34009,34,'宜兰县',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34010,34,'新竹县',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34011,34,'桃园市',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34012,34,'苗栗县',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34013,34,'彰化县',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34014,34,'嘉义县',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34015,34,'云林县',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34016,34,'屏东县',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34017,34,'台东县',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34018,34,'花莲县',NULL);
INSERT INTO `city` (`Id`,`ProvinceId`,`Name`,`ZipCode`) VALUES (34019,34,'澎湖县',NULL);