省市縣三級(jí)聯(lián)動(dòng)的SQL語(yǔ)句
發(fā)布日期:2021-12-29 00:29 | 文章來(lái)源:gibhub
復(fù)制代碼 代碼如下:
CREATE TABLE `t_address_province` (
`id` INT AUTO_INCREMENT PRIMARY KEY COMMENT '主鍵',
`code` CHAR(6) NOT NULL COMMENT '省份編碼',
`name` VARCHAR(40) NOT NULL COMMENT '省份名稱'
) ENGINE=InnoDB DEFAULT CHARSET=UTF8 COMMENT='省份信息表';
CREATE TABLE `t_address_city` (
`id` INT AUTO_INCREMENT PRIMARY KEY COMMENT '主鍵',
`code` CHAR(6) NOT NULL COMMENT '城市編碼',
`name` VARCHAR(40) NOT NULL COMMENT '城市名稱',
`provinceCode` CHAR(6) NOT NULL COMMENT '所屬省份編碼'
) ENGINE=InnoDB DEFAULT CHARSET=UTF8 COMMENT='城市信息表';
CREATE TABLE `t_address_town` (
`id` INT AUTO_INCREMENT PRIMARY KEY COMMENT '主鍵',
`code` CHAR(6) NOT NULL COMMENT '區(qū)縣編碼',
`name` VARCHAR(40) NOT NULL COMMENT '區(qū)縣名稱',
`cityCode` CHAR(6) NOT NULL COMMENT '所屬城市編碼'
) ENGINE=InnoDB DEFAULT CHARSET=UTF8 COMMENT='區(qū)縣信息表';
然后是省份信息表數(shù)據(jù)
復(fù)制代碼 代碼如下:
INSERT INTO `t_address_province` VALUES ('1', '110000', '北京市');
INSERT INTO `t_address_province` VALUES ('2', '120000', '天津市');
INSERT INTO `t_address_province` VALUES ('3', '130000', '河北省');
INSERT INTO `t_address_province` VALUES ('4', '140000', '山西省');
INSERT INTO `t_address_province` VALUES ('5', '150000', '內(nèi)蒙古自治區(qū)');
INSERT INTO `t_address_province` VALUES ('6', '210000', '遼寧省');
INSERT INTO `t_address_province` VALUES ('7', '220000', '吉林省');
INSERT INTO `t_address_province` VALUES ('8', '230000', '黑龍江省');
INSERT INTO `t_address_province` VALUES ('9', '310000', '上海市');
INSERT INTO `t_address_province` VALUES ('10', '320000', '江蘇省');
INSERT INTO `t_address_province` VALUES ('11', '330000', '浙江省');
INSERT INTO `t_address_province` VALUES ('12', '340000', '安徽省');
INSERT INTO `t_address_province` VALUES ('13', '350000', '福建省');
INSERT INTO `t_address_province` VALUES ('14', '360000', '江西省');
INSERT INTO `t_address_province` VALUES ('15', '370000', '山東省');
INSERT INTO `t_address_province` VALUES ('16', '410000', '河南省');
INSERT INTO `t_address_province` VALUES ('17', '420000', '湖北省');
INSERT INTO `t_address_province` VALUES ('18', '430000', '湖南省');
INSERT INTO `t_address_province` VALUES ('19', '440000', '廣東省');
INSERT INTO `t_address_province` VALUES ('20', '450000', '廣西壯族自治區(qū)');
INSERT INTO `t_address_province` VALUES ('21', '460000', '海南省');
INSERT INTO `t_address_province` VALUES ('22', '500000', '重慶市');
INSERT INTO `t_address_province` VALUES ('23', '510000', '四川省');
INSERT INTO `t_address_province` VALUES ('24', '520000', '貴州省');
INSERT INTO `t_address_province` VALUES ('25', '530000', '云南省');
INSERT INTO `t_address_province` VALUES ('26', '540000', '西藏自治區(qū)');
INSERT INTO `t_address_province` VALUES ('27', '610000', '陜西省');
INSERT INTO `t_address_province` VALUES ('28', '620000', '甘肅省');
INSERT INTO `t_address_province` VALUES ('29', '630000', '青海省');
INSERT INTO `t_address_province` VALUES ('30', '640000', '寧夏回族自治區(qū)');
INSERT INTO `t_address_province` VALUES ('31', '650000', '新疆維吾爾自治區(qū)');
INSERT INTO `t_address_province` VALUES ('32', '710000', '臺(tái)灣省');
INSERT INTO `t_address_province` VALUES ('33', '810000', '香港特別行政區(qū)');
INSERT INTO `t_address_province` VALUES ('34', '820000', '澳門特別行政區(qū)');
下面是城市信息表數(shù)據(jù)
復(fù)制代碼 代碼如下:
INSERT INTO `t_address_city` VALUES ('1', '110100', '北京市', '110000');
INSERT INTO `t_address_city` VALUES ('2', '1102xx', '北京下屬縣', '1100xx');
INSERT INTO `t_address_city` VALUES ('3', '120100', '天津市', '120000');
INSERT INTO `t_address_city` VALUES ('4', '1202xx', '天津下屬縣', '1200xx');
INSERT INTO `t_address_city` VALUES ('5', '130100', '石家莊市', '130000');
INSERT INTO `t_address_city` VALUES ('6', '130200', '唐山市', '130000');
INSERT INTO `t_address_city` VALUES ('7', '130300', '秦皇島市', '130000');
INSERT INTO `t_address_city` VALUES ('8', '130400', '邯鄲市', '130000');
INSERT INTO `t_address_city` VALUES ('9', '130500', '邢臺(tái)市', '130000');
INSERT INTO `t_address_city` VALUES ('10', '130600', '保定市', '130000');
INSERT INTO `t_address_city` VALUES ('11', '130700', '張家口市', '130000');
INSERT INTO `t_address_city` VALUES ('12', '130800', '承德市', '130000');
INSERT INTO `t_address_city` VALUES ('13', '130900', '滄州市', '130000');
INSERT INTO `t_address_city` VALUES ('14', '131000', '廊坊市', '130000');
INSERT INTO `t_address_city` VALUES ('15', '131100', '衡水市', '130000');
INSERT INTO `t_address_city` VALUES ('16', '140100', '太原市', '140000');
INSERT INTO `t_address_city` VALUES ('17', '140200', '大同市', '140000');
INSERT INTO `t_address_city` VALUES ('18', '140300', '陽(yáng)泉市', '140000');
INSERT INTO `t_address_city` VALUES ('19', '140400', '長(zhǎng)治市', '140000');
INSERT INTO `t_address_city` VALUES ('20', '140500', '晉城市', '140000');
INSERT INTO `t_address_city` VALUES ('21', '140600', '朔州市', '140000');
INSERT INTO `t_address_city` VALUES ('22', '140700', '晉中市', '140000');
INSERT INTO `t_address_city` VALUES ('23', '140800', '運(yùn)城市', '140000');
INSERT INTO `t_address_city` VALUES ('24', '140900', '忻州市', '140000');
INSERT INTO `t_address_city` VALUES ('25', '141000', '臨汾市', '140000');
INSERT INTO `t_address_city` VALUES ('26', '141100', '呂梁市', '140000');
INSERT INTO `t_address_city` VALUES ('27', '150100', '呼和浩特市', '150000');
INSERT INTO `t_address_city` VALUES ('28', '150200', '包頭市', '150000');
INSERT INTO `t_address_city` VALUES ('29', '150300', '烏海市', '150000');
INSERT INTO `t_address_city` VALUES ('30', '150400', '赤峰市', '150000');
INSERT INTO `t_address_city` VALUES ('31', '150500', '通遼市', '150000');
INSERT INTO `t_address_city` VALUES ('32', '150600', '鄂爾多斯市', '150000');
INSERT INTO `t_address_city` VALUES ('33', '150700', '呼倫貝爾市', '150000');
INSERT INTO `t_address_city` VALUES ('34', '150800', '巴彥淖爾市', '150000');
INSERT INTO `t_address_city` VALUES ('35', '150900', '烏蘭察布市', '150000');
INSERT INTO `t_address_city` VALUES ('36', '152200', '興安盟', '150000');
INSERT INTO `t_address_city` VALUES ('37', '152500', '錫林郭勒盟', '150000');
INSERT INTO `t_address_city` VALUES ('38', '152900', '阿拉善盟', '150000');
INSERT INTO `t_address_city` VALUES ('39', '210100', '沈陽(yáng)市', '210000');
INSERT INTO `t_address_city` VALUES ('40', '210200', '大連市', '210000');
INSERT INTO `t_address_city` VALUES ('41', '210300', '鞍山市', '210000');
INSERT INTO `t_address_city` VALUES ('42', '210400', '撫順市', '210000');
INSERT INTO `t_address_city` VALUES ('43', '210500', '本溪市', '210000');
INSERT INTO `t_address_city` VALUES ('44', '210600', '丹東市', '210000');
INSERT INTO `t_address_city` VALUES ('45', '210700', '錦州市', '210000');
INSERT INTO `t_address_city` VALUES ('46', '210800', '營(yíng)口市', '210000');
INSERT INTO `t_address_city` VALUES ('47', '210900', '阜新市', '210000');
INSERT INTO `t_address_city` VALUES ('48', '211000', '遼陽(yáng)市', '210000');
INSERT INTO `t_address_city` VALUES ('49', '211100', '盤錦市', '210000');
INSERT INTO `t_address_city` VALUES ('50', '211200', '鐵嶺市', '210000');
INSERT INTO `t_address_city` VALUES ('51', '211300', '朝陽(yáng)市', '210000');
INSERT INTO `t_address_city` VALUES ('52', '211400', '葫蘆島市', '210000');
INSERT INTO `t_address_city` VALUES ('53', '220100', '長(zhǎng)春市', '220000');
INSERT INTO `t_address_city` VALUES ('54', '220200', '吉林市', '220000');
INSERT INTO `t_address_city` VALUES ('55', '220300', '四平市', '220000');
INSERT INTO `t_address_city` VALUES ('56', '220400', '遼源市', '220000');
INSERT INTO `t_address_city` VALUES ('57', '220500', '通化市', '220000');
INSERT INTO `t_address_city` VALUES ('58', '220600', '白山市', '220000');
INSERT INTO `t_address_city` VALUES ('59', '220700', '松原市', '220000');
INSERT INTO `t_address_city` VALUES ('60', '220800', '白城市', '220000');
INSERT INTO `t_address_city` VALUES ('61', '222400', '延邊朝鮮族自治州', '220000');
INSERT INTO `t_address_city` VALUES ('62', '230100', '哈爾濱市', '230000');
INSERT INTO `t_address_city` VALUES ('63', '230200', '齊齊哈爾市', '230000');
INSERT INTO `t_address_city` VALUES ('64', '230300', '雞西市', '230000');
INSERT INTO `t_address_city` VALUES ('65', '230400', '鶴崗市', '230000');
INSERT INTO `t_address_city` VALUES ('66', '230500', '雙鴨山市', '230000');
INSERT INTO `t_address_city` VALUES ('67', '230600', '大慶市', '230000');
INSERT INTO `t_address_city` VALUES ('68', '230700', '伊春市', '230000');
INSERT INTO `t_address_city` VALUES ('69', '230800', '佳木斯市', '230000');
INSERT INTO `t_address_city` VALUES ('70', '230900', '七臺(tái)河市', '230000');
INSERT INTO `t_address_city` VALUES ('71', '231000', '牡丹江市', '230000');
INSERT INTO `t_address_city` VALUES ('72', '231100', '黑河市', '230000');
INSERT INTO `t_address_city` VALUES ('73', '231200', '綏化市', '230000');
INSERT INTO `t_address_city` VALUES ('74', '232700', '大興安嶺地區(qū)', '230000');
INSERT INTO `t_address_city` VALUES ('75', '310100', '上海市', '310000');
INSERT INTO `t_address_city` VALUES ('76', '3102xx', '上海下屬縣', '3100xx');
INSERT INTO `t_address_city` VALUES ('77', '320100', '南京市', '320000');
INSERT INTO `t_address_city` VALUES ('78', '320200', '無(wú)錫市', '320000');
INSERT INTO `t_address_city` VALUES ('79', '320300', '徐州市', '320000');
INSERT INTO `t_address_city` VALUES ('80', '320400', '常州市', '320000');
INSERT INTO `t_address_city` VALUES ('81', '320500', '蘇州市', '320000');
INSERT INTO `t_address_city` VALUES ('82', '320600', '南通市', '320000');
INSERT INTO `t_address_city` VALUES ('83', '320700', '連云港市', '320000');
INSERT INTO `t_address_city` VALUES ('84', '320800', '淮安市', '320000');
INSERT INTO `t_address_city` VALUES ('85', '320900', '鹽城市', '320000');
INSERT INTO `t_address_city` VALUES ('86', '321000', '揚(yáng)州市', '320000');
INSERT INTO `t_address_city` VALUES ('87', '321100', '鎮(zhèn)江市', '320000');
INSERT INTO `t_address_city` VALUES ('88', '321200', '泰州市', '320000');
INSERT INTO `t_address_city` VALUES ('89', '321300', '宿遷市', '320000');
INSERT INTO `t_address_city` VALUES ('90', '330100', '杭州市', '330000');
INSERT INTO `t_address_city` VALUES ('91', '330200', '寧波市', '330000');
INSERT INTO `t_address_city` VALUES ('92', '330300', '溫州市', '330000');
INSERT INTO `t_address_city` VALUES ('93', '330400', '嘉興市', '330000');
INSERT INTO `t_address_city` VALUES ('94', '330500', '湖州市', '330000');
INSERT INTO `t_address_city` VALUES ('95', '330600', '紹興市', '330000');
INSERT INTO `t_address_city` VALUES ('96', '330700', '金華市', '330000');
INSERT INTO `t_address_city` VALUES ('97', '330800', '衢州市', '330000');
INSERT INTO `t_address_city` VALUES ('98', '330900', '舟山市', '330000');
INSERT INTO `t_address_city` VALUES ('99', '331000', '臺(tái)州市', '330000');
INSERT INTO `t_address_city` VALUES ('100', '331100', '麗水市', '330000');
INSERT INTO `t_address_city` VALUES ('101', '340100', '合肥市', '340000');
INSERT INTO `t_address_city` VALUES ('102', '340200', '蕪湖市', '340000');
INSERT INTO `t_address_city` VALUES ('103', '340300', '蚌埠市', '340000');
INSERT INTO `t_address_city` VALUES ('104', '340400', '淮南市', '340000');
INSERT INTO `t_address_city` VALUES ('105', '340500', '馬鞍山市', '340000');
INSERT INTO `t_address_city` VALUES ('106', '340600', '淮北市', '340000');
INSERT INTO `t_address_city` VALUES ('107', '340700', '銅陵市', '340000');
INSERT INTO `t_address_city` VALUES ('108', '340800', '安慶市', '340000');
INSERT INTO `t_address_city` VALUES ('109', '341000', '黃山市', '340000');
INSERT INTO `t_address_city` VALUES ('110', '341100', '滁州市', '340000');
INSERT INTO `t_address_city` VALUES ('111', '341200', '阜陽(yáng)市', '340000');
INSERT INTO `t_address_city` VALUES ('112', '341300', '宿州市', '340000');
INSERT INTO `t_address_city` VALUES ('113', '341400', '巢湖市', '340000');
INSERT INTO `t_address_city` VALUES ('114', '341500', '六安市', '340000');
INSERT INTO `t_address_city` VALUES ('115', '341600', '亳州市', '340000');
INSERT INTO `t_address_city` VALUES ('116', '341700', '池州市', '340000');
INSERT INTO `t_address_city` VALUES ('117', '341800', '宣城市', '340000');
INSERT INTO `t_address_city` VALUES ('118', '350100', '福州市', '350000');
INSERT INTO `t_address_city` VALUES ('119', '350200', '廈門市', '350000');
INSERT INTO `t_address_city` VALUES ('120', '350300', '莆田市', '350000');
INSERT INTO `t_address_city` VALUES ('121', '350400', '三明市', '350000');
INSERT INTO `t_address_city` VALUES ('122', '350500', '泉州市', '350000');
INSERT INTO `t_address_city` VALUES ('123', '350600', '漳州市', '350000');
INSERT INTO `t_address_city` VALUES ('124', '350700', '南平市', '350000');
INSERT INTO `t_address_city` VALUES ('125', '350800', '龍巖市', '350000');
INSERT INTO `t_address_city` VALUES ('126', '350900', '寧德市', '350000');
INSERT INTO `t_address_city` VALUES ('127', '360100', '南昌市', '360000');
INSERT INTO `t_address_city` VALUES ('128', '360200', '景德鎮(zhèn)市', '360000');
INSERT INTO `t_address_city` VALUES ('129', '360300', '萍鄉(xiāng)市', '360000');
INSERT INTO `t_address_city` VALUES ('130', '360400', '九江市', '360000');
INSERT INTO `t_address_city` VALUES ('131', '360500', '新余市', '360000');
INSERT INTO `t_address_city` VALUES ('132', '360600', '鷹潭市', '360000');
INSERT INTO `t_address_city` VALUES ('133', '360700', '贛州市', '360000');
INSERT INTO `t_address_city` VALUES ('134', '360800', '吉安市', '360000');
INSERT INTO `t_address_city` VALUES ('135', '360900', '宜春市', '360000');
INSERT INTO `t_address_city` VALUES ('136', '361000', '撫州市', '360000');
INSERT INTO `t_address_city` VALUES ('137', '361100', '上饒市', '360000');
INSERT INTO `t_address_city` VALUES ('138', '370100', '濟(jì)南市', '370000');
INSERT INTO `t_address_city` VALUES ('139', '370200', '青島市', '370000');
INSERT INTO `t_address_city` VALUES ('140', '370300', '淄博市', '370000');
INSERT INTO `t_address_city` VALUES ('141', '370400', '棗莊市', '370000');
INSERT INTO `t_address_city` VALUES ('142', '370500', '東營(yíng)市', '370000');
INSERT INTO `t_address_city` VALUES ('143', '370600', '煙臺(tái)市', '370000');
INSERT INTO `t_address_city` VALUES ('144', '370700', '濰坊市', '370000');
INSERT INTO `t_address_city` VALUES ('145', '370800', '濟(jì)寧市', '370000');
INSERT INTO `t_address_city` VALUES ('146', '370900', '泰安市', '370000');
INSERT INTO `t_address_city` VALUES ('147', '371000', '威海市', '370000');
INSERT INTO `t_address_city` VALUES ('148', '371100', '日照市', '370000');
INSERT INTO `t_address_city` VALUES ('149', '371200', '萊蕪市', '370000');
INSERT INTO `t_address_city` VALUES ('150', '371300', '臨沂市', '370000');
INSERT INTO `t_address_city` VALUES ('151', '371400', '德州市', '370000');
INSERT INTO `t_address_city` VALUES ('152', '371500', '聊城市', '370000');
INSERT INTO `t_address_city` VALUES ('153', '371600', '濱州市', '370000');
INSERT INTO `t_address_city` VALUES ('154', '371700', '荷澤市', '370000');
INSERT INTO `t_address_city` VALUES ('155', '410100', '鄭州市', '410000');
INSERT INTO `t_address_city` VALUES ('156', '410200', '開封市', '410000');
INSERT INTO `t_address_city` VALUES ('157', '410300', '洛陽(yáng)市', '410000');
INSERT INTO `t_address_city` VALUES ('158', '410400', '平頂山市', '410000');
INSERT INTO `t_address_city` VALUES ('159', '410500', '安陽(yáng)市', '410000');
INSERT INTO `t_address_city` VALUES ('160', '410600', '鶴壁市', '410000');
INSERT INTO `t_address_city` VALUES ('161', '410700', '新鄉(xiāng)市', '410000');
INSERT INTO `t_address_city` VALUES ('162', '410800', '焦作市', '410000');
INSERT INTO `t_address_city` VALUES ('163', '410900', '濮陽(yáng)市', '410000');
INSERT INTO `t_address_city` VALUES ('164', '411000', '許昌市', '410000');
INSERT INTO `t_address_city` VALUES ('165', '411100', '漯河市', '410000');
INSERT INTO `t_address_city` VALUES ('166', '411200', '三門峽市', '410000');
INSERT INTO `t_address_city` VALUES ('167', '411300', '南陽(yáng)市', '410000');
INSERT INTO `t_address_city` VALUES ('168', '411400', '商丘市', '410000');
INSERT INTO `t_address_city` VALUES ('169', '411500', '信陽(yáng)市', '410000');
INSERT INTO `t_address_city` VALUES ('170', '411600', '周口市', '410000');
INSERT INTO `t_address_city` VALUES ('171', '411700', '駐馬店市', '410000');
INSERT INTO `t_address_city` VALUES ('172', '420100', '武漢市', '420000');
INSERT INTO `t_address_city` VALUES ('173', '420200', '黃石市', '420000');
INSERT INTO `t_address_city` VALUES ('174', '420300', '十堰市', '420000');
INSERT INTO `t_address_city` VALUES ('175', '420500', '宜昌市', '420000');
INSERT INTO `t_address_city` VALUES ('176', '420600', '襄樊市', '420000');
INSERT INTO `t_address_city` VALUES ('177', '420700', '鄂州市', '420000');
INSERT INTO `t_address_city` VALUES ('178', '420800', '荊門市', '420000');
INSERT INTO `t_address_city` VALUES ('179', '420900', '孝感市', '420000');
INSERT INTO `t_address_city` VALUES ('180', '421000', '荊州市', '420000');
INSERT INTO `t_address_city` VALUES ('181', '421100', '黃岡市', '420000');
INSERT INTO `t_address_city` VALUES ('182', '421200', '咸寧市', '420000');
INSERT INTO `t_address_city` VALUES ('183', '421300', '隨州市', '420000');
INSERT INTO `t_address_city` VALUES ('184', '422800', '恩施土家族苗族自治州', '420000');
INSERT INTO `t_address_city` VALUES ('185', '429000', '省直轄行政單位', '420000');
INSERT INTO `t_address_city` VALUES ('186', '430100', '長(zhǎng)沙市', '430000');
INSERT INTO `t_address_city` VALUES ('187', '430200', '株洲市', '430000');
INSERT INTO `t_address_city` VALUES ('188', '430300', '湘潭市', '430000');
INSERT INTO `t_address_city` VALUES ('189', '430400', '衡陽(yáng)市', '430000');
INSERT INTO `t_address_city` VALUES ('190', '430500', '邵陽(yáng)市', '430000');
INSERT INTO `t_address_city` VALUES ('191', '430600', '岳陽(yáng)市', '430000');
INSERT INTO `t_address_city` VALUES ('192', '430700', '常德市', '430000');
INSERT INTO `t_address_city` VALUES ('193', '430800', '張家界市', '430000');
INSERT INTO `t_address_city` VALUES ('194', '430900', '益陽(yáng)市', '430000');
INSERT INTO `t_address_city` VALUES ('195', '431000', '郴州市', '430000');
INSERT INTO `t_address_city` VALUES ('196', '431100', '永州市', '430000');
INSERT INTO `t_address_city` VALUES ('197', '431200', '懷化市', '430000');
INSERT INTO `t_address_city` VALUES ('198', '431300', '婁底市', '430000');
INSERT INTO `t_address_city` VALUES ('199', '433100', '湘西土家族苗族自治州', '430000');
INSERT INTO `t_address_city` VALUES ('200', '440100', '廣州市', '440000');
INSERT INTO `t_address_city` VALUES ('201', '440200', '韶關(guān)市', '440000');
INSERT INTO `t_address_city` VALUES ('202', '440300', '深圳市', '440000');
INSERT INTO `t_address_city` VALUES ('203', '440400', '珠海市', '440000');
INSERT INTO `t_address_city` VALUES ('204', '440500', '汕頭市', '440000');
INSERT INTO `t_address_city` VALUES ('205', '440600', '佛山市', '440000');
INSERT INTO `t_address_city` VALUES ('206', '440700', '江門市', '440000');
INSERT INTO `t_address_city` VALUES ('207', '440800', '湛江市', '440000');
INSERT INTO `t_address_city` VALUES ('208', '440900', '茂名市', '440000');
INSERT INTO `t_address_city` VALUES ('209', '441200', '肇慶市', '440000');
INSERT INTO `t_address_city` VALUES ('210', '441300', '惠州市', '440000');
INSERT INTO `t_address_city` VALUES ('211', '441400', '梅州市', '440000');
INSERT INTO `t_address_city` VALUES ('212', '441500', '汕尾市', '440000');
INSERT INTO `t_address_city` VALUES ('213', '441600', '河源市', '440000');
INSERT INTO `t_address_city` VALUES ('214', '441700', '陽(yáng)江市', '440000');
INSERT INTO `t_address_city` VALUES ('215', '441800', '清遠(yuǎn)市', '440000');
INSERT INTO `t_address_city` VALUES ('216', '441900', '東莞市', '440000');
INSERT INTO `t_address_city` VALUES ('217', '442000', '中山市', '440000');
INSERT INTO `t_address_city` VALUES ('218', '445100', '潮州市', '440000');
INSERT INTO `t_address_city` VALUES ('219', '445200', '揭陽(yáng)市', '440000');
INSERT INTO `t_address_city` VALUES ('220', '445300', '云浮市', '440000');
INSERT INTO `t_address_city` VALUES ('221', '450100', '南寧市', '450000');
INSERT INTO `t_address_city` VALUES ('222', '450200', '柳州市', '450000');
INSERT INTO `t_address_city` VALUES ('223', '450300', '桂林市', '450000');
INSERT INTO `t_address_city` VALUES ('224', '450400', '梧州市', '450000');
INSERT INTO `t_address_city` VALUES ('225', '450500', '北海市', '450000');
INSERT INTO `t_address_city` VALUES ('226', '450600', '防城港市', '450000');
INSERT INTO `t_address_city` VALUES ('227', '450700', '欽州市', '450000');
INSERT INTO `t_address_city` VALUES ('228', '450800', '貴港市', '450000');
INSERT INTO `t_address_city` VALUES ('229', '450900', '玉林市', '450000');
INSERT INTO `t_address_city` VALUES ('230', '451000', '百色市', '450000');
INSERT INTO `t_address_city` VALUES ('231', '451100', '賀州市', '450000');
INSERT INTO `t_address_city` VALUES ('232', '451200', '河池市', '450000');
INSERT INTO `t_address_city` VALUES ('233', '451300', '來(lái)賓市', '450000');
INSERT INTO `t_address_city` VALUES ('234', '451400', '崇左市', '450000');
INSERT INTO `t_address_city` VALUES ('235', '460100', '??谑?, '460000');
INSERT INTO `t_address_city` VALUES ('236', '460200', '三亞市', '460000');
INSERT INTO `t_address_city` VALUES ('237', '469000', '省直轄縣級(jí)行政單位', '460000');
INSERT INTO `t_address_city` VALUES ('238', '500100', '重慶市', '500000');
INSERT INTO `t_address_city` VALUES ('239', '5002xx', '重慶下屬縣', '5000xx');
INSERT INTO `t_address_city` VALUES ('240', '5003xx', '重慶下屬市', '5000xx');
INSERT INTO `t_address_city` VALUES ('241', '510100', '成都市', '510000');
INSERT INTO `t_address_city` VALUES ('242', '510300', '自貢市', '510000');
INSERT INTO `t_address_city` VALUES ('243', '510400', '攀枝花市', '510000');
INSERT INTO `t_address_city` VALUES ('244', '510500', '瀘州市', '510000');
INSERT INTO `t_address_city` VALUES ('245', '510600', '德陽(yáng)市', '510000');
INSERT INTO `t_address_city` VALUES ('246', '510700', '綿陽(yáng)市', '510000');
INSERT INTO `t_address_city` VALUES ('247', '510800', '廣元市', '510000');
INSERT INTO `t_address_city` VALUES ('248', '510900', '遂寧市', '510000');
INSERT INTO `t_address_city` VALUES ('249', '511000', '內(nèi)江市', '510000');
INSERT INTO `t_address_city` VALUES ('250', '511100', '樂(lè)山市', '510000');
INSERT INTO `t_address_city` VALUES ('251', '511300', '南充市', '510000');
INSERT INTO `t_address_city` VALUES ('252', '511400', '眉山市', '510000');
INSERT INTO `t_address_city` VALUES ('253', '511500', '宜賓市', '510000');
INSERT INTO `t_address_city` VALUES ('254', '511600', '廣安市', '510000');
INSERT INTO `t_address_city` VALUES ('255', '511700', '達(dá)州市', '510000');
INSERT INTO `t_address_city` VALUES ('256', '511800', '雅安市', '510000');
INSERT INTO `t_address_city` VALUES ('257', '511900', '巴中市', '510000');
INSERT INTO `t_address_city` VALUES ('258', '512000', '資陽(yáng)市', '510000');
INSERT INTO `t_address_city` VALUES ('259', '513200', '阿壩藏族羌族自治州', '510000');
INSERT INTO `t_address_city` VALUES ('260', '513300', '甘孜藏族自治州', '510000');
INSERT INTO `t_address_city` VALUES ('261', '513400', '涼山彝族自治州', '510000');
INSERT INTO `t_address_city` VALUES ('262', '520100', '貴陽(yáng)市', '520000');
INSERT INTO `t_address_city` VALUES ('263', '520200', '六盤水市', '520000');
INSERT INTO `t_address_city` VALUES ('264', '520300', '遵義市', '520000');
INSERT INTO `t_address_city` VALUES ('265', '520400', '安順市', '520000');
INSERT INTO `t_address_city` VALUES ('266', '522200', '銅仁地區(qū)', '520000');
INSERT INTO `t_address_city` VALUES ('267', '522300', '黔西南布依族苗族自治州', '520000');
INSERT INTO `t_address_city` VALUES ('268', '522400', '畢節(jié)地區(qū)', '520000');
INSERT INTO `t_address_city` VALUES ('269', '522600', '黔東南苗族侗族自治州', '520000');
INSERT INTO `t_address_city` VALUES ('270', '522700', '黔南布依族苗族自治州', '520000');
INSERT INTO `t_address_city` VALUES ('271', '530100', '昆明市', '530000');
INSERT INTO `t_address_city` VALUES ('272', '530300', '曲靖市', '530000');
INSERT INTO `t_address_city` VALUES ('273', '530400', '玉溪市', '530000');
INSERT INTO `t_address_city` VALUES ('274', '530500', '保山市', '530000');
INSERT INTO `t_address_city` VALUES ('275', '530600', '昭通市', '530000');
INSERT INTO `t_address_city` VALUES ('276', '530700', '麗江市', '530000');
INSERT INTO `t_address_city` VALUES ('277', '530800', '思茅市', '530000');
INSERT INTO `t_address_city` VALUES ('278', '530900', '臨滄市', '530000');
INSERT INTO `t_address_city` VALUES ('279', '532300', '楚雄彝族自治州', '530000');
INSERT INTO `t_address_city` VALUES ('280', '532500', '紅河哈尼族彝族自治州', '530000');
INSERT INTO `t_address_city` VALUES ('281', '532600', '文山壯族苗族自治州', '530000');
INSERT INTO `t_address_city` VALUES ('282', '532800', '西雙版納傣族自治州', '530000');
INSERT INTO `t_address_city` VALUES ('283', '532900', '大理白族自治州', '530000');
INSERT INTO `t_address_city` VALUES ('284', '533100', '德宏傣族景頗族自治州', '530000');
INSERT INTO `t_address_city` VALUES ('285', '533300', '怒江傈僳族自治州', '530000');
INSERT INTO `t_address_city` VALUES ('286', '533400', '迪慶藏族自治州', '530000');
INSERT INTO `t_address_city` VALUES ('287', '540100', '拉薩市', '540000');
INSERT INTO `t_address_city` VALUES ('288', '542100', '昌都地區(qū)', '540000');
INSERT INTO `t_address_city` VALUES ('289', '542200', '山南地區(qū)', '540000');
INSERT INTO `t_address_city` VALUES ('290', '542300', '日喀則地區(qū)', '540000');
INSERT INTO `t_address_city` VALUES ('291', '542400', '那曲地區(qū)', '540000');
INSERT INTO `t_address_city` VALUES ('292', '542500', '阿里地區(qū)', '540000');
INSERT INTO `t_address_city` VALUES ('293', '542600', '林芝地區(qū)', '540000');
INSERT INTO `t_address_city` VALUES ('294', '610100', '西安市', '610000');
INSERT INTO `t_address_city` VALUES ('295', '610200', '銅川市', '610000');
INSERT INTO `t_address_city` VALUES ('296', '610300', '寶雞市', '610000');
INSERT INTO `t_address_city` VALUES ('297', '610400', '咸陽(yáng)市', '610000');
INSERT INTO `t_address_city` VALUES ('298', '610500', '渭南市', '610000');
INSERT INTO `t_address_city` VALUES ('299', '610600', '延安市', '610000');
INSERT INTO `t_address_city` VALUES ('300', '610700', '漢中市', '610000');
INSERT INTO `t_address_city` VALUES ('301', '610800', '榆林市', '610000');
INSERT INTO `t_address_city` VALUES ('302', '610900', '安康市', '610000');
INSERT INTO `t_address_city` VALUES ('303', '611000', '商洛市', '610000');
INSERT INTO `t_address_city` VALUES ('304', '620100', '蘭州市', '620000');
INSERT INTO `t_address_city` VALUES ('305', '620200', '嘉峪關(guān)市', '620000');
INSERT INTO `t_address_city` VALUES ('306', '620300', '金昌市', '620000');
INSERT INTO `t_address_city` VALUES ('307', '620400', '白銀市', '620000');
INSERT INTO `t_address_city` VALUES ('308', '620500', '天水市', '620000');
INSERT INTO `t_address_city` VALUES ('309', '620600', '武威市', '620000');
INSERT INTO `t_address_city` VALUES ('310', '620700', '張掖市', '620000');
INSERT INTO `t_address_city` VALUES ('311', '620800', '平?jīng)鍪?, '620000');
INSERT INTO `t_address_city` VALUES ('312', '620900', '酒泉市', '620000');
INSERT INTO `t_address_city` VALUES ('313', '621000', '慶陽(yáng)市', '620000');
INSERT INTO `t_address_city` VALUES ('314', '621100', '定西市', '620000');
INSERT INTO `t_address_city` VALUES ('315', '621200', '隴南市', '620000');
INSERT INTO `t_address_city` VALUES ('316', '622900', '臨夏回族自治州', '620000');
INSERT INTO `t_address_city` VALUES ('317', '623000', '甘南藏族自治州', '620000');
INSERT INTO `t_address_city` VALUES ('318', '630100', '西寧市', '630000');
INSERT INTO `t_address_city` VALUES ('319', '632100', '海東地區(qū)', '630000');
INSERT INTO `t_address_city` VALUES ('320', '632200', '海北藏族自治州', '630000');
INSERT INTO `t_address_city` VALUES ('321', '632300', '黃南藏族自治州', '630000');
INSERT INTO `t_address_city` VALUES ('322', '632500', '海南藏族自治州', '630000');
INSERT INTO `t_address_city` VALUES ('323', '632600', '果洛藏族自治州', '630000');
INSERT INTO `t_address_city` VALUES ('324', '632700', '玉樹藏族自治州', '630000');
INSERT INTO `t_address_city` VALUES ('325', '632800', '海西蒙古族藏族自治州', '630000');
INSERT INTO `t_address_city` VALUES ('326', '640100', '銀川市', '640000');
INSERT INTO `t_address_city` VALUES ('327', '640200', '石嘴山市', '640000');
INSERT INTO `t_address_city` VALUES ('328', '640300', '吳忠市', '640000');
INSERT INTO `t_address_city` VALUES ('329', '640400', '固原市', '640000');
INSERT INTO `t_address_city` VALUES ('330', '640500', '中衛(wèi)市', '640000');
INSERT INTO `t_address_city` VALUES ('331', '650100', '烏魯木齊市', '650000');
INSERT INTO `t_address_city` VALUES ('332', '650200', '克拉瑪依市', '650000');
INSERT INTO `t_address_city` VALUES ('333', '652100', '吐魯番地區(qū)', '650000');
INSERT INTO `t_address_city` VALUES ('334', '652200', '哈密地區(qū)', '650000');
INSERT INTO `t_address_city` VALUES ('335', '652300', '昌吉回族自治州', '650000');
INSERT INTO `t_address_city` VALUES ('336', '652700', '博爾塔拉蒙古自治州', '650000');
INSERT INTO `t_address_city` VALUES ('337', '652800', '巴音郭楞蒙古自治州', '650000');
INSERT INTO `t_address_city` VALUES ('338', '652900', '阿克蘇地區(qū)', '650000');
INSERT INTO `t_address_city` VALUES ('339', '653000', '克孜勒蘇柯爾克孜自治州', '650000');
INSERT INTO `t_address_city` VALUES ('340', '653100', '喀什地區(qū)', '650000');
INSERT INTO `t_address_city` VALUES ('341', '653200', '和田地區(qū)', '650000');
INSERT INTO `t_address_city` VALUES ('342', '654000', '伊犁哈薩克自治州', '650000');
INSERT INTO `t_address_city` VALUES ('343', '654200', '塔城地區(qū)', '650000');
INSERT INTO `t_address_city` VALUES ('344', '654300', '阿勒泰地區(qū)', '650000');
INSERT INTO `t_address_city` VALUES ('345', '659000', '省直轄行政單位', '650000');
最后是區(qū)縣信息表數(shù)據(jù) [sql] view plaincopyprint? INSERT INTO `t_address_town` VALUES ('1', '110101', '東城區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('2', '110102', '西城區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('3', '110103', '崇文區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('4', '110104', '宣武區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('5', '110105', '朝陽(yáng)區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('6', '110106', '豐臺(tái)區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('7', '110107', '石景山區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('8', '110108', '海淀區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('9', '110109', '門頭溝區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('10', '110111', '房山區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('11', '110112', '通州區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('12', '110113', '順義區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('13', '110114', '昌平區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('14', '110115', '大興區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('15', '110116', '懷柔區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('16', '110117', '平谷區(qū)', '110100');
INSERT INTO `t_address_town` VALUES ('17', '110228', '密云縣', '110100');
INSERT INTO `t_address_town` VALUES ('18', '110229', '延慶縣', '110100');
INSERT INTO `t_address_town` VALUES ('19', '120101', '和平區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('20', '120102', '河?xùn)|區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('21', '120103', '河西區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('22', '120104', '南開區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('23', '120105', '河北區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('24', '120106', '紅橋區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('25', '120107', '塘沽區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('26', '120108', '漢沽區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('27', '120109', '大港區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('28', '120110', '東麗區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('29', '120111', '西青區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('30', '120112', '津南區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('31', '120113', '北辰區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('32', '120114', '武清區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('33', '120115', '寶坻區(qū)', '120100');
INSERT INTO `t_address_town` VALUES ('34', '120221', '寧河縣', '120100');
INSERT INTO `t_address_town` VALUES ('35', '120223', '靜??h', '120100');
INSERT INTO `t_address_town` VALUES ('36', '120225', '薊 縣', '120100');
INSERT INTO `t_address_town` VALUES ('37', '130101', '市轄區(qū)', '130100');
INSERT INTO `t_address_town` VALUES ('38', '130102', '長(zhǎng)安區(qū)', '130100');
INSERT INTO `t_address_town` VALUES ('39', '130103', '橋東區(qū)', '130100');
INSERT INTO `t_address_town` VALUES ('40', '130104', '橋西區(qū)', '130100');
INSERT INTO `t_address_town` VALUES ('41', '130105', '新華區(qū)', '130100');
INSERT INTO `t_address_town` VALUES ('42', '130107', '井陘礦區(qū)', '130100');
INSERT INTO `t_address_town` VALUES ('43', '130108', '裕華區(qū)', '130100');
INSERT INTO `t_address_town` VALUES ('44', '130121', '井陘縣', '130100');
INSERT INTO `t_address_town` VALUES ('45', '130123', '正定縣', '130100');
INSERT INTO `t_address_town` VALUES ('46', '130124', '欒城縣', '130100');
INSERT INTO `t_address_town` VALUES ('47', '130125', '行唐縣', '130100');
INSERT INTO `t_address_town` VALUES ('48', '130126', '靈壽縣', '130100');
INSERT INTO `t_address_town` VALUES ('49', '130127', '高邑縣', '130100');
INSERT INTO `t_address_town` VALUES ('50', '130128', '深澤縣', '130100');
INSERT INTO `t_address_town` VALUES ('51', '130129', '贊皇縣', '130100');
INSERT INTO `t_address_town` VALUES ('52', '130130', '無(wú)極縣', '130100');
INSERT INTO `t_address_town` VALUES ('53', '130131', '平山縣', '130100');
INSERT INTO `t_address_town` VALUES ('54', '130132', '元氏縣', '130100');
INSERT INTO `t_address_town` VALUES ('55', '130133', '趙 縣', '130100');
INSERT INTO `t_address_town` VALUES ('56', '130181', '辛集市', '130100');
INSERT INTO `t_address_town` VALUES ('57', '130182', '藁城市', '130100');
INSERT INTO `t_address_town` VALUES ('58', '130183', '晉州市', '130100');
INSERT INTO `t_address_town` VALUES ('59', '130184', '新樂(lè)市', '130100');
INSERT INTO `t_address_town` VALUES ('60', '130185', '鹿泉市', '130100');
INSERT INTO `t_address_town` VALUES ('61', '130201', '市轄區(qū)', '130200');
INSERT INTO `t_address_town` VALUES ('62', '130202', '路南區(qū)', '130200');
INSERT INTO `t_address_town` VALUES ('63', '130203', '路北區(qū)', '130200');
INSERT INTO `t_address_town` VALUES ('64', '130204', '古冶區(qū)', '130200');
INSERT INTO `t_address_town` VALUES ('65', '130205', '開平區(qū)', '130200');
INSERT INTO `t_address_town` VALUES ('66', '130207', '豐南區(qū)', '130200');
INSERT INTO `t_address_town` VALUES ('67', '130208', '豐潤(rùn)區(qū)', '130200');
INSERT INTO `t_address_town` VALUES ('68', '130223', '灤 縣', '130200');
INSERT INTO `t_address_town` VALUES ('69', '130224', '灤南縣', '130200');
INSERT INTO `t_address_town` VALUES ('70', '130225', '樂(lè)亭縣', '130200');
INSERT INTO `t_address_town` VALUES ('71', '130227', '遷西縣', '130200');
INSERT INTO `t_address_town` VALUES ('72', '130229', '玉田縣', '130200');
INSERT INTO `t_address_town` VALUES ('73', '130230', '唐??h', '130200');
INSERT INTO `t_address_town` VALUES ('74', '130281', '遵化市', '130200');
INSERT INTO `t_address_town` VALUES ('75', '130283', '遷安市', '130200');
INSERT INTO `t_address_town` VALUES ('76', '130301', '市轄區(qū)', '130300');
INSERT INTO `t_address_town` VALUES ('77', '130302', '海港區(qū)', '130300');
INSERT INTO `t_address_town` VALUES ('78', '130303', '山海關(guān)區(qū)', '130300');
INSERT INTO `t_address_town` VALUES ('79', '130304', '北戴河區(qū)', '130300');
INSERT INTO `t_address_town` VALUES ('80', '130321', '青龍滿族自治縣', '130300');
INSERT INTO `t_address_town` VALUES ('81', '130322', '昌黎縣', '130300');
INSERT INTO `t_address_town` VALUES ('82', '130323', '撫寧縣', '130300');
INSERT INTO `t_address_town` VALUES ('83', '130324', '盧龍縣', '130300');
INSERT INTO `t_address_town` VALUES ('84', '130401', '市轄區(qū)', '130400');
INSERT INTO `t_address_town` VALUES ('85', '130402', '邯山區(qū)', '130400');
INSERT INTO `t_address_town` VALUES ('86', '130403', '叢臺(tái)區(qū)', '130400');
INSERT INTO `t_address_town` VALUES ('87', '130404', '復(fù)興區(qū)', '130400');
INSERT INTO `t_address_town` VALUES ('88', '130406', '峰峰礦區(qū)', '130400');
INSERT INTO `t_address_town` VALUES ('89', '130421', '邯鄲縣', '130400');
INSERT INTO `t_address_town` VALUES ('90', '130423', '臨漳縣', '130400');
INSERT INTO `t_address_town` VALUES ('91', '130424', '成安縣', '130400');
INSERT INTO `t_address_town` VALUES ('92', '130425', '大名縣', '130400');
INSERT INTO `t_address_town` VALUES ('93', '130426', '涉 縣', '130400');
INSERT INTO `t_address_town` VALUES ('94', '130427', '磁 縣', '130400');
INSERT INTO `t_address_town` VALUES ('95', '130428', '肥鄉(xiāng)縣', '130400');
INSERT INTO `t_address_town` VALUES ('96', '130429', '永年縣', '130400');
INSERT INTO `t_address_town` VALUES ('97', '130430', '邱 縣', '130400');
INSERT INTO `t_address_town` VALUES ('98', '130431', '雞澤縣', '130400');
INSERT INTO `t_address_town` VALUES ('99', '130432', '廣平縣', '130400');
INSERT INTO `t_address_town` VALUES ('100', '130433', '館陶縣', '130400');
INSERT INTO `t_address_town` VALUES ('101', '130434', '魏 縣', '130400');
INSERT INTO `t_address_town` VALUES ('102', '130435', '曲周縣', '130400');
INSERT INTO `t_address_town` VALUES ('103', '130481', '武安市', '130400');
INSERT INTO `t_address_town` VALUES ('104', '130501', '市轄區(qū)', '130500');
INSERT INTO `t_address_town` VALUES ('105', '130502', '橋東區(qū)', '130500');
INSERT INTO `t_address_town` VALUES ('106', '130503', '橋西區(qū)', '130500');
INSERT INTO `t_address_town` VALUES ('107', '130521', '邢臺(tái)縣', '130500');
INSERT INTO `t_address_town` VALUES ('108', '130522', '臨城縣', '130500');
INSERT INTO `t_address_town` VALUES ('109', '130523', '內(nèi)丘縣', '130500');
INSERT INTO `t_address_town` VALUES ('110', '130524', '柏鄉(xiāng)縣', '130500');
INSERT INTO `t_address_town` VALUES ('111', '130525', '隆堯縣', '130500');
INSERT INTO `t_address_town` VALUES ('112', '130526', '任 縣', '130500');
INSERT INTO `t_address_town` VALUES ('113', '130527', '南和縣', '130500');
INSERT INTO `t_address_town` VALUES ('114', '130528', '寧晉縣', '130500');
INSERT INTO `t_address_town` VALUES ('115', '130529', '巨鹿縣', '130500');
INSERT INTO `t_address_town` VALUES ('116', '130530', '新河縣', '130500');
INSERT INTO `t_address_town` VALUES ('117', '130531', '廣宗縣', '130500');
INSERT INTO `t_address_town` VALUES ('118', '130532', '平鄉(xiāng)縣', '130500');
INSERT INTO `t_address_town` VALUES ('119', '130533', '威 縣', '130500');
INSERT INTO `t_address_town` VALUES ('120', '130534', '清河縣', '130500');
INSERT INTO `t_address_town` VALUES ('121', '130535', '臨西縣', '130500');
INSERT INTO `t_address_town` VALUES ('122', '130581', '南宮市', '130500');
INSERT INTO `t_address_town` VALUES ('123', '130582', '沙河市', '130500');
INSERT INTO `t_address_town` VALUES ('124', '130601', '市轄區(qū)', '130600');
INSERT INTO `t_address_town` VALUES ('125', '130602', '新市區(qū)', '130600');
INSERT INTO `t_address_town` VALUES ('126', '130603', '北市區(qū)', '130600');
INSERT INTO `t_address_town` VALUES ('127', '130604', '南市區(qū)', '130600');
INSERT INTO `t_address_town` VALUES ('128', '130621', '滿城縣', '130600');
INSERT INTO `t_address_town` VALUES ('129', '130622', '清苑縣', '130600');
INSERT INTO `t_address_town` VALUES ('130', '130623', '淶水縣', '130600');
INSERT INTO `t_address_town` VALUES ('131', '130624', '阜平縣', '130600');
INSERT INTO `t_address_town` VALUES ('132', '130625', '徐水縣', '130600');
INSERT INTO `t_address_town` VALUES ('133', '130626', '定興縣', '130600');
INSERT INTO `t_address_town` VALUES ('134', '130627', '唐 縣', '130600');
INSERT INTO `t_address_town` VALUES ('135', '130628', '高陽(yáng)縣', '130600');
INSERT INTO `t_address_town` VALUES ('136', '130629', '容城縣', '130600');
INSERT INTO `t_address_town` VALUES ('137', '130630', '淶源縣', '130600');
INSERT INTO `t_address_town` VALUES ('138', '130631', '望都縣', '130600');
INSERT INTO `t_address_town` VALUES ('139', '130632', '安新縣', '130600');
INSERT INTO `t_address_town` VALUES ('140', '130633', '易 縣', '130600');
INSERT INTO `t_address_town` VALUES ('141', '130634', '曲陽(yáng)縣', '130600');
INSERT INTO `t_address_town` VALUES ('142', '130635', '蠡 縣', '130600');
INSERT INTO `t_address_town` VALUES ('143', '130636', '順平縣', '130600');
INSERT INTO `t_address_town` VALUES ('144', '130637', '博野縣', '130600');
INSERT INTO `t_address_town` VALUES ('145', '130638', '雄 縣', '130600');
INSERT INTO `t_address_town` VALUES ('146', '130681', '涿州市', '130600');
INSERT INTO `t_address_town` VALUES ('147', '130682', '定州市', '130600');
INSERT INTO `t_address_town` VALUES ('148', '130683', '安國(guó)市', '130600');
INSERT INTO `t_address_town` VALUES ('149', '130684', '高碑店市', '130600');
INSERT INTO `t_address_town` VALUES ('150', '130701', '市轄區(qū)', '130700');
INSERT INTO `t_address_town` VALUES ('151', '130702', '橋東區(qū)', '130700');
INSERT INTO `t_address_town` VALUES ('152', '130703', '橋西區(qū)', '130700');
INSERT INTO `t_address_town` VALUES ('153', '130705', '宣化區(qū)', '130700');
INSERT INTO `t_address_town` VALUES ('154', '130706', '下花園區(qū)', '130700');
INSERT INTO `t_address_town` VALUES ('155', '130721', '宣化縣', '130700');
INSERT INTO `t_address_town` VALUES ('156', '130722', '張北縣', '130700');
INSERT INTO `t_address_town` VALUES ('157', '130723', '康??h', '130700');
INSERT INTO `t_address_town` VALUES ('158', '130724', '沽源縣', '130700');
INSERT INTO `t_address_town` VALUES ('159', '130725', '尚義縣', '130700');
INSERT INTO `t_address_town` VALUES ('160', '130726', '蔚 縣', '130700');
INSERT INTO `t_address_town` VALUES ('161', '130727', '陽(yáng)原縣', '130700');
INSERT INTO `t_address_town` VALUES ('162', '130728', '懷安縣', '130700');
INSERT INTO `t_address_town` VALUES ('163', '130729', '萬(wàn)全縣', '130700');
INSERT INTO `t_address_town` VALUES ('164', '130730', '懷來(lái)縣', '130700');
INSERT INTO `t_address_town` VALUES ('165', '130731', '涿鹿縣', '130700');
INSERT INTO `t_address_town` VALUES ('166', '130732', '赤城縣', '130700');
INSERT INTO `t_address_town` VALUES ('167', '130733', '崇禮縣', '130700');
INSERT INTO `t_address_town` VALUES ('168', '130801', '市轄區(qū)', '130800');
INSERT INTO `t_address_town` VALUES ('169', '130802', '雙橋區(qū)', '130800');
INSERT INTO `t_address_town` VALUES ('170', '130803', '雙灤區(qū)', '130800');
INSERT INTO `t_address_town` VALUES ('171', '130804', '鷹手營(yíng)子礦區(qū)', '130800');
INSERT INTO `t_address_town` VALUES ('172', '130821', '承德縣', '130800');
INSERT INTO `t_address_town` VALUES ('173', '130822', '興隆縣', '130800');
INSERT INTO `t_address_town` VALUES ('174', '130823', '平泉縣', '130800');
INSERT INTO `t_address_town` VALUES ('175', '130824', '灤平縣', '130800');
INSERT INTO `t_address_town` VALUES ('176', '130825', '隆化縣', '130800');
INSERT INTO `t_address_town` VALUES ('177', '130826', '豐寧滿族自治縣', '130800');
INSERT INTO `t_address_town` VALUES ('178', '130827', '寬城滿族自治縣', '130800');
INSERT INTO `t_address_town` VALUES ('179', '130828', '圍場(chǎng)滿族蒙古族自治縣', '130800');
INSERT INTO `t_address_town` VALUES ('180', '130901', '市轄區(qū)', '130900');
INSERT INTO `t_address_town` VALUES ('181', '130902', '新華區(qū)', '130900');
INSERT INTO `t_address_town` VALUES ('182', '130903', '運(yùn)河區(qū)', '130900');
INSERT INTO `t_address_town` VALUES ('183', '130921', '滄 縣', '130900');
INSERT INTO `t_address_town` VALUES ('184', '130922', '青 縣', '130900');
INSERT INTO `t_address_town` VALUES ('185', '130923', '東光縣', '130900');
INSERT INTO `t_address_town` VALUES ('186', '130924', '海興縣', '130900');
INSERT INTO `t_address_town` VALUES ('187', '130925', '鹽山縣', '130900');
INSERT INTO `t_address_town` VALUES ('188', '130926', '肅寧縣', '130900');
INSERT INTO `t_address_town` VALUES ('189', '130927', '南皮縣', '130900');
INSERT INTO `t_address_town` VALUES ('190', '130928', '吳橋縣', '130900');
INSERT INTO `t_address_town` VALUES ('191', '130929', '獻(xiàn) 縣', '130900');
INSERT INTO `t_address_town` VALUES ('192', '130930', '孟村回族自治縣', '130900');
INSERT INTO `t_address_town` VALUES ('193', '130981', '泊頭市', '130900');
INSERT INTO `t_address_town` VALUES ('194', '130982', '任丘市', '130900');
INSERT INTO `t_address_town` VALUES ('195', '130983', '黃驊市', '130900');
INSERT INTO `t_address_town` VALUES ('196', '130984', '河間市', '130900');
INSERT INTO `t_address_town` VALUES ('197', '131001', '市轄區(qū)', '131000');
INSERT INTO `t_address_town` VALUES ('198', '131002', '安次區(qū)', '131000');
INSERT INTO `t_address_town` VALUES ('199', '131003', '廣陽(yáng)區(qū)', '131000');
INSERT INTO `t_address_town` VALUES ('200', '131022', '固安縣', '131000');
INSERT INTO `t_address_town` VALUES ('201', '131023', '永清縣', '131000');
INSERT INTO `t_address_town` VALUES ('202', '131024', '香河縣', '131000');
INSERT INTO `t_address_town` VALUES ('203', '131025', '大城縣', '131000');
INSERT INTO `t_address_town` VALUES ('204', '131026', '文安縣', '131000');
INSERT INTO `t_address_town` VALUES ('205', '131028', '大廠回族自治縣', '131000');
INSERT INTO `t_address_town` VALUES ('206', '131081', '霸州市', '131000');
INSERT INTO `t_address_town` VALUES ('207', '131082', '三河市', '131000');
INSERT INTO `t_address_town` VALUES ('208', '131101', '市轄區(qū)', '131100');
INSERT INTO `t_address_town` VALUES ('209', '131102', '桃城區(qū)', '131100');
INSERT INTO `t_address_town` VALUES ('210', '131121', '棗強(qiáng)縣', '131100');
INSERT INTO `t_address_town` VALUES ('211', '131122', '武邑縣', '131100');
INSERT INTO `t_address_town` VALUES ('212', '131123', '武強(qiáng)縣', '131100');
INSERT INTO `t_address_town` VALUES ('213', '131124', '饒陽(yáng)縣', '131100');
INSERT INTO `t_address_town` VALUES ('214', '131125', '安平縣', '131100');
INSERT INTO `t_address_town` VALUES ('215', '131126', '故城縣', '131100');
INSERT INTO `t_address_town` VALUES ('216', '131127', '景 縣', '131100');
INSERT INTO `t_address_town` VALUES ('217', '131128', '阜城縣', '131100');
INSERT INTO `t_address_town` VALUES ('218', '131181', '冀州市', '131100');
INSERT INTO `t_address_town` VALUES ('219', '131182', '深州市', '131100');
INSERT INTO `t_address_town` VALUES ('220', '140101', '市轄區(qū)', '140100');
INSERT INTO `t_address_town` VALUES ('221', '140105', '小店區(qū)', '140100');
INSERT INTO `t_address_town` VALUES ('222', '140106', '迎澤區(qū)', '140100');
INSERT INTO `t_address_town` VALUES ('223', '140107', '杏花嶺區(qū)', '140100');
INSERT INTO `t_address_town` VALUES ('224', '140108', '尖草坪區(qū)', '140100');
INSERT INTO `t_address_town` VALUES ('225', '140109', '萬(wàn)柏林區(qū)', '140100');
INSERT INTO `t_address_town` VALUES ('226', '140110', '晉源區(qū)', '140100');
INSERT INTO `t_address_town` VALUES ('227', '140121', '清徐縣', '140100');
INSERT INTO `t_address_town` VALUES ('228', '140122', '陽(yáng)曲縣', '140100');
INSERT INTO `t_address_town` VALUES ('229', '140123', '婁煩縣', '140100');
INSERT INTO `t_address_town` VALUES ('230', '140181', '古交市', '140100');
INSERT INTO `t_address_town` VALUES ('231', '140201', '市轄區(qū)', '140200');
INSERT INTO `t_address_town` VALUES ('232', '140202', '城 區(qū)', '140200');
INSERT INTO `t_address_town` VALUES ('233', '140203', '礦 區(qū)', '140200');
INSERT INTO `t_address_town` VALUES ('234', '140211', '南郊區(qū)', '140200');
INSERT INTO `t_address_town` VALUES ('235', '140212', '新榮區(qū)', '140200');
INSERT INTO `t_address_town` VALUES ('236', '140221', '陽(yáng)高縣', '140200');
INSERT INTO `t_address_town` VALUES ('237', '140222', '天鎮(zhèn)縣', '140200');
INSERT INTO `t_address_town` VALUES ('238', '140223', '廣靈縣', '140200');
INSERT INTO `t_address_town` VALUES ('239', '140224', '靈丘縣', '140200');
INSERT INTO `t_address_town` VALUES ('240', '140225', '渾源縣', '140200');
INSERT INTO `t_address_town` VALUES ('241', '140226', '左云縣', '140200');
INSERT INTO `t_address_town` VALUES ('242', '140227', '大同縣', '140200');
INSERT INTO `t_address_town` VALUES ('243', '140301', '市轄區(qū)', '140300');
INSERT INTO `t_address_town` VALUES ('244', '140302', '城 區(qū)', '140300');
INSERT INTO `t_address_town` VALUES ('245', '140303', '礦 區(qū)', '140300');
INSERT INTO `t_address_town` VALUES ('246', '140311', '郊 區(qū)', '140300');
INSERT INTO `t_address_town` VALUES ('247', '140321', '平定縣', '140300');
INSERT INTO `t_address_town` VALUES ('248', '140322', '盂 縣', '140300');
INSERT INTO `t_address_town` VALUES ('249', '140401', '市轄區(qū)', '140400');
INSERT INTO `t_address_town` VALUES ('250', '140402', '城 區(qū)', '140400');
INSERT INTO `t_address_town` VALUES ('251', '140411', '郊 區(qū)', '140400');
INSERT INTO `t_address_town` VALUES ('252', '140421', '長(zhǎng)治縣', '140400');
INSERT INTO `t_address_town` VALUES ('253', '140423', '襄垣縣', '140400');
INSERT INTO `t_address_town` VALUES ('254', '140424', '屯留縣', '140400');
INSERT INTO `t_address_town` VALUES ('255', '140425', '平順縣', '140400');
INSERT INTO `t_address_town` VALUES ('256', '140426', '黎城縣', '140400');
INSERT INTO `t_address_town` VALUES ('257', '140427', '壺關(guān)縣', '140400');
INSERT INTO `t_address_town` VALUES ('258', '140428', '長(zhǎng)子縣', '140400');
INSERT INTO `t_address_town` VALUES ('259', '140429', '武鄉(xiāng)縣', '140400');
INSERT INTO `t_address_town` VALUES ('260', '140430', '沁 縣', '140400');
INSERT INTO `t_address_town` VALUES ('261', '140431', '沁源縣', '140400');
INSERT INTO `t_address_town` VALUES ('262', '140481', '潞城市', '140400');
INSERT INTO `t_address_town` VALUES ('263', '140501', '市轄區(qū)', '140500');
INSERT INTO `t_address_town` VALUES ('264', '140502', '城 區(qū)', '140500');
INSERT INTO `t_address_town` VALUES ('265', '140521', '沁水縣', '140500');
INSERT INTO `t_address_town` VALUES ('266', '140522', '陽(yáng)城縣', '140500');
INSERT INTO `t_address_town` VALUES ('267', '140524', '陵川縣', '140500');
INSERT INTO `t_address_town` VALUES ('268', '140525', '澤州縣', '140500');
INSERT INTO `t_address_town` VALUES ('269', '140581', '高平市', '140500');
INSERT INTO `t_address_town` VALUES ('270', '140601', '市轄區(qū)', '140600');
INSERT INTO `t_address_town` VALUES ('271', '140602', '朔城區(qū)', '140600');
INSERT INTO `t_address_town` VALUES ('272', '140603', '平魯區(qū)', '140600');
INSERT INTO `t_address_town` VALUES ('273', '140621', '山陰縣', '140600');
INSERT INTO `t_address_town` VALUES ('274', '140622', '應(yīng) 縣', '140600');
INSERT INTO `t_address_town` VALUES ('275', '140623', '右玉縣', '140600');
INSERT INTO `t_address_town` VALUES ('276', '140624', '懷仁縣', '140600');
INSERT INTO `t_address_town` VALUES ('277', '140701', '市轄區(qū)', '140700');
INSERT INTO `t_address_town` VALUES ('278', '140702', '榆次區(qū)', '140700');
INSERT INTO `t_address_town` VALUES ('279', '140721', '榆社縣', '140700');
INSERT INTO `t_address_town` VALUES ('280', '140722', '左權(quán)縣', '140700');
INSERT INTO `t_address_town` VALUES ('281', '140723', '和順縣', '140700');
INSERT INTO `t_address_town` VALUES ('282', '140724', '昔陽(yáng)縣', '140700');
INSERT INTO `t_address_town` VALUES ('283', '140725', '壽陽(yáng)縣', '140700');
INSERT INTO `t_address_town` VALUES ('284', '140726', '太谷縣', '140700');
INSERT INTO `t_address_town` VALUES ('285', '140727', '祁 縣', '140700');
INSERT INTO `t_address_town` VALUES ('286', '140728', '平遙縣', '140700');
INSERT INTO `t_address_town` VALUES ('287', '140729', '靈石縣', '140700');
INSERT INTO `t_address_town` VALUES ('288', '140781', '介休市', '140700');
INSERT INTO `t_address_town` VALUES ('289', '140801', '市轄區(qū)', '140800');
INSERT INTO `t_address_town` VALUES ('290', '140802', '鹽湖區(qū)', '140800');
INSERT INTO `t_address_town` VALUES ('291', '140821', '臨猗縣', '140800');
INSERT INTO `t_address_town` VALUES ('292', '140822', '萬(wàn)榮縣', '140800');
INSERT INTO `t_address_town` VALUES ('293', '140823', '聞喜縣', '140800');
INSERT INTO `t_address_town` VALUES ('294', '140824', '稷山縣', '140800');
INSERT INTO `t_address_town` VALUES ('295', '140825', '新絳縣', '140800');
INSERT INTO `t_address_town` VALUES ('296', '140826', '絳 縣', '140800');
INSERT INTO `t_address_town` VALUES ('297', '140827', '垣曲縣', '140800');
INSERT INTO `t_address_town` VALUES ('298', '140828', '夏 縣', '140800');
INSERT INTO `t_address_town` VALUES ('299', '140829', '平陸縣', '140800');
INSERT INTO `t_address_town` VALUES ('300', '140830', '芮城縣', '140800');
INSERT INTO `t_address_town` VALUES ('301', '140881', '永濟(jì)市', '140800');
INSERT INTO `t_address_town` VALUES ('302', '140882', '河津市', '140800');
INSERT INTO `t_address_town` VALUES ('303', '140901', '市轄區(qū)', '140900');
INSERT INTO `t_address_town` VALUES ('304', '140902', '忻府區(qū)', '140900');
INSERT INTO `t_address_town` VALUES ('305', '140921', '定襄縣', '140900');
INSERT INTO `t_address_town` VALUES ('306', '140922', '五臺(tái)縣', '140900');
INSERT INTO `t_address_town` VALUES ('307', '140923', '代 縣', '140900');
INSERT INTO `t_address_town` VALUES ('308', '140924', '繁峙縣', '140900');
INSERT INTO `t_address_town` VALUES ('309', '140925', '寧武縣', '140900');
INSERT INTO `t_address_town` VALUES ('310', '140926', '靜樂(lè)縣', '140900');
INSERT INTO `t_address_town` VALUES ('311', '140927', '神池縣', '140900');
INSERT INTO `t_address_town` VALUES ('312', '140928', '五寨縣', '140900');
INSERT INTO `t_address_town` VALUES ('313', '140929', '岢嵐縣', '140900');
INSERT INTO `t_address_town` VALUES ('314', '140930', '河曲縣', '140900');
INSERT INTO `t_address_town` VALUES ('315', '140931', '保德縣', '140900');
INSERT INTO `t_address_town` VALUES ('316', '140932', '偏關(guān)縣', '140900');
INSERT INTO `t_address_town` VALUES ('317', '140981', '原平市', '140900');
INSERT INTO `t_address_town` VALUES ('318', '141001', '市轄區(qū)', '141000');
INSERT INTO `t_address_town` VALUES ('319', '141002', '堯都區(qū)', '141000');
INSERT INTO `t_address_town` VALUES ('320', '141021', '曲沃縣', '141000');
INSERT INTO `t_address_town` VALUES ('321', '141022', '翼城縣', '141000');
INSERT INTO `t_address_town` VALUES ('322', '141023', '襄汾縣', '141000');
INSERT INTO `t_address_town` VALUES ('323', '141024', '洪洞縣', '141000');
INSERT INTO `t_address_town` VALUES ('324', '141025', '古 縣', '141000');
INSERT INTO `t_address_town` VALUES ('325', '141026', '安澤縣', '141000');
INSERT INTO `t_address_town` VALUES ('326', '141027', '浮山縣', '141000');
INSERT INTO `t_address_town` VALUES ('327', '141028', '吉 縣', '141000');
INSERT INTO `t_address_town` VALUES ('328', '141029', '鄉(xiāng)寧縣', '141000');
INSERT INTO `t_address_town` VALUES ('329', '141030', '大寧縣', '141000');
INSERT INTO `t_address_town` VALUES ('330', '141031', '隰 縣', '141000');
INSERT INTO `t_address_town` VALUES ('331', '141032', '永和縣', '141000');
INSERT INTO `t_address_town` VALUES ('332', '141033', '蒲 縣', '141000');
INSERT INTO `t_address_town` VALUES ('333', '141034', '汾西縣', '141000');
INSERT INTO `t_address_town` VALUES ('334', '141081', '侯馬市', '141000');
INSERT INTO `t_address_town` VALUES ('335', '141082', '霍州市', '141000');
INSERT INTO `t_address_town` VALUES ('336', '141101', '市轄區(qū)', '141100');
INSERT INTO `t_address_town` VALUES ('337', '141102', '離石區(qū)', '141100');
INSERT INTO `t_address_town` VALUES ('338', '141121', '文水縣', '141100');
INSERT INTO `t_address_town` VALUES ('339', '141122', '交城縣', '141100');
INSERT INTO `t_address_town` VALUES ('340', '141123', '興 縣', '141100');
INSERT INTO `t_address_town` VALUES ('341', '141124', '臨 縣', '141100');
INSERT INTO `t_address_town` VALUES ('342', '141125', '柳林縣', '141100');
INSERT INTO `t_address_town` VALUES ('343', '141126', '石樓縣', '141100');
INSERT INTO `t_address_town` VALUES ('344', '141127', '嵐 縣', '141100');
INSERT INTO `t_address_town` VALUES ('345', '141128', '方山縣', '141100');
INSERT INTO `t_address_town` VALUES ('346', '141129', '中陽(yáng)縣', '141100');
INSERT INTO `t_address_town` VALUES ('347', '141130', '交口縣', '141100');
INSERT INTO `t_address_town` VALUES ('348', '141181', '孝義市', '141100');
INSERT INTO `t_address_town` VALUES ('349', '141182', '汾陽(yáng)市', '141100');
INSERT INTO `t_address_town` VALUES ('350', '150101', '市轄區(qū)', '150100');
INSERT INTO `t_address_town` VALUES ('351', '150102', '新城區(qū)', '150100');
INSERT INTO `t_address_town` VALUES ('352', '150103', '回民區(qū)', '150100');
INSERT INTO `t_address_town` VALUES ('353', '150104', '玉泉區(qū)', '150100');
INSERT INTO `t_address_town` VALUES ('354', '150105', '賽罕區(qū)', '150100');
INSERT INTO `t_address_town` VALUES ('355', '150121', '土默特左旗', '150100');
INSERT INTO `t_address_town` VALUES ('356', '150122', '托克托縣', '150100');
INSERT INTO `t_address_town` VALUES ('357', '150123', '和林格爾縣', '150100');
INSERT INTO `t_address_town` VALUES ('358', '150124', '清水河縣', '150100');
INSERT INTO `t_address_town` VALUES ('359', '150125', '武川縣', '150100');
INSERT INTO `t_address_town` VALUES ('360', '150201', '市轄區(qū)', '150200');
INSERT INTO `t_address_town` VALUES ('361', '150202', '東河區(qū)', '150200');
INSERT INTO `t_address_town` VALUES ('362', '150203', '昆都侖區(qū)', '150200');
INSERT INTO `t_address_town` VALUES ('363', '150204', '青山區(qū)', '150200');
INSERT INTO `t_address_town` VALUES ('364', '150205', '石拐區(qū)', '150200');
INSERT INTO `t_address_town` VALUES ('365', '150206', '白云礦區(qū)', '150200');
INSERT INTO `t_address_town` VALUES ('366', '150207', '九原區(qū)', '150200');
INSERT INTO `t_address_town` VALUES ('367', '150221', '土默特右旗', '150200');
INSERT INTO `t_address_town` VALUES ('368', '150222', '固陽(yáng)縣', '150200');
INSERT INTO `t_address_town` VALUES ('369', '150223', '達(dá)爾罕茂明安聯(lián)合旗', '150200');
INSERT INTO `t_address_town` VALUES ('370', '150301', '市轄區(qū)', '150300');
INSERT INTO `t_address_town` VALUES ('371', '150302', '海勃灣區(qū)', '150300');
INSERT INTO `t_address_town` VALUES ('372', '150303', '海南區(qū)', '150300');
INSERT INTO `t_address_town` VALUES ('373', '150304', '烏達(dá)區(qū)', '150300');
INSERT INTO `t_address_town` VALUES ('374', '150401', '市轄區(qū)', '150400');
INSERT INTO `t_address_town` VALUES ('375', '150402', '紅山區(qū)', '150400');
INSERT INTO `t_address_town` VALUES ('376', '150403', '元寶山區(qū)', '150400');
INSERT INTO `t_address_town` VALUES ('377', '150404', '松山區(qū)', '150400');
INSERT INTO `t_address_town` VALUES ('378', '150421', '阿魯科爾沁旗', '150400');
INSERT INTO `t_address_town` VALUES ('379', '150422', '巴林左旗', '150400');
INSERT INTO `t_address_town` VALUES ('380', '150423', '巴林右旗', '150400');
INSERT INTO `t_address_town` VALUES ('381', '150424', '林西縣', '150400');
INSERT INTO `t_address_town` VALUES ('382', '150425', '克什克騰旗', '150400');
INSERT INTO `t_address_town` VALUES ('383', '150426', '翁牛特旗', '150400');
INSERT INTO `t_address_town` VALUES ('384', '150428', '喀喇沁旗', '150400');
INSERT INTO `t_address_town` VALUES ('385', '150429', '寧城縣', '150400');
INSERT INTO `t_address_town` VALUES ('386', '150430', '敖漢旗', '150400'); <
版權(quán)聲明:本站文章來(lái)源標(biāo)注為YINGSOO的內(nèi)容版權(quán)均為本站所有,歡迎引用、轉(zhuǎn)載,請(qǐng)保持原文完整并注明來(lái)源及原文鏈接。禁止復(fù)制或仿造本網(wǎng)站,禁止在非www.sddonglingsh.com所屬的服務(wù)器上建立鏡像,否則將依法追究法律責(zé)任。本站部分內(nèi)容來(lái)源于網(wǎng)友推薦、互聯(lián)網(wǎng)收集整理而來(lái),僅供學(xué)習(xí)參考,不代表本站立場(chǎng),如有內(nèi)容涉嫌侵權(quán),請(qǐng)聯(lián)系alex-e#qq.com處理。
相關(guān)文章