qxL6qtjv

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