中國全省市表 · 音視頻/C++/k8s/Docker等等學習筆記

```php DROP TABLE IF EXISTS `province`; CREATE TABLE `province` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=gbk; -- ---------------------------- -- Records of province -- ---------------------------- INSERT INTO `province` VALUES ('1', '北京市'); INSERT INTO `province` VALUES ('2', '天津市'); INSERT INTO `province` VALUES ('3', '上海市'); INSERT INTO `province` VALUES ('4', '重慶市'); INSERT INTO `province` VALUES ('5', '河北省'); INSERT INTO `province` VALUES ('6', '山西省'); INSERT INTO `province` VALUES ('7', '臺灣省'); INSERT INTO `province` VALUES ('8', '遼寧省'); INSERT INTO `province` VALUES ('9', '吉林省'); INSERT INTO `province` VALUES ('10', '黑龍江省'); INSERT INTO `province` VALUES ('11', '江蘇省'); INSERT INTO `province` VALUES ('12', '浙江省'); INSERT INTO `province` VALUES ('13', '安徽省'); INSERT INTO `province` VALUES ('14', '福建省'); INSERT INTO `province` VALUES ('15', '江西省'); INSERT INTO `province` VALUES ('16', '山東省'); INSERT INTO `province` VALUES ('17', '河南省'); INSERT INTO `province` VALUES ('18', '湖北省'); INSERT INTO `province` VALUES ('19', '湖南省'); INSERT INTO `province` VALUES ('20', '廣東省'); INSERT INTO `province` VALUES ('21', '甘肅省'); INSERT INTO `province` VALUES ('22', '四川省'); INSERT INTO `province` VALUES ('23', '貴州省'); INSERT INTO `province` VALUES ('24', '海南省'); INSERT INTO `province` VALUES ('25', '云南省'); INSERT INTO `province` VALUES ('26', '青海省'); INSERT INTO `province` VALUES ('27', '陜西省'); INSERT INTO `province` VALUES ('28', '廣西壯族自治區'); INSERT INTO `province` VALUES ('29', '西藏自治區'); INSERT INTO `province` VALUES ('30', '寧夏回族自治區'); INSERT INTO `province` VALUES ('31', '新疆維吾爾自治區'); INSERT INTO `province` VALUES ('32', '內蒙古自治區'); INSERT INTO `province` VALUES ('33', '澳門特別行政區'); INSERT INTO `province` VALUES ('34', '香港特別行政區'); -- ---------------------------- -- Table structure for `city` -- ---------------------------- DROP TABLE IF EXISTS `city`; CREATE TABLE `city` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city_index` int(11) NOT NULL, `province_id` int(11) NOT NULL, `name` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=392 DEFAULT CHARSET=gbk; -- ---------------------------- -- Records of city -- ---------------------------- INSERT INTO `city` VALUES ('1', '1', '1', '北京市'); INSERT INTO `city` VALUES ('2', '1', '2', '天津市'); INSERT INTO `city` VALUES ('3', '1', '3', '上海市'); INSERT INTO `city` VALUES ('4', '1', '4', '重慶市'); INSERT INTO `city` VALUES ('5', '1', '5', '石家莊市'); INSERT INTO `city` VALUES ('6', '2', '5', '唐山市'); INSERT INTO `city` VALUES ('7', '3', '5', '秦皇島市'); INSERT INTO `city` VALUES ('8', '4', '5', '邯鄲市'); INSERT INTO `city` VALUES ('9', '5', '5', '邢臺市'); INSERT INTO `city` VALUES ('10', '6', '5', '保定市'); INSERT INTO `city` VALUES ('11', '7', '5', '張家口市'); INSERT INTO `city` VALUES ('12', '8', '5', '承德市'); INSERT INTO `city` VALUES ('13', '9', '5', '滄州市'); INSERT INTO `city` VALUES ('14', '10', '5', '廊坊市'); INSERT INTO `city` VALUES ('15', '11', '5', '衡水市'); INSERT INTO `city` VALUES ('16', '1', '6', '太原市'); INSERT INTO `city` VALUES ('17', '2', '6', '大同市'); INSERT INTO `city` VALUES ('18', '3', '6', '陽泉市'); INSERT INTO `city` VALUES ('19', '4', '6', '長治市'); INSERT INTO `city` VALUES ('20', '5', '6', '晉城市'); INSERT INTO `city` VALUES ('21', '6', '6', '朔州市'); INSERT INTO `city` VALUES ('22', '7', '6', '晉中市'); INSERT INTO `city` VALUES ('23', '8', '6', '運城市'); INSERT INTO `city` VALUES ('24', '9', '6', '忻州市'); INSERT INTO `city` VALUES ('25', '10', '6', '臨汾市'); INSERT INTO `city` VALUES ('26', '11', '6', '呂梁市'); INSERT INTO `city` VALUES ('27', '1', '7', '臺北市'); INSERT INTO `city` VALUES ('28', '2', '7', '高雄市'); INSERT INTO `city` VALUES ('29', '3', '7', '基隆市'); INSERT INTO `city` VALUES ('30', '4', '7', '臺中市'); INSERT INTO `city` VALUES ('31', '5', '7', '臺南市'); INSERT INTO `city` VALUES ('32', '6', '7', '新竹市'); INSERT INTO `city` VALUES ('33', '7', '7', '嘉義市'); INSERT INTO `city` VALUES ('34', '8', '7', '臺北縣'); INSERT INTO `city` VALUES ('35', '9', '7', '宜蘭縣'); INSERT INTO `city` VALUES ('36', '10', '7', '桃園縣'); INSERT INTO `city` VALUES ('37', '11', '7', '新竹縣'); INSERT INTO `city` VALUES ('38', '12', '7', '苗栗縣'); INSERT INTO `city` VALUES ('39', '13', '7', '臺中縣'); INSERT INTO `city` VALUES ('40', '14', '7', '彰化縣'); INSERT INTO `city` VALUES ('41', '15', '7', '南投縣'); INSERT INTO `city` VALUES ('42', '16', '7', '云林縣'); INSERT INTO `city` VALUES ('43', '17', '7', '嘉義縣'); INSERT INTO `city` VALUES ('44', '18', '7', '臺南縣'); INSERT INTO `city` VALUES ('45', '19', '7', '高雄縣'); INSERT INTO `city` VALUES ('46', '20', '7', '屏東縣'); INSERT INTO `city` VALUES ('47', '21', '7', '澎湖縣'); INSERT INTO `city` VALUES ('48', '22', '7', '臺東縣'); INSERT INTO `city` VALUES ('49', '23', '7', '花蓮縣'); INSERT INTO `city` VALUES ('50', '1', '8', '沈陽市'); INSERT INTO `city` VALUES ('51', '2', '8', '大連市'); INSERT INTO `city` VALUES ('52', '3', '8', '鞍山市'); INSERT INTO `city` VALUES ('53', '4', '8', '撫順市'); INSERT INTO `city` VALUES ('54', '5', '8', '本溪市'); INSERT INTO `city` VALUES ('55', '6', '8', '丹東市'); INSERT INTO `city` VALUES ('56', '7', '8', '錦州市'); INSERT INTO `city` VALUES ('57', '8', '8', '營口市'); INSERT INTO `city` VALUES ('58', '9', '8', '阜新市'); INSERT INTO `city` VALUES ('59', '10', '8', '遼陽市'); INSERT INTO `city` VALUES ('60', '11', '8', '盤錦市'); INSERT INTO `city` VALUES ('61', '12', '8', '鐵嶺市'); INSERT INTO `city` VALUES ('62', '13', '8', '朝陽市'); INSERT INTO `city` VALUES ('63', '14', '8', '葫蘆島市'); INSERT INTO `city` VALUES ('64', '1', '9', '長春市'); INSERT INTO `city` VALUES ('65', '2', '9', '吉林市'); INSERT INTO `city` VALUES ('66', '3', '9', '四平市'); INSERT INTO `city` VALUES ('67', '4', '9', '遼源市'); INSERT INTO `city` VALUES ('68', '5', '9', '通化市'); INSERT INTO `city` VALUES ('69', '6', '9', '白山市'); INSERT INTO `city` VALUES ('70', '7', '9', '松原市'); INSERT INTO `city` VALUES ('71', '8', '9', '白城市'); INSERT INTO `city` VALUES ('72', '9', '9', '延邊朝鮮族自治州'); INSERT INTO `city` VALUES ('73', '1', '10', '哈爾濱市'); INSERT INTO `city` VALUES ('74', '2', '10', '齊齊哈爾市'); INSERT INTO `city` VALUES ('75', '3', '10', '鶴崗市'); INSERT INTO `city` VALUES ('76', '4', '10', '雙鴨山市'); INSERT INTO `city` VALUES ('77', '5', '10', '雞西市'); INSERT INTO `city` VALUES ('78', '6', '10', '大慶市'); INSERT INTO `city` VALUES ('79', '7', '10', '伊春市'); INSERT INTO `city` VALUES ('80', '8', '10', '牡丹江市'); INSERT INTO `city` VALUES ('81', '9', '10', '佳木斯市'); INSERT INTO `city` VALUES ('82', '10', '10', '七臺河市'); INSERT INTO `city` VALUES ('83', '11', '10', '黑河市'); INSERT INTO `city` VALUES ('84', '12', '10', '綏化市'); INSERT INTO `city` VALUES ('85', '13', '10', '大興安嶺地區'); INSERT INTO `city` VALUES ('86', '1', '11', '南京市'); INSERT INTO `city` VALUES ('87', '2', '11', '無錫市'); INSERT INTO `city` VALUES ('88', '3', '11', '徐州市'); INSERT INTO `city` VALUES ('89', '4', '11', '常州市'); INSERT INTO `city` VALUES ('90', '5', '11', '蘇州市'); INSERT INTO `city` VALUES ('91', '6', '11', '南通市'); INSERT INTO `city` VALUES ('92', '7', '11', '連云港市'); INSERT INTO `city` VALUES ('93', '8', '11', '淮安市'); INSERT INTO `city` VALUES ('94', '9', '11', '鹽城市'); INSERT INTO `city` VALUES ('95', '10', '11', '揚州市'); INSERT INTO `city` VALUES ('96', '11', '11', '鎮江市'); INSERT INTO `city` VALUES ('97', '12', '11', '泰州市'); INSERT INTO `city` VALUES ('98', '13', '11', '宿遷市'); INSERT INTO `city` VALUES ('99', '1', '12', '杭州市'); INSERT INTO `city` VALUES ('100', '2', '12', '寧波市'); INSERT INTO `city` VALUES ('101', '3', '12', '溫州市'); INSERT INTO `city` VALUES ('102', '4', '12', '嘉興市'); INSERT INTO `city` VALUES ('103', '5', '12', '湖州市'); INSERT INTO `city` VALUES ('104', '6', '12', '紹興市'); INSERT INTO `city` VALUES ('105', '7', '12', '金華市'); INSERT INTO `city` VALUES ('106', '8', '12', '衢州市'); INSERT INTO `city` VALUES ('107', '9', '12', '舟山市'); INSERT INTO `city` VALUES ('108', '10', '12', '臺州市'); INSERT INTO `city` VALUES ('109', '11', '12', '麗水市'); INSERT INTO `city` VALUES ('110', '1', '13', '合肥市'); INSERT INTO `city` VALUES ('111', '2', '13', '蕪湖市'); INSERT INTO `city` VALUES ('112', '3', '13', '蚌埠市'); INSERT INTO `city` VALUES ('113', '4', '13', '淮南市'); INSERT INTO `city` VALUES ('114', '5', '13', '馬鞍山市'); INSERT INTO `city` VALUES ('115', '6', '13', '淮北市'); INSERT INTO `city` VALUES ('116', '7', '13', '銅陵市'); INSERT INTO `city` VALUES ('117', '8', '13', '安慶市'); INSERT INTO `city` VALUES ('118', '9', '13', '黃山市'); INSERT INTO `city` VALUES ('119', '10', '13', '滁州市'); INSERT INTO `city` VALUES ('120', '11', '13', '阜陽市'); INSERT INTO `city` VALUES ('121', '12', '13', '宿州市'); INSERT INTO `city` VALUES ('122', '13', '13', '巢湖市'); INSERT INTO `city` VALUES ('123', '14', '13', '六安市'); INSERT INTO `city` VALUES ('124', '15', '13', '亳州市'); INSERT INTO `city` VALUES ('125', '16', '13', '池州市'); INSERT INTO `city` VALUES ('126', '17', '13', '宣城市'); INSERT INTO `city` VALUES ('127', '1', '14', '福州市'); INSERT INTO `city` VALUES ('128', '2', '14', '廈門市'); INSERT INTO `city` VALUES ('129', '3', '14', '莆田市'); INSERT INTO `city` VALUES ('130', '4', '14', '三明市'); INSERT INTO `city` VALUES ('131', '5', '14', '泉州市'); INSERT INTO `city` VALUES ('132', '6', '14', '漳州市'); INSERT INTO `city` VALUES ('133', '7', '14', '南平市'); INSERT INTO `city` VALUES ('134', '8', '14', '龍巖市'); INSERT INTO `city` VALUES ('135', '9', '14', '寧德市'); INSERT INTO `city` VALUES ('136', '1', '15', '南昌市'); INSERT INTO `city` VALUES ('137', '2', '15', '景德鎮市'); INSERT INTO `city` VALUES ('138', '3', '15', '萍鄉市'); INSERT INTO `city` VALUES ('139', '4', '15', '九江市'); INSERT INTO `city` VALUES ('140', '5', '15', '新余市'); INSERT INTO `city` VALUES ('141', '6', '15', '鷹潭市'); INSERT INTO `city` VALUES ('142', '7', '15', '贛州市'); INSERT INTO `city` VALUES ('143', '8', '15', '吉安市'); INSERT INTO `city` VALUES ('144', '9', '15', '宜春市'); INSERT INTO `city` VALUES ('145', '10', '15', '撫州市'); INSERT INTO `city` VALUES ('146', '11', '15', '上饒市'); INSERT INTO `city` VALUES ('147', '1', '16', '濟南市'); INSERT INTO `city` VALUES ('148', '2', '16', '青島市'); INSERT INTO `city` VALUES ('149', '3', '16', '淄博市'); INSERT INTO `city` VALUES ('150', '4', '16', '棗莊市'); INSERT INTO `city` VALUES ('151', '5', '16', '東營市'); INSERT INTO `city` VALUES ('152', '6', '16', '煙臺市'); INSERT INTO `city` VALUES ('153', '7', '16', '濰坊市'); INSERT INTO `city` VALUES ('154', '8', '16', '濟寧市'); INSERT INTO `city` VALUES ('155', '9', '16', '泰安市'); INSERT INTO `city` VALUES ('156', '10', '16', '威海市'); INSERT INTO `city` VALUES ('157', '11', '16', '日照市'); INSERT INTO `city` VALUES ('158', '12', '16', '萊蕪市'); INSERT INTO `city` VALUES ('159', '13', '16', '臨沂市'); INSERT INTO `city` VALUES ('160', '14', '16', '德州市'); INSERT INTO `city` VALUES ('161', '15', '16', '聊城市'); INSERT INTO `city` VALUES ('162', '16', '16', '濱州市'); INSERT INTO `city` VALUES ('163', '17', '16', '菏澤市'); INSERT INTO `city` VALUES ('164', '1', '17', '鄭州市'); INSERT INTO `city` VALUES ('165', '2', '17', '開封市'); INSERT INTO `city` VALUES ('166', '3', '17', '洛陽市'); INSERT INTO `city` VALUES ('167', '4', '17', '平頂山市'); INSERT INTO `city` VALUES ('168', '5', '17', '安陽市'); INSERT INTO `city` VALUES ('169', '6', '17', '鶴壁市'); INSERT INTO `city` VALUES ('170', '7', '17', '新鄉市'); INSERT INTO `city` VALUES ('171', '8', '17', '焦作市'); INSERT INTO `city` VALUES ('172', '9', '17', '濮陽市'); INSERT INTO `city` VALUES ('173', '10', '17', '許昌市'); INSERT INTO `city` VALUES ('174', '11', '17', '漯河市'); INSERT INTO `city` VALUES ('175', '12', '17', '三門峽市'); INSERT INTO `city` VALUES ('176', '13', '17', '南陽市'); INSERT INTO `city` VALUES ('177', '14', '17', '商丘市'); INSERT INTO `city` VALUES ('178', '15', '17', '信陽市'); INSERT INTO `city` VALUES ('179', '16', '17', '周口市'); INSERT INTO `city` VALUES ('180', '17', '17', '駐馬店市'); INSERT INTO `city` VALUES ('181', '18', '17', '濟源市'); INSERT INTO `city` VALUES ('182', '1', '18', '武漢市'); INSERT INTO `city` VALUES ('183', '2', '18', '黃石市'); INSERT INTO `city` VALUES ('184', '3', '18', '十堰市'); INSERT INTO `city` VALUES ('185', '4', '18', '荊州市'); INSERT INTO `city` VALUES ('186', '5', '18', '宜昌市'); INSERT INTO `city` VALUES ('187', '6', '18', '襄樊市'); INSERT INTO `city` VALUES ('188', '7', '18', '鄂州市'); INSERT INTO `city` VALUES ('189', '8', '18', '荊門市'); INSERT INTO `city` VALUES ('190', '9', '18', '孝感市'); INSERT INTO `city` VALUES ('191', '10', '18', '黃岡市'); INSERT INTO `city` VALUES ('192', '11', '18', '咸寧市'); INSERT INTO `city` VALUES ('193', '12', '18', '隨州市'); INSERT INTO `city` VALUES ('194', '13', '18', '仙桃市'); INSERT INTO `city` VALUES ('195', '14', '18', '天門市'); INSERT INTO `city` VALUES ('196', '15', '18', '潛江市'); INSERT INTO `city` VALUES ('197', '16', '18', '神農架林區'); INSERT INTO `city` VALUES ('198', '17', '18', '恩施土家族苗族自治州'); INSERT INTO `city` VALUES ('199', '1', '19', '長沙市'); INSERT INTO `city` VALUES ('200', '2', '19', '株洲市'); INSERT INTO `city` VALUES ('201', '3', '19', '湘潭市'); INSERT INTO `city` VALUES ('202', '4', '19', '衡陽市'); INSERT INTO `city` VALUES ('203', '5', '19', '邵陽市'); INSERT INTO `city` VALUES ('204', '6', '19', '岳陽市'); INSERT INTO `city` VALUES ('205', '7', '19', '常德市'); INSERT INTO `city` VALUES ('206', '8', '19', '張家界市'); INSERT INTO `city` VALUES ('207', '9', '19', '益陽市'); INSERT INTO `city` VALUES ('208', '10', '19', '郴州市'); INSERT INTO `city` VALUES ('209', '11', '19', '永州市'); INSERT INTO `city` VALUES ('210', '12', '19', '懷化市'); INSERT INTO `city` VALUES ('211', '13', '19', '婁底市'); INSERT INTO `city` VALUES ('212', '14', '19', '湘西土家族苗族自治州'); INSERT INTO `city` VALUES ('213', '1', '20', '廣州市'); INSERT INTO `city` VALUES ('214', '2', '20', '深圳市'); INSERT INTO `city` VALUES ('215', '3', '20', '珠海市'); INSERT INTO `city` VALUES ('216', '4', '20', '汕頭市'); INSERT INTO `city` VALUES ('217', '5', '20', '韶關市'); INSERT INTO `city` VALUES ('218', '6', '20', '佛山市'); INSERT INTO `city` VALUES ('219', '7', '20', '江門市'); INSERT INTO `city` VALUES ('220', '8', '20', '湛江市'); INSERT INTO `city` VALUES ('221', '9', '20', '茂名市'); INSERT INTO `city` VALUES ('222', '10', '20', '肇慶市'); INSERT INTO `city` VALUES ('223', '11', '20', '惠州市'); INSERT INTO `city` VALUES ('224', '12', '20', '梅州市'); INSERT INTO `city` VALUES ('225', '13', '20', '汕尾市'); INSERT INTO `city` VALUES ('226', '14', '20', '河源市'); INSERT INTO `city` VALUES ('227', '15', '20', '陽江市'); INSERT INTO `city` VALUES ('228', '16', '20', '清遠市'); INSERT INTO `city` VALUES ('229', '17', '20', '東莞市'); INSERT INTO `city` VALUES ('230', '18', '20', '中山市'); INSERT INTO `city` VALUES ('231', '19', '20', '潮州市'); INSERT INTO `city` VALUES ('232', '20', '20', '揭陽市'); INSERT INTO `city` VALUES ('233', '21', '20', '云浮市'); INSERT INTO `city` VALUES ('234', '1', '21', '蘭州市'); INSERT INTO `city` VALUES ('235', '2', '21', '金昌市'); INSERT INTO `city` VALUES ('236', '3', '21', '白銀市'); INSERT INTO `city` VALUES ('237', '4', '21', '天水市'); INSERT INTO `city` VALUES ('238', '5', '21', '嘉峪關市'); INSERT INTO `city` VALUES ('239', '6', '21', '武威市'); INSERT INTO `city` VALUES ('240', '7', '21', '張掖市'); INSERT INTO `city` VALUES ('241', '8', '21', '平涼市'); INSERT INTO `city` VALUES ('242', '9', '21', '酒泉市'); INSERT INTO `city` VALUES ('243', '10', '21', '慶陽市'); INSERT INTO `city` VALUES ('244', '11', '21', '定西市'); INSERT INTO `city` VALUES ('245', '12', '21', '隴南市'); INSERT INTO `city` VALUES ('246', '13', '21', '臨夏回族自治州'); INSERT INTO `city` VALUES ('247', '14', '21', '甘南藏族自治州'); INSERT INTO `city` VALUES ('248', '1', '22', '成都市'); INSERT INTO `city` VALUES ('249', '2', '22', '自貢市'); INSERT INTO `city` VALUES ('250', '3', '22', '攀枝花市'); INSERT INTO `city` VALUES ('251', '4', '22', '瀘州市'); INSERT INTO `city` VALUES ('252', '5', '22', '德陽市'); INSERT INTO `city` VALUES ('253', '6', '22', '綿陽市'); INSERT INTO `city` VALUES ('254', '7', '22', '廣元市'); INSERT INTO `city` VALUES ('255', '8', '22', '遂寧市'); INSERT INTO `city` VALUES ('256', '9', '22', '內江市'); INSERT INTO `city` VALUES ('257', '10', '22', '樂山市'); INSERT INTO `city` VALUES ('258', '11', '22', '南充市'); INSERT INTO `city` VALUES ('259', '12', '22', '眉山市'); INSERT INTO `city` VALUES ('260', '13', '22', '宜賓市'); INSERT INTO `city` VALUES ('261', '14', '22', '廣安市'); INSERT INTO `city` VALUES ('262', '15', '22', '達州市'); INSERT INTO `city` VALUES ('263', '16', '22', '雅安市'); INSERT INTO `city` VALUES ('264', '17', '22', '巴中市'); INSERT INTO `city` VALUES ('265', '18', '22', '資陽市'); INSERT INTO `city` VALUES ('266', '19', '22', '阿壩藏族羌族自治州'); INSERT INTO `city` VALUES ('267', '20', '22', '甘孜藏族自治州'); INSERT INTO `city` VALUES ('268', '21', '22', '涼山彝族自治州'); INSERT INTO `city` VALUES ('269', '1', '23', '貴陽市'); INSERT INTO `city` VALUES ('270', '2', '23', '六盤水市'); INSERT INTO `city` VALUES ('271', '3', '23', '遵義市'); INSERT INTO `city` VALUES ('272', '4', '23', '安順市'); INSERT INTO `city` VALUES ('273', '5', '23', '銅仁地區'); INSERT INTO `city` VALUES ('274', '6', '23', '畢節地區'); INSERT INTO `city` VALUES ('275', '7', '23', '黔西南布依族苗族自治州'); INSERT INTO `city` VALUES ('276', '8', '23', '黔東南苗族侗族自治州'); INSERT INTO `city` VALUES ('277', '9', '23', '黔南布依族苗族自治州'); INSERT INTO `city` VALUES ('278', '1', '24', '海口市'); INSERT INTO `city` VALUES ('279', '2', '24', '三亞市'); INSERT INTO `city` VALUES ('280', '3', '24', '五指山市'); INSERT INTO `city` VALUES ('281', '4', '24', '瓊海市'); INSERT INTO `city` VALUES ('282', '5', '24', '儋州市'); INSERT INTO `city` VALUES ('283', '6', '24', '文昌市'); INSERT INTO `city` VALUES ('284', '7', '24', '萬寧市'); INSERT INTO `city` VALUES ('285', '8', '24', '東方市'); INSERT INTO `city` VALUES ('286', '9', '24', '澄邁縣'); INSERT INTO `city` VALUES ('287', '10', '24', '定安縣'); INSERT INTO `city` VALUES ('288', '11', '24', '屯昌縣'); INSERT INTO `city` VALUES ('289', '12', '24', '臨高縣'); INSERT INTO `city` VALUES ('290', '13', '24', '白沙黎族自治縣'); INSERT INTO `city` VALUES ('291', '14', '24', '昌江黎族自治縣'); INSERT INTO `city` VALUES ('292', '15', '24', '樂東黎族自治縣'); INSERT INTO `city` VALUES ('293', '16', '24', '陵水黎族自治縣'); INSERT INTO `city` VALUES ('294', '17', '24', '保亭黎族苗族自治縣'); INSERT INTO `city` VALUES ('295', '18', '24', '瓊中黎族苗族自治縣'); INSERT INTO `city` VALUES ('296', '1', '25', '昆明市'); INSERT INTO `city` VALUES ('297', '2', '25', '曲靖市'); INSERT INTO `city` VALUES ('298', '3', '25', '玉溪市'); INSERT INTO `city` VALUES ('299', '4', '25', '保山市'); INSERT INTO `city` VALUES ('300', '5', '25', '昭通市'); INSERT INTO `city` VALUES ('301', '6', '25', '麗江市'); INSERT INTO `city` VALUES ('302', '7', '25', '思茅市'); INSERT INTO `city` VALUES ('303', '8', '25', '臨滄市'); INSERT INTO `city` VALUES ('304', '9', '25', '文山壯族苗族自治州'); INSERT INTO `city` VALUES ('305', '10', '25', '紅河哈尼族彝族自治州'); INSERT INTO `city` VALUES ('306', '11', '25', '西雙版納傣族自治州'); INSERT INTO `city` VALUES ('307', '12', '25', '楚雄彝族自治州'); INSERT INTO `city` VALUES ('308', '13', '25', '大理白族自治州'); INSERT INTO `city` VALUES ('309', '14', '25', '德宏傣族景頗族自治州'); INSERT INTO `city` VALUES ('310', '15', '25', '怒江傈傈族自治州'); INSERT INTO `city` VALUES ('311', '16', '25', '迪慶藏族自治州'); INSERT INTO `city` VALUES ('312', '1', '26', '西寧市'); INSERT INTO `city` VALUES ('313', '2', '26', '海東地區'); INSERT INTO `city` VALUES ('314', '3', '26', '海北藏族自治州'); INSERT INTO `city` VALUES ('315', '4', '26', '黃南藏族自治州'); INSERT INTO `city` VALUES ('316', '5', '26', '海南藏族自治州'); INSERT INTO `city` VALUES ('317', '6', '26', '果洛藏族自治州'); INSERT INTO `city` VALUES ('318', '7', '26', '玉樹藏族自治州'); INSERT INTO `city` VALUES ('319', '8', '26', '海西蒙古族藏族自治州'); INSERT INTO `city` VALUES ('320', '1', '27', '西安市'); INSERT INTO `city` VALUES ('321', '2', '27', '銅川市'); INSERT INTO `city` VALUES ('322', '3', '27', '寶雞市'); INSERT INTO `city` VALUES ('323', '4', '27', '咸陽市'); INSERT INTO `city` VALUES ('324', '5', '27', '渭南市'); INSERT INTO `city` VALUES ('325', '6', '27', '延安市'); INSERT INTO `city` VALUES ('326', '7', '27', '漢中市'); INSERT INTO `city` VALUES ('327', '8', '27', '榆林市'); INSERT INTO `city` VALUES ('328', '9', '27', '安康市'); INSERT INTO `city` VALUES ('329', '10', '27', '商洛市'); INSERT INTO `city` VALUES ('330', '1', '28', '南寧市'); INSERT INTO `city` VALUES ('331', '2', '28', '柳州市'); INSERT INTO `city` VALUES ('332', '3', '28', '桂林市'); INSERT INTO `city` VALUES ('333', '4', '28', '梧州市'); INSERT INTO `city` VALUES ('334', '5', '28', '北海市'); INSERT INTO `city` VALUES ('335', '6', '28', '防城港市'); INSERT INTO `city` VALUES ('336', '7', '28', '欽州市'); INSERT INTO `city` VALUES ('337', '8', '28', '貴港市'); INSERT INTO `city` VALUES ('338', '9', '28', '玉林市'); INSERT INTO `city` VALUES ('339', '10', '28', '百色市'); INSERT INTO `city` VALUES ('340', '11', '28', '賀州市'); INSERT INTO `city` VALUES ('341', '12', '28', '河池市'); INSERT INTO `city` VALUES ('342', '13', '28', '來賓市'); INSERT INTO `city` VALUES ('343', '14', '28', '崇左市'); INSERT INTO `city` VALUES ('344', '1', '29', '拉薩市'); INSERT INTO `city` VALUES ('345', '2', '29', '那曲地區'); INSERT INTO `city` VALUES ('346', '3', '29', '昌都地區'); INSERT INTO `city` VALUES ('347', '4', '29', '山南地區'); INSERT INTO `city` VALUES ('348', '5', '29', '日喀則地區'); INSERT INTO `city` VALUES ('349', '6', '29', '阿里地區'); INSERT INTO `city` VALUES ('350', '7', '29', '林芝地區'); INSERT INTO `city` VALUES ('351', '1', '30', '銀川市'); INSERT INTO `city` VALUES ('352', '2', '30', '石嘴山市'); INSERT INTO `city` VALUES ('353', '3', '30', '吳忠市'); INSERT INTO `city` VALUES ('354', '4', '30', '固原市'); INSERT INTO `city` VALUES ('355', '5', '30', '中衛市'); INSERT INTO `city` VALUES ('356', '1', '31', '烏魯木齊市'); INSERT INTO `city` VALUES ('357', '2', '31', '克拉瑪依市'); INSERT INTO `city` VALUES ('358', '3', '31', '石河子市　'); INSERT INTO `city` VALUES ('359', '4', '31', '阿拉爾市'); INSERT INTO `city` VALUES ('360', '5', '31', '圖木舒克市'); INSERT INTO `city` VALUES ('361', '6', '31', '五家渠市'); INSERT INTO `city` VALUES ('362', '7', '31', '吐魯番市'); INSERT INTO `city` VALUES ('363', '8', '31', '阿克蘇市'); INSERT INTO `city` VALUES ('364', '9', '31', '喀什市'); INSERT INTO `city` VALUES ('365', '10', '31', '哈密市'); INSERT INTO `city` VALUES ('366', '11', '31', '和田市'); INSERT INTO `city` VALUES ('367', '12', '31', '阿圖什市'); INSERT INTO `city` VALUES ('368', '13', '31', '庫爾勒市'); INSERT INTO `city` VALUES ('369', '14', '31', '昌吉市　'); INSERT INTO `city` VALUES ('370', '15', '31', '阜康市'); INSERT INTO `city` VALUES ('371', '16', '31', '米泉市'); INSERT INTO `city` VALUES ('372', '17', '31', '博樂市'); INSERT INTO `city` VALUES ('373', '18', '31', '伊寧市'); INSERT INTO `city` VALUES ('374', '19', '31', '奎屯市'); INSERT INTO `city` VALUES ('375', '20', '31', '塔城市'); INSERT INTO `city` VALUES ('376', '21', '31', '烏蘇市'); INSERT INTO `city` VALUES ('377', '22', '31', '阿勒泰市'); INSERT INTO `city` VALUES ('378', '1', '32', '呼和浩特市'); INSERT INTO `city` VALUES ('379', '2', '32', '包頭市'); INSERT INTO `city` VALUES ('380', '3', '32', '烏海市'); INSERT INTO `city` VALUES ('381', '4', '32', '赤峰市'); INSERT INTO `city` VALUES ('382', '5', '32', '通遼市'); INSERT INTO `city` VALUES ('383', '6', '32', '鄂爾多斯市'); INSERT INTO `city` VALUES ('384', '7', '32', '呼倫貝爾市'); INSERT INTO `city` VALUES ('385', '8', '32', '巴彥淖爾市'); INSERT INTO `city` VALUES ('386', '9', '32', '烏蘭察布市'); INSERT INTO `city` VALUES ('387', '10', '32', '錫林郭勒盟'); INSERT INTO `city` VALUES ('388', '11', '32', '興安盟'); INSERT INTO `city` VALUES ('389', '12', '32', '阿拉善盟'); INSERT INTO `city` VALUES ('390', '1', '33', '澳門特別行政區'); INSERT INTO `city` VALUES ('391', '1', '34', '香港特別行政區'); ```