文档章节

中国省市二级地区表

hirainn
 hirainn
发布于 2017/08/16 17:51
字数 4554
阅读 56
收藏 0

1.表定义

create table area(
id int primary key auto_increment, name varchar(20) not null default comment '名称',  
parent_id int comment '归属地id'

2.插入数据

INSERT INTO area(name, parent_id) VALUES ('北京市',0);
INSERT INTO area(name, parent_id) VALUES ('天津市',0);
INSERT INTO area(name, parent_id) VALUES ('上海市',0);
INSERT INTO area(name, parent_id) VALUES ('重庆市',0);
INSERT INTO area(name, parent_id) VALUES ('河北省',0);
INSERT INTO area(name, parent_id) VALUES ('山西省',0);
INSERT INTO area(name, parent_id) VALUES ('台湾省',0);
INSERT INTO area(name, parent_id) VALUES ('辽宁省',0);
INSERT INTO area(name, parent_id) VALUES ('吉林省',0);
INSERT INTO area(name, parent_id) VALUES ('黑龙江省',0);
INSERT INTO area(name, parent_id) VALUES ('江苏省',0);
INSERT INTO area(name, parent_id) VALUES ('浙江省',0);
INSERT INTO area(name, parent_id) VALUES ('安徽省',0);
INSERT INTO area(name, parent_id) VALUES ('福建省',0);
INSERT INTO area(name, parent_id) VALUES ('江西省',0);
INSERT INTO area(name, parent_id) VALUES ('山东省',0);
INSERT INTO area(name, parent_id) VALUES ('河南省',0);
INSERT INTO area(name, parent_id) VALUES ('湖北省',0);
INSERT INTO area(name, parent_id) VALUES ('湖南省',0);
INSERT INTO area(name, parent_id) VALUES ('广东省',0);
INSERT INTO area(name, parent_id) VALUES ('甘肃省',0);
INSERT INTO area(name, parent_id) VALUES ('四川省',0);
INSERT INTO area(name, parent_id) VALUES ('贵州省',0);
INSERT INTO area(name, parent_id) VALUES ('海南省',0);
INSERT INTO area(name, parent_id) VALUES ('云南省',0);
INSERT INTO area(name, parent_id) VALUES ('青海省',0);
INSERT INTO area(name, parent_id) VALUES ('陕西省',0);
INSERT INTO area(name, parent_id) VALUES ('广西壮族自治区',0);
INSERT INTO area(name, parent_id) VALUES ('西藏自治区',0);
INSERT INTO area(name, parent_id) VALUES ('宁夏回族自治区',0);
INSERT INTO area(name, parent_id) VALUES ('新疆维吾尔自治区',0);
INSERT INTO area(name, parent_id) VALUES ('内蒙古自治区',0);
INSERT INTO area(name, parent_id) VALUES ('澳门特别行政区',0);
INSERT INTO area(name, parent_id) VALUES ('香港特别行政区',0);
INSERT INTO area(name, parent_id) VALUES ('北京市',1);
INSERT INTO area(name, parent_id) VALUES ('天津市',2);
INSERT INTO area(name, parent_id) VALUES ('上海市',3);
INSERT INTO area(name, parent_id) VALUES ('重庆市',4);
INSERT INTO area(name, parent_id) VALUES ('石家庄市',5);
INSERT INTO area(name, parent_id) VALUES ('保定市',5);
INSERT INTO area(name, parent_id) VALUES ('唐山市',5);
INSERT INTO area(name, parent_id) VALUES ('廊坊市',5);
INSERT INTO area(name, parent_id) VALUES ('张家口市',5);
INSERT INTO area(name, parent_id) VALUES ('承德市',5);
INSERT INTO area(name, parent_id) VALUES ('沧州市',5);
INSERT INTO area(name, parent_id) VALUES ('秦皇岛市',5);
INSERT INTO area(name, parent_id) VALUES ('衡水市',5);
INSERT INTO area(name, parent_id) VALUES ('邢台市',5);
INSERT INTO area(name, parent_id) VALUES ('邯郸市',5);
INSERT INTO area(name, parent_id) VALUES ('太原市',6);
INSERT INTO area(name, parent_id) VALUES ('临汾市',6);
INSERT INTO area(name, parent_id) VALUES ('吕梁市',6);
INSERT INTO area(name, parent_id) VALUES ('大同市',6);
INSERT INTO area(name, parent_id) VALUES ('忻州市',6);
INSERT INTO area(name, parent_id) VALUES ('晋中市',6);
INSERT INTO area(name, parent_id) VALUES ('晋城市',6);
INSERT INTO area(name, parent_id) VALUES ('朔州市',6);
INSERT INTO area(name, parent_id) VALUES ('运城市',6);
INSERT INTO area(name, parent_id) VALUES ('长治市',6);
INSERT INTO area(name, parent_id) VALUES ('阳泉市',6);
INSERT INTO area(name, parent_id) VALUES ('台北市',7);
INSERT INTO area(name, parent_id) VALUES ('云林县',7);
INSERT INTO area(name, parent_id) VALUES ('南投县',7);
INSERT INTO area(name, parent_id) VALUES ('台东县',7);
INSERT INTO area(name, parent_id) VALUES ('台中县',7);
INSERT INTO area(name, parent_id) VALUES ('台中市',7);
INSERT INTO area(name, parent_id) VALUES ('台北县',7);
INSERT INTO area(name, parent_id) VALUES ('台南县',7);
INSERT INTO area(name, parent_id) VALUES ('台南市',7);
INSERT INTO area(name, parent_id) VALUES ('嘉义县',7);
INSERT INTO area(name, parent_id) VALUES ('嘉义市',7);
INSERT INTO area(name, parent_id) VALUES ('基隆市',7);
INSERT INTO area(name, parent_id) VALUES ('宜兰县',7);
INSERT INTO area(name, parent_id) VALUES ('屏东县',7);
INSERT INTO area(name, parent_id) VALUES ('彰化县',7);
INSERT INTO area(name, parent_id) VALUES ('新竹县',7);
INSERT INTO area(name, parent_id) VALUES ('新竹市',7);
INSERT INTO area(name, parent_id) VALUES ('桃园县',7);
INSERT INTO area(name, parent_id) VALUES ('澎湖县',7);
INSERT INTO area(name, parent_id) VALUES ('花莲县',7);
INSERT INTO area(name, parent_id) VALUES ('苗栗县',7);
INSERT INTO area(name, parent_id) VALUES ('高雄县',7);
INSERT INTO area(name, parent_id) VALUES ('高雄市',7);
INSERT INTO area(name, parent_id) VALUES ('沈阳市',8);
INSERT INTO area(name, parent_id) VALUES ('大连市',8);
INSERT INTO area(name, parent_id) VALUES ('丹东市',8);
INSERT INTO area(name, parent_id) VALUES ('抚顺市',8);
INSERT INTO area(name, parent_id) VALUES ('朝阳市',8);
INSERT INTO area(name, parent_id) VALUES ('本溪市',8);
INSERT INTO area(name, parent_id) VALUES ('盘锦市',8);
INSERT INTO area(name, parent_id) VALUES ('营口市',8);
INSERT INTO area(name, parent_id) VALUES ('葫芦岛市',8);
INSERT INTO area(name, parent_id) VALUES ('辽阳市',8);
INSERT INTO area(name, parent_id) VALUES ('铁岭市',8);
INSERT INTO area(name, parent_id) VALUES ('锦州市',8);
INSERT INTO area(name, parent_id) VALUES ('阜新市',8);
INSERT INTO area(name, parent_id) VALUES ('鞍山市',8);
INSERT INTO area(name, parent_id) VALUES ('长春市',9);
INSERT INTO area(name, parent_id) VALUES ('吉林市',9);
INSERT INTO area(name, parent_id) VALUES ('四平市',9);
INSERT INTO area(name, parent_id) VALUES ('延边朝鲜族自治州',9);
INSERT INTO area(name, parent_id) VALUES ('松原市',9);
INSERT INTO area(name, parent_id) VALUES ('白城市',9);
INSERT INTO area(name, parent_id) VALUES ('白山市',9);
INSERT INTO area(name, parent_id) VALUES ('辽源市',9);
INSERT INTO area(name, parent_id) VALUES ('通化市',9);
INSERT INTO area(name, parent_id) VALUES ('哈尔滨市',10);
INSERT INTO area(name, parent_id) VALUES ('七台河市',10);
INSERT INTO area(name, parent_id) VALUES ('伊 春 市',10);
INSERT INTO area(name, parent_id) VALUES ('佳木斯市',10);
INSERT INTO area(name, parent_id) VALUES ('双鸭山市',10);
INSERT INTO area(name, parent_id) VALUES ('大 庆 市',10);
INSERT INTO area(name, parent_id) VALUES ('大兴安岭地区',10);
INSERT INTO area(name, parent_id) VALUES ('牡丹江市',10);
INSERT INTO area(name, parent_id) VALUES ('绥 化 市',10);
INSERT INTO area(name, parent_id) VALUES ('鸡 西 市',10);
INSERT INTO area(name, parent_id) VALUES ('鹤 岗 市',10);
INSERT INTO area(name, parent_id) VALUES ('黑 河 市',10);
INSERT INTO area(name, parent_id) VALUES ('齐齐哈尔市',10);
INSERT INTO area(name, parent_id) VALUES ('南京市',11);
INSERT INTO area(name, parent_id) VALUES ('南通市',11);
INSERT INTO area(name, parent_id) VALUES ('宿迁市',11);
INSERT INTO area(name, parent_id) VALUES ('常州市',11);
INSERT INTO area(name, parent_id) VALUES ('徐州市',11);
INSERT INTO area(name, parent_id) VALUES ('扬州市',11);
INSERT INTO area(name, parent_id) VALUES ('无锡市',11);
INSERT INTO area(name, parent_id) VALUES ('泰州市',11);
INSERT INTO area(name, parent_id) VALUES ('淮安市',11);
INSERT INTO area(name, parent_id) VALUES ('盐城市',11);
INSERT INTO area(name, parent_id) VALUES ('苏州市',11);
INSERT INTO area(name, parent_id) VALUES ('连云港市',11);
INSERT INTO area(name, parent_id) VALUES ('镇江市',11);
INSERT INTO area(name, parent_id) VALUES ('杭州市',12);
INSERT INTO area(name, parent_id) VALUES ('丽水市',12);
INSERT INTO area(name, parent_id) VALUES ('台州市',12);
INSERT INTO area(name, parent_id) VALUES ('嘉兴市',12);
INSERT INTO area(name, parent_id) VALUES ('宁波市',12);
INSERT INTO area(name, parent_id) VALUES ('温州市',12);
INSERT INTO area(name, parent_id) VALUES ('湖州市',12);
INSERT INTO area(name, parent_id) VALUES ('绍兴市',12);
INSERT INTO area(name, parent_id) VALUES ('舟山市',12);
INSERT INTO area(name, parent_id) VALUES ('衢州市',12);
INSERT INTO area(name, parent_id) VALUES ('金华市',12);
INSERT INTO area(name, parent_id) VALUES ('合肥市',13);
INSERT INTO area(name, parent_id) VALUES ('亳州市',13);
INSERT INTO area(name, parent_id) VALUES ('六安市',13);
INSERT INTO area(name, parent_id) VALUES ('安庆市',13);
INSERT INTO area(name, parent_id) VALUES ('宣城市',13);
INSERT INTO area(name, parent_id) VALUES ('宿州市',13);
INSERT INTO area(name, parent_id) VALUES ('巢湖市',13);
INSERT INTO area(name, parent_id) VALUES ('池州市',13);
INSERT INTO area(name, parent_id) VALUES ('淮北市',13);
INSERT INTO area(name, parent_id) VALUES ('淮南市',13);
INSERT INTO area(name, parent_id) VALUES ('滁州市',13);
INSERT INTO area(name, parent_id) VALUES ('芜湖市',13);
INSERT INTO area(name, parent_id) VALUES ('蚌埠市',13);
INSERT INTO area(name, parent_id) VALUES ('铜陵市',13);
INSERT INTO area(name, parent_id) VALUES ('阜阳市',13);
INSERT INTO area(name, parent_id) VALUES ('马鞍山市',13);
INSERT INTO area(name, parent_id) VALUES ('黄山市',13);
INSERT INTO area(name, parent_id) VALUES ('福州市',14);
INSERT INTO area(name, parent_id) VALUES ('三明市',14);
INSERT INTO area(name, parent_id) VALUES ('南平市',14);
INSERT INTO area(name, parent_id) VALUES ('厦门市',14);
INSERT INTO area(name, parent_id) VALUES ('宁德市',14);
INSERT INTO area(name, parent_id) VALUES ('泉州市',14);
INSERT INTO area(name, parent_id) VALUES ('漳州市',14);
INSERT INTO area(name, parent_id) VALUES ('莆田市',14);
INSERT INTO area(name, parent_id) VALUES ('龙岩市',14);
INSERT INTO area(name, parent_id) VALUES ('南昌市',15);
INSERT INTO area(name, parent_id) VALUES ('上饶市',15);
INSERT INTO area(name, parent_id) VALUES ('九江市',15);
INSERT INTO area(name, parent_id) VALUES ('吉安市',15);
INSERT INTO area(name, parent_id) VALUES ('宜春市',15);
INSERT INTO area(name, parent_id) VALUES ('抚州市',15);
INSERT INTO area(name, parent_id) VALUES ('新余市',15);
INSERT INTO area(name, parent_id) VALUES ('景德镇市',15);
INSERT INTO area(name, parent_id) VALUES ('萍乡市',15);
INSERT INTO area(name, parent_id) VALUES ('赣州市',15);
INSERT INTO area(name, parent_id) VALUES ('鹰潭市',15);
INSERT INTO area(name, parent_id) VALUES ('济南市',16);
INSERT INTO area(name, parent_id) VALUES ('东营市',16);
INSERT INTO area(name, parent_id) VALUES ('临沂市',16);
INSERT INTO area(name, parent_id) VALUES ('威海市',16);
INSERT INTO area(name, parent_id) VALUES ('德州市',16);
INSERT INTO area(name, parent_id) VALUES ('日照市',16);
INSERT INTO area(name, parent_id) VALUES ('枣庄市',16);
INSERT INTO area(name, parent_id) VALUES ('泰安市',16);
INSERT INTO area(name, parent_id) VALUES ('济宁市',16);
INSERT INTO area(name, parent_id) VALUES ('淄博市',16);
INSERT INTO area(name, parent_id) VALUES ('滨州市',16);
INSERT INTO area(name, parent_id) VALUES ('潍坊市',16);
INSERT INTO area(name, parent_id) VALUES ('烟台市',16);
INSERT INTO area(name, parent_id) VALUES ('聊城市',16);
INSERT INTO area(name, parent_id) VALUES ('莱芜市',16);
INSERT INTO area(name, parent_id) VALUES ('菏泽市',16);
INSERT INTO area(name, parent_id) VALUES ('青岛市',16);
INSERT INTO area(name, parent_id) VALUES ('郑州市',17);
INSERT INTO area(name, parent_id) VALUES ('三门峡市',17);
INSERT INTO area(name, parent_id) VALUES ('信阳市',17);
INSERT INTO area(name, parent_id) VALUES ('南阳市',17);
INSERT INTO area(name, parent_id) VALUES ('周口市',17);
INSERT INTO area(name, parent_id) VALUES ('商丘市',17);
INSERT INTO area(name, parent_id) VALUES ('安阳市',17);
INSERT INTO area(name, parent_id) VALUES ('平顶山市',17);
INSERT INTO area(name, parent_id) VALUES ('开封市',17);
INSERT INTO area(name, parent_id) VALUES ('新乡市',17);
INSERT INTO area(name, parent_id) VALUES ('洛阳市',17);
INSERT INTO area(name, parent_id) VALUES ('济源市',17);
INSERT INTO area(name, parent_id) VALUES ('漯河市',17);
INSERT INTO area(name, parent_id) VALUES ('濮阳市',17);
INSERT INTO area(name, parent_id) VALUES ('焦作市',17);
INSERT INTO area(name, parent_id) VALUES ('许昌市',17);
INSERT INTO area(name, parent_id) VALUES ('驻马店市',17);
INSERT INTO area(name, parent_id) VALUES ('鹤壁市',17);
INSERT INTO area(name, parent_id) VALUES ('武汉市',18);
INSERT INTO area(name, parent_id) VALUES ('仙桃市',18);
INSERT INTO area(name, parent_id) VALUES ('十堰市',18);
INSERT INTO area(name, parent_id) VALUES ('咸宁市',18);
INSERT INTO area(name, parent_id) VALUES ('天门市',18);
INSERT INTO area(name, parent_id) VALUES ('孝感市',18);
INSERT INTO area(name, parent_id) VALUES ('宜昌市',18);
INSERT INTO area(name, parent_id) VALUES ('恩施土家族苗族自治州',18);
INSERT INTO area(name, parent_id) VALUES ('潜江市',18);
INSERT INTO area(name, parent_id) VALUES ('神农架林区',18);
INSERT INTO area(name, parent_id) VALUES ('荆州市',18);
INSERT INTO area(name, parent_id) VALUES ('荆门市',18);
INSERT INTO area(name, parent_id) VALUES ('襄樊市',18);
INSERT INTO area(name, parent_id) VALUES ('鄂州市',18);
INSERT INTO area(name, parent_id) VALUES ('随州市',18);
INSERT INTO area(name, parent_id) VALUES ('黄冈市',18);
INSERT INTO area(name, parent_id) VALUES ('黄石市',18);
INSERT INTO area(name, parent_id) VALUES ('长沙市',19);
INSERT INTO area(name, parent_id) VALUES ('娄底市',19);
INSERT INTO area(name, parent_id) VALUES ('岳阳市',19);
INSERT INTO area(name, parent_id) VALUES ('常德市',19);
INSERT INTO area(name, parent_id) VALUES ('张家界市',19);
INSERT INTO area(name, parent_id) VALUES ('怀化市',19);
INSERT INTO area(name, parent_id) VALUES ('株洲市',19);
INSERT INTO area(name, parent_id) VALUES ('永州市',19);
INSERT INTO area(name, parent_id) VALUES ('湘潭市',19);
INSERT INTO area(name, parent_id) VALUES ('湘西土家族苗族自治州',19);
INSERT INTO area(name, parent_id) VALUES ('益阳市',19);
INSERT INTO area(name, parent_id) VALUES ('衡阳市',19);
INSERT INTO area(name, parent_id) VALUES ('邵阳市',19);
INSERT INTO area(name, parent_id) VALUES ('郴州市',19);
INSERT INTO area(name, parent_id) VALUES ('广州市',20);
INSERT INTO area(name, parent_id) VALUES ('东莞市',20);
INSERT INTO area(name, parent_id) VALUES ('中山市',20);
INSERT INTO area(name, parent_id) VALUES ('云浮市',20);
INSERT INTO area(name, parent_id) VALUES ('佛山市',20);
INSERT INTO area(name, parent_id) VALUES ('惠州市',20);
INSERT INTO area(name, parent_id) VALUES ('揭阳市',20);
INSERT INTO area(name, parent_id) VALUES ('梅州市',20);
INSERT INTO area(name, parent_id) VALUES ('汕头市',20);
INSERT INTO area(name, parent_id) VALUES ('汕尾市',20);
INSERT INTO area(name, parent_id) VALUES ('江门市',20);
INSERT INTO area(name, parent_id) VALUES ('河源市',20);
INSERT INTO area(name, parent_id) VALUES ('深圳市',20);
INSERT INTO area(name, parent_id) VALUES ('清远市',20);
INSERT INTO area(name, parent_id) VALUES ('湛江市',20);
INSERT INTO area(name, parent_id) VALUES ('潮州市',20);
INSERT INTO area(name, parent_id) VALUES ('珠海市',20);
INSERT INTO area(name, parent_id) VALUES ('肇庆市',20);
INSERT INTO area(name, parent_id) VALUES ('茂名市',20);
INSERT INTO area(name, parent_id) VALUES ('阳江市',20);
INSERT INTO area(name, parent_id) VALUES ('韶关市',20);
INSERT INTO area(name, parent_id) VALUES ('兰州市',21);
INSERT INTO area(name, parent_id) VALUES ('临夏回族自治州',21);
INSERT INTO area(name, parent_id) VALUES ('嘉峪关市',21);
INSERT INTO area(name, parent_id) VALUES ('天水市',21);
INSERT INTO area(name, parent_id) VALUES ('定西市',21);
INSERT INTO area(name, parent_id) VALUES ('平凉市',21);
INSERT INTO area(name, parent_id) VALUES ('庆阳市',21);
INSERT INTO area(name, parent_id) VALUES ('张掖市',21);
INSERT INTO area(name, parent_id) VALUES ('武威市',21);
INSERT INTO area(name, parent_id) VALUES ('甘南藏族自治州',21);
INSERT INTO area(name, parent_id) VALUES ('白银市',21);
INSERT INTO area(name, parent_id) VALUES ('酒泉市',21);
INSERT INTO area(name, parent_id) VALUES ('金昌市',21);
INSERT INTO area(name, parent_id) VALUES ('陇南市',21);
INSERT INTO area(name, parent_id) VALUES ('成都市',22);
INSERT INTO area(name, parent_id) VALUES ('乐山市',22);
INSERT INTO area(name, parent_id) VALUES ('内江市',22);
INSERT INTO area(name, parent_id) VALUES ('凉山彝族自治州',22);
INSERT INTO area(name, parent_id) VALUES ('南充市',22);
INSERT INTO area(name, parent_id) VALUES ('宜宾市',22);
INSERT INTO area(name, parent_id) VALUES ('巴中市',22);
INSERT INTO area(name, parent_id) VALUES ('广元市',22);
INSERT INTO area(name, parent_id) VALUES ('广安市',22);
INSERT INTO area(name, parent_id) VALUES ('德阳市',22);
INSERT INTO area(name, parent_id) VALUES ('攀枝花市',22);
INSERT INTO area(name, parent_id) VALUES ('泸州市',22);
INSERT INTO area(name, parent_id) VALUES ('甘孜藏族自治州',22);
INSERT INTO area(name, parent_id) VALUES ('眉山市',22);
INSERT INTO area(name, parent_id) VALUES ('绵阳市',22);
INSERT INTO area(name, parent_id) VALUES ('自贡市',22);
INSERT INTO area(name, parent_id) VALUES ('资阳市',22);
INSERT INTO area(name, parent_id) VALUES ('达州市',22);
INSERT INTO area(name, parent_id) VALUES ('遂宁市',22);
INSERT INTO area(name, parent_id) VALUES ('阿坝藏族羌族自治州',22);
INSERT INTO area(name, parent_id) VALUES ('雅安市',22);
INSERT INTO area(name, parent_id) VALUES ('贵阳市',23);
INSERT INTO area(name, parent_id) VALUES ('六盘水市',23);
INSERT INTO area(name, parent_id) VALUES ('安顺市',23);
INSERT INTO area(name, parent_id) VALUES ('毕节地区',23);
INSERT INTO area(name, parent_id) VALUES ('遵义市',23);
INSERT INTO area(name, parent_id) VALUES ('铜仁地区',23);
INSERT INTO area(name, parent_id) VALUES ('黔东南苗族侗族自治州',23);
INSERT INTO area(name, parent_id) VALUES ('黔南布依族苗族自治州',23);
INSERT INTO area(name, parent_id) VALUES ('黔西南布依族苗族自治州',23);
INSERT INTO area(name, parent_id) VALUES ('海口市',24);
INSERT INTO area(name, parent_id) VALUES ('万宁市',24);
INSERT INTO area(name, parent_id) VALUES ('三亚市',24);
INSERT INTO area(name, parent_id) VALUES ('东方市',24);
INSERT INTO area(name, parent_id) VALUES ('临高县',24);
INSERT INTO area(name, parent_id) VALUES ('乐东黎族自治县',24);
INSERT INTO area(name, parent_id) VALUES ('五指山市',24);
INSERT INTO area(name, parent_id) VALUES ('保亭黎族苗族自治县',24);
INSERT INTO area(name, parent_id) VALUES ('儋州市',24);
INSERT INTO area(name, parent_id) VALUES ('定安县',24);
INSERT INTO area(name, parent_id) VALUES ('屯昌县',24);
INSERT INTO area(name, parent_id) VALUES ('文昌市',24);
INSERT INTO area(name, parent_id) VALUES ('昌江黎族自治县',24);
INSERT INTO area(name, parent_id) VALUES ('澄迈县',24);
INSERT INTO area(name, parent_id) VALUES ('琼中黎族苗族自治县',24);
INSERT INTO area(name, parent_id) VALUES ('琼海市',24);
INSERT INTO area(name, parent_id) VALUES ('白沙黎族自治县',24);
INSERT INTO area(name, parent_id) VALUES ('陵水黎族自治县',24);
INSERT INTO area(name, parent_id) VALUES ('昆明市',25);
INSERT INTO area(name, parent_id) VALUES ('临沧市',25);
INSERT INTO area(name, parent_id) VALUES ('丽江市',25);
INSERT INTO area(name, parent_id) VALUES ('保山市',25);
INSERT INTO area(name, parent_id) VALUES ('大理白族自治州',25);
INSERT INTO area(name, parent_id) VALUES ('德宏傣族景颇族自治州',25);
INSERT INTO area(name, parent_id) VALUES ('怒江傈傈族自治州',25);
INSERT INTO area(name, parent_id) VALUES ('思茅市',25);
INSERT INTO area(name, parent_id) VALUES ('文山壮族苗族自治州',25);
INSERT INTO area(name, parent_id) VALUES ('昭通市',25);
INSERT INTO area(name, parent_id) VALUES ('曲靖市',25);
INSERT INTO area(name, parent_id) VALUES ('楚雄彝族自治州',25);
INSERT INTO area(name, parent_id) VALUES ('玉溪市',25);
INSERT INTO area(name, parent_id) VALUES ('红河哈尼族彝族自治州',25);
INSERT INTO area(name, parent_id) VALUES ('西双版纳傣族自治州',25);
INSERT INTO area(name, parent_id) VALUES ('迪庆藏族自治州',25);
INSERT INTO area(name, parent_id) VALUES ('西宁市',26);
INSERT INTO area(name, parent_id) VALUES ('果洛藏族自治州',26);
INSERT INTO area(name, parent_id) VALUES ('海东地区',26);
INSERT INTO area(name, parent_id) VALUES ('海北藏族自治州',26);
INSERT INTO area(name, parent_id) VALUES ('海南藏族自治州',26);
INSERT INTO area(name, parent_id) VALUES ('海西蒙古族藏族自治州',26);
INSERT INTO area(name, parent_id) VALUES ('玉树藏族自治州',26);
INSERT INTO area(name, parent_id) VALUES ('黄南藏族自治州',26);
INSERT INTO area(name, parent_id) VALUES ('西安市',27);
INSERT INTO area(name, parent_id) VALUES ('咸阳市',27);
INSERT INTO area(name, parent_id) VALUES ('商洛市',27);
INSERT INTO area(name, parent_id) VALUES ('安康市',27);
INSERT INTO area(name, parent_id) VALUES ('宝鸡市',27);
INSERT INTO area(name, parent_id) VALUES ('延安市',27);
INSERT INTO area(name, parent_id) VALUES ('榆林市',27);
INSERT INTO area(name, parent_id) VALUES ('汉中市',27);
INSERT INTO area(name, parent_id) VALUES ('渭南市',27);
INSERT INTO area(name, parent_id) VALUES ('铜川市',27);
INSERT INTO area(name, parent_id) VALUES ('桂林市',28);
INSERT INTO area(name, parent_id) VALUES ('北海市',28);
INSERT INTO area(name, parent_id) VALUES ('南宁市',28);
INSERT INTO area(name, parent_id) VALUES ('崇左市',28);
INSERT INTO area(name, parent_id) VALUES ('来宾市',28);
INSERT INTO area(name, parent_id) VALUES ('柳州市',28);
INSERT INTO area(name, parent_id) VALUES ('梧州市',28);
INSERT INTO area(name, parent_id) VALUES ('河池市',28);
INSERT INTO area(name, parent_id) VALUES ('玉林市',28);
INSERT INTO area(name, parent_id) VALUES ('百色市',28);
INSERT INTO area(name, parent_id) VALUES ('贵港市',28);
INSERT INTO area(name, parent_id) VALUES ('贺州市',28);
INSERT INTO area(name, parent_id) VALUES ('钦州市',28);
INSERT INTO area(name, parent_id) VALUES ('防城港市',28);
INSERT INTO area(name, parent_id) VALUES ('拉萨市',29);
INSERT INTO area(name, parent_id) VALUES ('山南地区',29);
INSERT INTO area(name, parent_id) VALUES ('日喀则地区',29);
INSERT INTO area(name, parent_id) VALUES ('昌都地区',29);
INSERT INTO area(name, parent_id) VALUES ('林芝地区',29);
INSERT INTO area(name, parent_id) VALUES ('那曲地区',29);
INSERT INTO area(name, parent_id) VALUES ('阿里地区',29);
INSERT INTO area(name, parent_id) VALUES ('中卫市',30);
INSERT INTO area(name, parent_id) VALUES ('吴忠市',30);
INSERT INTO area(name, parent_id) VALUES ('固原市',30);
INSERT INTO area(name, parent_id) VALUES ('石嘴山市',30);
INSERT INTO area(name, parent_id) VALUES ('银川市',30);
INSERT INTO area(name, parent_id) VALUES ('乌鲁木齐市',31);
INSERT INTO area(name, parent_id) VALUES ('乌苏市',31);
INSERT INTO area(name, parent_id) VALUES ('五家渠市',31);
INSERT INTO area(name, parent_id) VALUES ('伊宁市',31);
INSERT INTO area(name, parent_id) VALUES ('克拉玛依市',31);
INSERT INTO area(name, parent_id) VALUES ('博乐市',31);
INSERT INTO area(name, parent_id) VALUES ('吐鲁番市',31);
INSERT INTO area(name, parent_id) VALUES ('和田市',31);
INSERT INTO area(name, parent_id) VALUES ('哈密市',31);
INSERT INTO area(name, parent_id) VALUES ('喀什市',31);
INSERT INTO area(name, parent_id) VALUES ('图木舒克市',31);
INSERT INTO area(name, parent_id) VALUES ('塔城市',31);
INSERT INTO area(name, parent_id) VALUES ('奎屯市',31);
INSERT INTO area(name, parent_id) VALUES ('库尔勒市',31);
INSERT INTO area(name, parent_id) VALUES ('昌吉市 ',31);
INSERT INTO area(name, parent_id) VALUES ('石河子市 ',31);
INSERT INTO area(name, parent_id) VALUES ('米泉市',31);
INSERT INTO area(name, parent_id) VALUES ('阜康市',31);
INSERT INTO area(name, parent_id) VALUES ('阿克苏市',31);
INSERT INTO area(name, parent_id) VALUES ('阿勒泰市',31);
INSERT INTO area(name, parent_id) VALUES ('阿图什市',31);
INSERT INTO area(name, parent_id) VALUES ('阿拉尔市',31);
INSERT INTO area(name, parent_id) VALUES ('呼和浩特市',32);
INSERT INTO area(name, parent_id) VALUES ('乌兰察布市',32);
INSERT INTO area(name, parent_id) VALUES ('乌海市',32);
INSERT INTO area(name, parent_id) VALUES ('兴安盟',32);
INSERT INTO area(name, parent_id) VALUES ('包头市',32);
INSERT INTO area(name, parent_id) VALUES ('呼伦贝尔市',32);
INSERT INTO area(name, parent_id) VALUES ('巴彦淖尔市',32);
INSERT INTO area(name, parent_id) VALUES ('赤峰市',32);
INSERT INTO area(name, parent_id) VALUES ('通辽市',32);
INSERT INTO area(name, parent_id) VALUES ('鄂尔多斯市',32);
INSERT INTO area(name, parent_id) VALUES ('锡林郭勒盟',32);
INSERT INTO area(name, parent_id) VALUES ('阿拉善盟',32);
INSERT INTO area(name, parent_id) VALUES ('澳门特别行政区',33);
INSERT INTO area(name, parent_id) VALUES ('香港特别行政区',34)

© 著作权归作者所有

共有 人打赏支持
hirainn
粉丝 32
博文 79
码字总数 57012
作品 0
深圳
程序员
ECharts 1.3.5 更新(地图大跃进,滚轮缩放,世界地图等)

【ECharts 1.3.5】发布 #ECharts地图大跃进# 升级支持滚轮缩放和拖拽漫游、内置世界地图、标准GeoJson动态扩展新地图类型、子区域模式实现从内置地图中扩展出全球176个国家地区和全国600多个...

Kener-林峰
2013/12/20
8K
22
阿里发布《2015-2016中国云栖创新报告》,北上杭深广排名前5

2016年1月20日,云栖大会・上海峰会于上海科技馆举办,在大会主论坛中,阿里研究院、阿里云及ITValue联合发布《2015-2016中国云栖创新报告》。 云计算成为普惠科技,数据驱动的创业变革已经发...

小云栖
2016/01/22
1K
0
页面字段存储数据库并且回显!!!新手求指导

1、现有一张地区表,存储省、市、区等信息。一张用户表存储用户信息,包括地址等字段。 2、页面使用三个下拉框联动显示省市区,现在想将省市区对应的id存进用户表的一个字段中。 3、使用aja...

lc1223
2016/07/11
123
1
基于jQuery+JSON的省市区三级地区联动

查看演示:http://www.helloweba.com/demo/cityselect/ 源码下载:http://files.cnblogs.com/files/huangcong/cityselect.rar 省市区联动下拉效果在WEB中应用非常广泛,尤其在一些会员信息系...

老朱教授
2017/10/01
0
0
redis 省市地区三级结构怎么设计

有几个网站都有用到省市地区三级结构 所以想把这数据存在redis中 方便调用 数据有 城市ID 城市名称 城市拼音 隶属省市ID 经常用到的功能 从 城市拼音 找出 隶属省市, 城市名,隶属它的市/地区...

匿名t3a
2012/02/23
2.8K
8

没有更多内容

加载失败,请刷新页面

加载更多

下一页

Linux下如何查看版本信息

Linux下如何查看版本信息, 包括位数、版本信息以及CPU内核信息、CPU具体型号等等,整个CPU信息一目了然。  1、# uname -a (Linux查看版本当前操作系统内核信息)   Linux localhost.l...

15834278076
28分钟前
0
0
单点登录 SSO 的实现原理

单点登录SSO(Single Sign On)说得简单点就是在一个多系统共存的环境下,用户在一处登录后,就不用在其他系统中登录,也就是用户的一次登录能得到其他所有系统的信任。 单点登录在大型网站里...

明理萝
28分钟前
1
1
虚拟机性能监控工具

前言 JVM调优流行这么一句话“无监控不调优”,因为如果没有监控,就不知道虚拟机的运行状况。更谈不上调优了,所以,学习和了解Java 虚拟机的监控工具很有必要。 概述 在Java虚拟机中经常用...

kukudeku
38分钟前
1
0
一行搞定electron和jquery冲突,electron和jquery最简单和完美的兼容方法

electron和jquery的常见报错: Uncaught ReferenceError: $ is not defined 解决方法:在jquery最末端加上这样一行判断即可. <script src="https://code.jquery.com/jquery-2.2.0.min.js"></s......

xiaogg
48分钟前
0
0
GC和内存管理

1、垃圾回收器需要关注的内容 ava运行时内存区域的各个部分中,程序计数器、虚拟机栈、本地方法栈这三个区域的生命周期和线程相关,栈中的栈帧随着方法的进入和退出执行着进栈和出栈,每一个...

京一
54分钟前
0
0

没有更多内容

加载失败,请刷新页面

加载更多

下一页

返回顶部
顶部