中国省市二级地区表
博客专区 > hirainn 的博客 > 博客详情
中国省市二级地区表
hirainn 发表于9个月前
中国省市二级地区表
  • 发表于 9个月前
  • 阅读 34
  • 收藏 0
  • 点赞 0
  • 评论 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)
标签: 地区表 省市表
  • 打赏
  • 点赞
  • 收藏
  • 分享
共有 人打赏支持
粉丝 32
博文 66
码字总数 42016
×
hirainn
如果觉得我的文章对您有用,请随意打赏。您的支持将鼓励我继续创作!
* 金额(元)
¥1 ¥5 ¥10 ¥20 其他金额
打赏人
留言
* 支付类型
微信扫码支付
打赏金额:
已支付成功
打赏金额: