省市县三级联动的SQL语句

首先是建表语句
复制代码代码如下:
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 "区县编码",
`name` VARCHAR（40） NOT NULL COMMENT "区县名称",
`cityCode` CHAR（6） NOT NULL COMMENT "所属城市编码"
） ENGINE=InnoDB DEFAULT CHARSET=UTF8 COMMENT="区县信息表";

然后是省份信息表数据
复制代码代码如下:
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", "内蒙古自治区"）;
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", "广西壮族自治区"）;
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", "西藏自治区"）;
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", "宁夏回族自治区"）;
INSERT INTO `t_address_province` VALUES （"31", "650000", "新疆维吾尔自治区"）;
INSERT INTO `t_address_province` VALUES （"32", "710000", "台湾省"）;
INSERT INTO `t_address_province` VALUES （"33", "810000", "香港特别行政区"）;
INSERT INTO `t_address_province` VALUES （"34", "820000", "澳门特别行政区"）;

下面是城市信息表数据
复制代码代码如下:
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", "邢台市", "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", "阳泉市", "140000"）;
INSERT INTO `t_address_city` VALUES （"19", "140400", "长治市", "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", "运城市", "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", "沈阳市", "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", "营口市", "210000"）;
INSERT INTO `t_address_city` VALUES （"47", "210900", "阜新市", "210000"）;
INSERT INTO `t_address_city` VALUES （"48", "211000", "辽阳市", "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", "朝阳市", "210000"）;
INSERT INTO `t_address_city` VALUES （"52", "211400", "葫芦岛市", "210000"）;
INSERT INTO `t_address_city` VALUES （"53", "220100", "长春市", "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", "七台河市", "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", "大兴安岭地区", "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", "无锡市", "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", "扬州市", "320000"）;
INSERT INTO `t_address_city` VALUES （"87", "321100", "镇江市", "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", "台州市", "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", "阜阳市", "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", "景德镇市", "360000"）;
INSERT INTO `t_address_city` VALUES （"129", "360300", "萍乡市", "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", "济南市", "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", "东营市", "370000"）;
INSERT INTO `t_address_city` VALUES （"143", "370600", "烟台市", "370000"）;
INSERT INTO `t_address_city` VALUES （"144", "370700", "潍坊市", "370000"）;
INSERT INTO `t_address_city` VALUES （"145", "370800", "济宁市", "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", "洛阳市", "410000"）;
INSERT INTO `t_address_city` VALUES （"158", "410400", "平顶山市", "410000"）;
INSERT INTO `t_address_city` VALUES （"159", "410500", "安阳市", "410000"）;
INSERT INTO `t_address_city` VALUES （"160", "410600", "鹤壁市", "410000"）;
INSERT INTO `t_address_city` VALUES （"161", "410700", "新乡市", "410000"）;
INSERT INTO `t_address_city` VALUES （"162", "410800", "焦作市", "410000"）;
INSERT INTO `t_address_city` VALUES （"163", "410900", "濮阳市", "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", "南阳市", "410000"）;
INSERT INTO `t_address_city` VALUES （"168", "411400", "商丘市", "410000"）;
INSERT INTO `t_address_city` VALUES （"169", "411500", "信阳市", "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", "长沙市", "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", "衡阳市", "430000"）;
INSERT INTO `t_address_city` VALUES （"190", "430500", "邵阳市", "430000"）;
INSERT INTO `t_address_city` VALUES （"191", "430600", "岳阳市", "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", "益阳市", "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", "韶关市", "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", "阳江市", "440000"）;
INSERT INTO `t_address_city` VALUES （"215", "441800", "清远市", "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", "揭阳市", "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", "来宾市", "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", "省直辖县级行政单位", "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", "德阳市", "510000"）;
INSERT INTO `t_address_city` VALUES （"246", "510700", "绵阳市", "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", "内江市", "510000"）;
INSERT INTO `t_address_city` VALUES （"250", "511100", "乐山市", "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", "达州市", "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", "资阳市", "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", "贵阳市", "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", "铜仁地区", "520000"）;
INSERT INTO `t_address_city` VALUES （"267", "522300", "黔西南布依族苗族自治州", "520000"）;
INSERT INTO `t_address_city` VALUES （"268", "522400", "毕节地区", "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", "昌都地区", "540000"）;
INSERT INTO `t_address_city` VALUES （"289", "542200", "山南地区", "540000"）;
INSERT INTO `t_address_city` VALUES （"290", "542300", "日喀则地区", "540000"）;
INSERT INTO `t_address_city` VALUES （"291", "542400", "那曲地区", "540000"）;
INSERT INTO `t_address_city` VALUES （"292", "542500", "阿里地区", "540000"）;
INSERT INTO `t_address_city` VALUES （"293", "542600", "林芝地区", "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", "咸阳市", "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", "嘉峪关市", "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", "平凉市", "620000"）;
INSERT INTO `t_address_city` VALUES （"312", "620900", "酒泉市", "620000"）;
INSERT INTO `t_address_city` VALUES （"313", "621000", "庆阳市", "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", "海东地区", "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", "中卫市", "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", "吐鲁番地区", "650000"）;
INSERT INTO `t_address_city` VALUES （"334", "652200", "哈密地区", "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", "阿克苏地区", "650000"）;
INSERT INTO `t_address_city` VALUES （"339", "653000", "克孜勒苏柯尔克孜自治州", "650000"）;
INSERT INTO `t_address_city` VALUES （"340", "653100", "喀什地区", "650000"）;
INSERT INTO `t_address_city` VALUES （"341", "653200", "和田地区", "650000"）;
INSERT INTO `t_address_city` VALUES （"342", "654000", "伊犁哈萨克自治州", "650000"）;
INSERT INTO `t_address_city` VALUES （"343", "654200", "塔城地区", "650000"）;
INSERT INTO `t_address_city` VALUES （"344", "654300", "阿勒泰地区", "650000"）;
INSERT INTO `t_address_city` VALUES （"345", "659000", "省直辖行政单位", "650000"）;

最后是区县信息表数据

[sql] view plaincopyprint？

INSERT INTO `t_address_town` VALUES （"1", "110101", "东城区", "110100"）;
INSERT INTO `t_address_town` VALUES （"2", "110102", "西城区", "110100"）;
INSERT INTO `t_address_town` VALUES （"3", "110103", "崇文区", "110100"）;
INSERT INTO `t_address_town` VALUES （"4", "110104", "宣武区", "110100"）;
INSERT INTO `t_address_town` VALUES （"5", "110105", "朝阳区", "110100"）;
INSERT INTO `t_address_town` VALUES （"6", "110106", "丰台区", "110100"）;
INSERT INTO `t_address_town` VALUES （"7", "110107", "石景山区", "110100"）;
INSERT INTO `t_address_town` VALUES （"8", "110108", "海淀区", "110100"）;
INSERT INTO `t_address_town` VALUES （"9", "110109", "门头沟区", "110100"）;
INSERT INTO `t_address_town` VALUES （"10", "110111", "房山区", "110100"）;
INSERT INTO `t_address_town` VALUES （"11", "110112", "通州区", "110100"）;
INSERT INTO `t_address_town` VALUES （"12", "110113", "顺义区", "110100"）;
INSERT INTO `t_address_town` VALUES （"13", "110114", "昌平区", "110100"）;
INSERT INTO `t_address_town` VALUES （"14", "110115", "大兴区", "110100"）;
INSERT INTO `t_address_town` VALUES （"15", "110116", "怀柔区", "110100"）;
INSERT INTO `t_address_town` VALUES （"16", "110117", "平谷区", "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", "和平区", "120100"）;
INSERT INTO `t_address_town` VALUES （"20", "120102", "河东区", "120100"）;
INSERT INTO `t_address_town` VALUES （"21", "120103", "河西区", "120100"）;
INSERT INTO `t_address_town` VALUES （"22", "120104", "南开区", "120100"）;
INSERT INTO `t_address_town` VALUES （"23", "120105", "河北区", "120100"）;
INSERT INTO `t_address_town` VALUES （"24", "120106", "红桥区", "120100"）;
INSERT INTO `t_address_town` VALUES （"25", "120107", "塘沽区", "120100"）;
INSERT INTO `t_address_town` VALUES （"26", "120108", "汉沽区", "120100"）;
INSERT INTO `t_address_town` VALUES （"27", "120109", "大港区", "120100"）;
INSERT INTO `t_address_town` VALUES （"28", "120110", "东丽区", "120100"）;
INSERT INTO `t_address_town` VALUES （"29", "120111", "西青区", "120100"）;
INSERT INTO `t_address_town` VALUES （"30", "120112", "津南区", "120100"）;
INSERT INTO `t_address_town` VALUES （"31", "120113", "北辰区", "120100"）;
INSERT INTO `t_address_town` VALUES （"32", "120114", "武清区", "120100"）;
INSERT INTO `t_address_town` VALUES （"33", "120115", "宝坻区", "120100"）;
INSERT INTO `t_address_town` VALUES （"34", "120221", "宁河县", "120100"）;
INSERT INTO `t_address_town` VALUES （"35", "120223", "静海县", "120100"）;
INSERT INTO `t_address_town` VALUES （"36", "120225", "蓟县", "120100"）;
INSERT INTO `t_address_town` VALUES （"37", "130101", "市辖区", "130100"）;
INSERT INTO `t_address_town` VALUES （"38", "130102", "长安区", "130100"）;
INSERT INTO `t_address_town` VALUES （"39", "130103", "桥东区", "130100"）;
INSERT INTO `t_address_town` VALUES （"40", "130104", "桥西区", "130100"）;
INSERT INTO `t_address_town` VALUES （"41", "130105", "新华区", "130100"）;
INSERT INTO `t_address_town` VALUES （"42", "130107", "井陉矿区", "130100"）;
INSERT INTO `t_address_town` VALUES （"43", "130108", "裕华区", "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", "无极县", "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", "新乐市", "130100"）;
INSERT INTO `t_address_town` VALUES （"60", "130185", "鹿泉市", "130100"）;
INSERT INTO `t_address_town` VALUES （"61", "130201", "市辖区", "130200"）;
INSERT INTO `t_address_town` VALUES （"62", "130202", "路南区", "130200"）;
INSERT INTO `t_address_town` VALUES （"63", "130203", "路北区", "130200"）;
INSERT INTO `t_address_town` VALUES （"64", "130204", "古冶区", "130200"）;
INSERT INTO `t_address_town` VALUES （"65", "130205", "开平区", "130200"）;
INSERT INTO `t_address_town` VALUES （"66", "130207", "丰南区", "130200"）;
INSERT INTO `t_address_town` VALUES （"67", "130208", "丰润区", "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", "乐亭县", "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", "唐海县", "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", "市辖区", "130300"）;
INSERT INTO `t_address_town` VALUES （"77", "130302", "海港区", "130300"）;
INSERT INTO `t_address_town` VALUES （"78", "130303", "山海关区", "130300"）;
INSERT INTO `t_address_town` VALUES （"79", "130304", "北戴河区", "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", "市辖区", "130400"）;
INSERT INTO `t_address_town` VALUES （"85", "130402", "邯山区", "130400"）;
INSERT INTO `t_address_town` VALUES （"86", "130403", "丛台区", "130400"）;
INSERT INTO `t_address_town` VALUES （"87", "130404", "复兴区", "130400"）;
INSERT INTO `t_address_town` VALUES （"88", "130406", "峰峰矿区", "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", "肥乡县", "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", "市辖区", "130500"）;
INSERT INTO `t_address_town` VALUES （"105", "130502", "桥东区", "130500"）;
INSERT INTO `t_address_town` VALUES （"106", "130503", "桥西区", "130500"）;
INSERT INTO `t_address_town` VALUES （"107", "130521", "邢台县", "130500"）;
INSERT INTO `t_address_town` VALUES （"108", "130522", "临城县", "130500"）;
INSERT INTO `t_address_town` VALUES （"109", "130523", "内丘县", "130500"）;
INSERT INTO `t_address_town` VALUES （"110", "130524", "柏乡县", "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", "平乡县", "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", "市辖区", "130600"）;
INSERT INTO `t_address_town` VALUES （"125", "130602", "新市区", "130600"）;
INSERT INTO `t_address_town` VALUES （"126", "130603", "北市区", "130600"）;
INSERT INTO `t_address_town` VALUES （"127", "130604", "南市区", "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", "高阳县", "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", "曲阳县", "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", "安国市", "130600"）;
INSERT INTO `t_address_town` VALUES （"149", "130684", "高碑店市", "130600"）;
INSERT INTO `t_address_town` VALUES （"150", "130701", "市辖区", "130700"）;
INSERT INTO `t_address_town` VALUES （"151", "130702", "桥东区", "130700"）;
INSERT INTO `t_address_town` VALUES （"152", "130703", "桥西区", "130700"）;
INSERT INTO `t_address_town` VALUES （"153", "130705", "宣化区", "130700"）;
INSERT INTO `t_address_town` VALUES （"154", "130706", "下花园区", "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", "康保县", "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", "阳原县", "130700"）;
INSERT INTO `t_address_town` VALUES （"162", "130728", "怀安县", "130700"）;
INSERT INTO `t_address_town` VALUES （"163", "130729", "万全县", "130700"）;
INSERT INTO `t_address_town` VALUES （"164", "130730", "怀来县", "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", "市辖区", "130800"）;
INSERT INTO `t_address_town` VALUES （"169", "130802", "双桥区", "130800"）;
INSERT INTO `t_address_town` VALUES （"170", "130803", "双滦区", "130800"）;
INSERT INTO `t_address_town` VALUES （"171", "130804", "鹰手营子矿区", "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", "围场满族蒙古族自治县", "130800"）;
INSERT INTO `t_address_town` VALUES （"180", "130901", "市辖区", "130900"）;
INSERT INTO `t_address_town` VALUES （"181", "130902", "新华区", "130900"）;
INSERT INTO `t_address_town` VALUES （"182", "130903", "运河区", "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", "献县", "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", "市辖区", "131000"）;
INSERT INTO `t_address_town` VALUES （"198", "131002", "安次区", "131000"）;
INSERT INTO `t_address_town` VALUES （"199", "131003", "广阳区", "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", "市辖区", "131100"）;
INSERT INTO `t_address_town` VALUES （"209", "131102", "桃城区", "131100"）;
INSERT INTO `t_address_town` VALUES （"210", "131121", "枣强县", "131100"）;
INSERT INTO `t_address_town` VALUES （"211", "131122", "武邑县", "131100"）;
INSERT INTO `t_address_town` VALUES （"212", "131123", "武强县", "131100"）;
INSERT INTO `t_address_town` VALUES （"213", "131124", "饶阳县", "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", "市辖区", "140100"）;
INSERT INTO `t_address_town` VALUES （"221", "140105", "小店区", "140100"）;
INSERT INTO `t_address_town` VALUES （"222", "140106", "迎泽区", "140100"）;
INSERT INTO `t_address_town` VALUES （"223", "140107", "杏花岭区", "140100"）;
INSERT INTO `t_address_town` VALUES （"224", "140108", "尖草坪区", "140100"）;
INSERT INTO `t_address_town` VALUES （"225", "140109", "万柏林区", "140100"）;
INSERT INTO `t_address_town` VALUES （"226", "140110", "晋源区", "140100"）;
INSERT INTO `t_address_town` VALUES （"227", "140121", "清徐县", "140100"）;
INSERT INTO `t_address_town` VALUES （"228", "140122", "阳曲县", "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", "市辖区", "140200"）;
INSERT INTO `t_address_town` VALUES （"232", "140202", "城区", "140200"）;
INSERT INTO `t_address_town` VALUES （"233", "140203", "矿区", "140200"）;
INSERT INTO `t_address_town` VALUES （"234", "140211", "南郊区", "140200"）;
INSERT INTO `t_address_town` VALUES （"235", "140212", "新荣区", "140200"）;
INSERT INTO `t_address_town` VALUES （"236", "140221", "阳高县", "140200"）;
INSERT INTO `t_address_town` VALUES （"237", "140222", "天镇县", "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", "市辖区", "140300"）;
INSERT INTO `t_address_town` VALUES （"244", "140302", "城区", "140300"）;
INSERT INTO `t_address_town` VALUES （"245", "140303", "矿区", "140300"）;
INSERT INTO `t_address_town` VALUES （"246", "140311", "郊区", "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", "市辖区", "140400"）;
INSERT INTO `t_address_town` VALUES （"250", "140402", "城区", "140400"）;
INSERT INTO `t_address_town` VALUES （"251", "140411", "郊区", "140400"）;
INSERT INTO `t_address_town` VALUES （"252", "140421", "长治县", "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", "壶关县", "140400"）;
INSERT INTO `t_address_town` VALUES （"258", "140428", "长子县", "140400"）;
INSERT INTO `t_address_town` VALUES （"259", "140429", "武乡县", "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", "市辖区", "140500"）;
INSERT INTO `t_address_town` VALUES （"264", "140502", "城区", "140500"）;
INSERT INTO `t_address_town` VALUES （"265", "140521", "沁水县", "140500"）;
INSERT INTO `t_address_town` VALUES （"266", "140522", "阳城县", "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", "市辖区", "140600"）;
INSERT INTO `t_address_town` VALUES （"271", "140602", "朔城区", "140600"）;
INSERT INTO `t_address_town` VALUES （"272", "140603", "平鲁区", "140600"）;
INSERT INTO `t_address_town` VALUES （"273", "140621", "山阴县", "140600"）;
INSERT INTO `t_address_town` VALUES （"274", "140622", "应县", "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", "市辖区", "140700"）;
INSERT INTO `t_address_town` VALUES （"278", "140702", "榆次区", "140700"）;
INSERT INTO `t_address_town` VALUES （"279", "140721", "榆社县", "140700"）;
INSERT INTO `t_address_town` VALUES （"280", "140722", "左权县", "140700"）;
INSERT INTO `t_address_town` VALUES （"281", "140723", "和顺县", "140700"）;
INSERT INTO `t_address_town` VALUES （"282", "140724", "昔阳县", "140700"）;
INSERT INTO `t_address_town` VALUES （"283", "140725", "寿阳县", "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", "市辖区", "140800"）;
INSERT INTO `t_address_town` VALUES （"290", "140802", "盐湖区", "140800"）;
INSERT INTO `t_address_town` VALUES （"291", "140821", "临猗县", "140800"）;
INSERT INTO `t_address_town` VALUES （"292", "140822", "万荣县", "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", "永济市", "140800"）;
INSERT INTO `t_address_town` VALUES （"302", "140882", "河津市", "140800"）;
INSERT INTO `t_address_town` VALUES （"303", "140901", "市辖区", "140900"）;
INSERT INTO `t_address_town` VALUES （"304", "140902", "忻府区", "140900"）;
INSERT INTO `t_address_town` VALUES （"305", "140921", "定襄县", "140900"）;
INSERT INTO `t_address_town` VALUES （"306", "140922", "五台县", "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", "静乐县", "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", "偏关县", "140900"）;
INSERT INTO `t_address_town` VALUES （"317", "140981", "原平市", "140900"）;
INSERT INTO `t_address_town` VALUES （"318", "141001", "市辖区", "141000"）;
INSERT INTO `t_address_town` VALUES （"319", "141002", "尧都区", "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", "乡宁县", "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", "市辖区", "141100"）;
INSERT INTO `t_address_town` VALUES （"337", "141102", "离石区", "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", "中阳县", "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", "汾阳市", "141100"）;
INSERT INTO `t_address_town` VALUES （"350", "150101", "市辖区", "150100"）;
INSERT INTO `t_address_town` VALUES （"351", "150102", "新城区", "150100"）;
INSERT INTO `t_address_town` VALUES （"352", "150103", "回民区", "150100"）;
INSERT INTO `t_address_town` VALUES （"353", "150104", "玉泉区", "150100"）;
INSERT INTO `t_address_town` VALUES （"354", "150105", "赛罕区", "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", "市辖区", "150200"）;
INSERT INTO `t_address_town` VALUES （"361", "150202", "东河区", "150200"）;
INSERT INTO `t_address_town` VALUES （"362", "150203", "昆都仑区", "150200"）;
INSERT INTO `t_address_town` VALUES