--省--
INSERT INTO province(pid,province) VALUES (1, '北京市');
INSERT INTO province(pid,province) VALUES (2, '天津市');
INSERT INTO province(pid,province) VALUES (3, '河北省');
INSERT INTO province(pid,province) VALUES (4, '山西省');
INSERT INTO province(pid,province) VALUES (5, '内蒙古自治区');
INSERT INTO province(pid,province) VALUES (6, '辽宁省');
INSERT INTO province(pid,province) VALUES (7, '吉林省');
INSERT INTO province(pid,province) VALUES (8, '黑龙江省');
INSERT INTO province(pid,province) VALUES (9, '上海市');
INSERT INTO province(pid,province) VALUES (10, '江苏省');
INSERT INTO province(pid,province) VALUES (11, '浙江省');
INSERT INTO province(pid,province) VALUES (12, '安徽省');
INSERT INTO province(pid,province) VALUES (13, '福建省');
INSERT INTO province(pid,province) VALUES (14, '江西省');
INSERT INTO province(pid,province) VALUES (15, '山东省');
INSERT INTO province(pid,province) VALUES (16, '河南省');
INSERT INTO province(pid,province) VALUES (17, '湖北省');
INSERT INTO province(pid,province) VALUES (18, '湖南省');
INSERT INTO province(pid,province) VALUES (19, '广东省');
INSERT INTO province(pid,province) VALUES (20, '广西壮族自治区');
INSERT INTO province(pid,province) VALUES (21, '海南省');
INSERT INTO province(pid,province) VALUES (22, '重庆市');
INSERT INTO province(pid,province) VALUES (23, '四川省');
INSERT INTO province(pid,province) VALUES (24, '贵州省');
INSERT INTO province(pid,province) VALUES (25, '云南省');
INSERT INTO province(pid,province) VALUES (26, '西藏自治区');
INSERT INTO province(pid,province) VALUES (27, '陕西省');
INSERT INTO province(pid,province) VALUES (28, '甘肃省');
INSERT INTO province(pid,province) VALUES (29, '青海省');
INSERT INTO province(pid,province) VALUES (30, '宁夏回族自治区');
INSERT INTO province(pid,province) VALUES (31, '新疆维吾尔自治区');
INSERT INTO province(pid,province) VALUES (32, '香港特别行政区');
INSERT INTO province(pid,province) VALUES (33, '澳门特别行政区');
INSERT INTO province(pid,province) VALUES (34, '台湾省');
--城市--
INSERT INTO city(id,city,pid) VALUES (1, '北京市', 1);
INSERT INTO city(id,city,pid) VALUES (2, '天津市', 2);
INSERT INTO city(id,city,pid) VALUES (3, '石家庄市', 3);
INSERT INTO city(id,city,pid) VALUES (4, '唐山市', 3);
INSERT INTO city(id,city,pid) VALUES (5, '秦皇岛市', 3);
INSERT INTO city(id,city,pid) VALUES (6, '邯郸市', 3);
INSERT INTO city(id,city,pid) VALUES (7, '邢台市', 3);
INSERT INTO city(id,city,pid) VALUES (8, '保定市', 3);
INSERT INTO city(id,city,pid) VALUES (9, '张家口市', 3);
INSERT INTO city(id,city,pid) VALUES (10, '承德市', 3);
INSERT INTO city(id,city,pid) VALUES (11, '沧州市', 3);
INSERT INTO city(id,city,pid) VALUES (12, '廊坊市', 3);
INSERT INTO city(id,city,pid) VALUES (13, '衡水市', 3);
INSERT INTO city(id,city,pid) VALUES (14, '太原市', 4);
INSERT INTO city(id,city,pid) VALUES (15, '大同市', 4);
INSERT INTO city(id,city,pid) VALUES (16, '阳泉市', 4);
INSERT INTO city(id,city,pid) VALUES (17, '长治市', 4);
INSERT INTO city(id,city,pid) VALUES (18, '晋城市', 4);
INSERT INTO city(id,city,pid) VALUES (19, '朔州市', 4);
INSERT INTO city(id,city,pid) VALUES (20, '晋中市', 4);
INSERT INTO city(id,city,pid) VALUES (21, '运城市', 4);
INSERT INTO city(id,city,pid) VALUES (22, '忻州市', 4);
INSERT INTO city(id,city,pid) VALUES (23, '临汾市', 4);
INSERT INTO city(id,city,pid) VALUES (24, '吕梁市', 4);
INSERT INTO city(id,city,pid) VALUES (25, '呼和浩特市', 5);
INSERT INTO city(id,city,pid) VALUES (26, '包头市', 5);
INSERT INTO city(id,city,pid) VALUES (27, '乌海市', 5);
INSERT INTO city(id,city,pid) VALUES (28, '赤峰市', 5);
INSERT INTO city(id,city,pid) VALUES (29, '通辽市', 5);
INSERT INTO city(id,city,pid) VALUES (30, '鄂尔多斯市', 5);
INSERT INTO city(id,city,pid) VALUES (31, '呼伦贝尔市', 5);
INSERT INTO city(id,city,pid) VALUES (32, '巴彦淖尔市', 5);
INSERT INTO city(id,city,pid) VALUES (33, '乌兰察布市', 5);
INSERT INTO city(id,city,pid) VALUES (34, '兴安盟', 5);
INSERT INTO city(id,city,pid) VALUES (35, '锡林郭勒盟', 5);
INSERT INTO city(id,city,pid) VALUES (36, '阿拉善盟', 5);
INSERT INTO city(id,city,pid) VALUES (37, '沈阳市', 6);
INSERT INTO city(id,city,pid) VALUES (38, '大连市', 6);
INSERT INTO city(id,city,pid) VALUES (39, '鞍山市', 6);
INSERT INTO city(id,city,pid) VALUES (40, '抚顺市', 6);
INSERT INTO city(id,city,pid) VALUES (41, '本溪市', 6);
INSERT INTO city(id,city,pid) VALUES (42, '丹东市', 6);
INSERT INTO city(id,city,pid) VALUES (43, '锦州市', 6);
INSERT INTO city(id,city,pid) VALUES (44, '营口市', 6);
INSERT INTO city(id,city,pid) VALUES (45, '阜新市', 6);
INSERT INTO city(id,city,pid) VALUES (46, '辽阳市', 6);
INSERT INTO city(id,city,pid) VALUES (47, '盘锦市', 6);
INSERT INTO city(id,city,pid) VALUES (48, '铁岭市', 6);
INSERT INTO city(id,city,pid) VALUES (49, '朝阳市', 6);
INSERT INTO city(id,city,pid) VALUES (50, '葫芦岛市', 6);
INSERT INTO city(id,city,pid) VALUES (51, '长春市', 7);
INSERT INTO city(id,city,pid) VALUES (52, '吉林市', 7);
INSERT INTO city(id,city,pid) VALUES (53, '四平市', 7);
INSERT INTO city(id,city,pid) VALUES (54, '辽源市', 7);
INSERT INTO city(id,city,pid) VALUES (55, '通化市', 7);
INSERT INTO city(id,city,pid) VALUES (56, '白山市', 7);
INSERT INTO city(id,city,pid) VALUES (57, '松原市', 7);
INSERT INTO city(id,city,pid) VALUES (58, '白城市', 7);
INSERT INTO city(id,city,pid) VALUES (59, '延边朝鲜族自治州', 7);
INSERT INTO city(id,city,pid) VALUES (60, '哈尔滨市', 8);
INSERT INTO city(id,city,pid) VALUES (61, '齐齐哈尔市', 8);
INSERT INTO city(id,city,pid) VALUES (62, '鸡西市', 8);
INSERT INTO city(id,city,pid) VALUES (63, '鹤岗市', 8);
INSERT INTO city(id,city,pid) VALUES (64, '双鸭山市', 8);
INSERT INTO city(id,city,pid) VALUES (65, '大庆市', 8);
INSERT INTO city(id,city,pid) VALUES (66, '伊春市', 8);
INSERT INTO city(id,city,pid) VALUES (67, '佳木斯市', 8);
INSERT INTO city(id,city,pid) VALUES (68, '七台河市', 8);
INSERT INTO city(id,city,pid) VALUES (69, '牡丹江市', 8);
INSERT INTO city(id,city,pid) VALUES (70, '黑河市', 8);
INSERT INTO city(id,city,pid) VALUES (71, '绥化市', 8);
INSERT INTO city(id,city,pid) VALUES (72, '大兴安岭地区', 8);
INSERT INTO city(id,city,pid) VALUES (73, '上海市', 9);
INSERT INTO city(id,city,pid) VALUES (74, '南京市', 10);
INSERT INTO city(id,city,pid) VALUES (75, '无锡市', 10);
INSERT INTO city(id,city,pid) VALUES (76, '徐州市', 10);
INSERT INTO city(id,city,pid) VALUES (77, '常州市', 10);
INSERT INTO city(id,city,pid) VALUES (78, '苏州市', 10);
INSERT INTO city(id,city,pid) VALUES (79, '南通市', 10);
INSERT INTO city(id,city,pid) VALUES (80, '连云港市', 10);
INSERT INTO city(id,city,pid) VALUES (81, '淮安市', 10);
INSERT INTO city(id,city,pid) VALUES (82, '盐城市', 10);
INSERT INTO city(id,city,pid) VALUES (83, '扬州市', 10);
INSERT INTO city(id,city,pid) VALUES (84, '镇江市', 10);
INSERT INTO city(id,city,pid) VALUES (85, '泰州市', 10);
INSERT INTO city(id,city,pid) VALUES (86, '宿迁市', 10);
INSERT INTO city(id,city,pid) VALUES (87, '杭州市', 11);
INSERT INTO city(id,city,pid) VALUES (88, '宁波市', 11);
INSERT INTO city(id,city,pid) VALUES (89, '温州市', 11);
INSERT INTO city(id,city,pid) VALUES (90, '嘉兴市', 11);
INSERT INTO city(id,city,pid) VALUES (91, '湖州市', 11);
INSERT INTO city(id,city,pid) VALUES (92, '绍兴市', 11);
INSERT INTO city(id,city,pid) VALUES (93, '金华市', 11);
INSERT INTO city(id,city,pid) VALUES (94, '衢州市', 11);
INSERT INTO city(id,city,pid) VALUES (95, '舟山市', 11);
INSERT INTO city(id,city,pid) VALUES (96, '台州市', 11);
INSERT INTO city(id,city,pid) VALUES (97, '丽水市', 11);
INSERT INTO city(id,city,pid) VALUES (98, '合肥市', 12);
INSERT INTO city(id,city,pid) VALUES (99, '芜湖市', 12);
INSERT INTO city(id,city,pid) VALUES (100, '蚌埠市', 12);
INSERT INTO city(id,city,pid) VALUES (101, '淮南市', 12);
INSERT INTO city(id,city,pid) VALUES (102, '马鞍山市', 12);
INSERT INTO city(id,cit