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