sql 数据库省市区 数据建表和数据.docx
《sql 数据库省市区 数据建表和数据.docx》由会员分享，可在线阅读，更多相关《sql 数据库省市区 数据建表和数据.docx（128页珍藏版）》请在冰豆网上搜索。
sql数据库省市区数据建表和数据
--表的结构area
DROPTABLEarea;
CREATETABLEarea（
idintNOTNULL,
areaIDintNOTNULL,
areavarchar（200）NOTNULL,
fatherIDintNOTNULL,
PRIMARYKEY（id）
）
DROPTABLEcity;
CREATETABLEcity（
idintNOTNULL,
cityIDintNOTNULL,
cityvarchar（200）NOTNULL,
fatherIDintNOTNULL,
PRIMARYKEY（id）
）
--
--导出表中的数据city
--
----------------------------------------------------------
--
--表的结构province
--
DROPTABLEprovince;
CREATETABLEprovince（
idintNOTNULL,
provinceIDintNOTNULL,
provincevarchar（200）NOTNULL,
PRIMARYKEY（id））
insertprovince（id,provinceID,province）
select1,110000,'北京市'union
select2,120000,'天津市'union
select3,130000,'河北省'union
select4,140000,'山西省'union
select5,150000,'内蒙古自治区'union
select6,210000,'辽宁省'union
select7,220000,'吉林省'union
select8,230000,'黑龙江省'union
select9,310000,'上海市'union
select10,320000,'江苏省'union
select11,330000,'浙江省'union
select12,340000,'安徽省'union
select13,350000,'福建省'union
select14,360000,'江西省'union
select15,370000,'山东省'union
select16,410000,'河南省'union
select17,420000,'湖北省'union
select18,430000,'湖南省'union
select19,440000,'广东省'union
select20,450000,'广西壮族自治区'union
select21,460000,'海南省'union
select22,500000,'重庆市'union
select23,510000,'四川省'union
select24,520000,'贵州省'union
select25,530000,'云南省'union
select26,540000,'西藏自治区'union
select27,610000,'陕西省'union
select28,620000,'甘肃省'union
select29,630000,'青海省'union
select30,640000,'宁夏回族自治区'union
select31,650000,'新疆维吾尔自治区'union
select32,710000,'台湾省'union
select33,810000,'香港特别行政区'union
select34,820000,'澳门特别行政区'
INSERTcity（id,cityID,city,fatherID）
select1,110100,'市辖区',110000union
select2,110200,'县',110000union
select3,120100,'市辖区',120000union
select4,120200,'县',120000union
select5,130100,'石家庄市',130000union
select6,130200,'唐山市',130000union
select7,130300,'秦皇岛市',130000union
select8,130400,'邯郸市',130000union
select9,130500,'邢台市',130000union
select10,130600,'保定市',130000union
select11,130700,'张家口市',130000union
select12,130800,'承德市',130000union
select13,130900,'沧州市',130000union
select14,131000,'廊坊市',130000union
select15,131100,'衡水市',130000union
select16,140100,'太原市',140000union
select17,140200,'大同市',140000union
select18,140300,'阳泉市',140000union
select19,140400,'长治市',140000union
select20,140500,'晋城市',140000union
select21,140600,'朔州市',140000union
select22,140700,'晋中市',140000union
select23,140800,'运城市',140000union
select24,140900,'忻州市',140000union
select25,141000,'临汾市',140000union
select26,141100,'吕梁市',140000
INSERTcity（id,cityID,city,fatherID）
select27,150100,'呼和浩特市',150000union
select28,150200,'包头市',150000union
select29,150300,'乌海市',150000union
select30,150400,'赤峰市',150000union
select31,150500,'通辽市',150000union
select32,150600,'鄂尔多斯市',150000union
select33,150700,'呼伦贝尔市',150000union
select34,150800,'巴彦淖尔市',150000union
select35,150900,'乌兰察布市',150000union
select36,152200,'兴安盟',150000union
select37,152500,'锡林郭勒盟',150000union
select38,152900,'阿拉善盟',150000union
select39,210100,'沈阳市',210000union
select40,210200,'大连市',210000union
select41,210300,'鞍山市',210000union
select42,210400,'抚顺市',210000union
select43,210500,'本溪市',210000union
select44,210600,'丹东市',210000union
select45,210700,'锦州市',210000union
select46,210800,'营口市',210000union
select47,210900,'阜新市',210000union
select48,211000,'辽阳市',210000union
select49,211100,'盘锦市',210000union
select50,211200,'铁岭市',210000union
select51,211300,'朝阳市',210000union
select52,211400,'葫芦岛市',210000union
select53,220100,'长春市',220000union
select54,220200,'吉林市',220000union
select55,220300,'四平市',220000union
select56,220400,'辽源市',220000union
select57,220500,'通化市',220000union
select58,220600,'白山市',220000union
select59,220700,'松原市',220000union
select60,220800,'白城市',220000union
select61,222400,'延边朝鲜族自治州',220000union
select62,230100,'哈尔滨市',230000union
select63,230200,'齐齐哈尔市',230000union
select64,230300,'鸡西市',230000union
select65,230400,'鹤岗市',230000union
select66,230500,'双鸭山市',230000union
select67,230600,'大庆市',230000union
select68,230700,'伊春市',230000union
select69,230800,'佳木斯市',230000union
select70,230900,'七台河市',230000union
select71,231000,'牡丹江市',230000union
select72,231100,'黑河市',230000union
select73,231200,'绥化市',230000union
select74,232700,'大兴安岭地区',230000union
select75,310100,'市辖区',310000union
select76,310200,'县',310000union
select77,320100,'南京市',320000union
select78,320200,'无锡市',320000union
select79,320300,'徐州市',320000union
select80,320400,'常州市',320000union
select81,320500,'苏州市',320000union
select82,320600,'南通市',320000union
select83,320700,'连云港市',320000union
select84,320800,'淮安市',320000union
select85,320900,'盐城市',320000union
select86,321000,'扬州市',320000union
select87,321100,'镇江市',320000union
select88,321200,'泰州市',320000union
select89,321300,'宿迁市',320000union
select90,330100,'杭州市',330000union
select91,330200,'宁波市',330000union
select92,330300,'温州市',330000union
select93,330400,'嘉兴市',330000union
select94,330500,'湖州市',330000union
select95,330600,'绍兴市',330000union
select96,330700,'金华市',330000union
select97,330800,'衢州市',330000union
select98,330900,'舟山市',330000union
select99,331000,'台州市',330000union
select100,331100,'丽水市',330000union
select101,340100,'合肥市',340000union
select102,340200,'芜湖市',340000union
select103,340300,'蚌埠市',340000union
select104,340400,'淮南市',340000union
select105,340500,'马鞍山市',340000union
select106,340600,'淮北市',340000union
select107,340700,'铜陵市',340000union
select108,340800,'安庆市',340000union
select109,341000,'黄山市',340000union
select110,341100,'滁州市',340000union
select111,341200,'阜阳市',340000union
select112,341300,'宿州市',340000union
select113,341400,'巢湖市',340000union
select114,341500,'六安市',340000union
select115,341600,'亳州市',340000union
select116,341700,'池州市',340000union
select117,341800,'宣城市',340000union
select118,350100,'福州市',350000union
select119,350200,'厦门市',350000union
select120,350300,'莆田市',350000union
select121,350400,'三明市',350000union
select122,350500,'泉州市',350000union
select123,350600,'漳州市',350000union
select124,350700,'南平市',350000union
select125,350800,'龙岩市',350000union
select126,350900,'宁德市',350000
INSERTcity（id,cityID,city,fatherID）
select127,360100,'南昌市',360000union
select128,360200,'景德镇市',360000union
select129,360300,'萍乡市',360000union
select130,360400,'九江市',360000union
select131,360500,'新余市',360000union
select132,360600,'鹰潭市',360000union
select133,360700,'赣州市',360000union
select134,360800,'吉安市',360000union
select135,360900,'宜春市',360000union
select136,361000,'抚州市',360000union
select137,361100,'上饶市',360000union
select138,370100,'济南市',370000union
select139,370200,'青岛市',370000union
select140,370300,'淄博市',370000union
select141,370400,'枣庄市',370000union
select142,370500,'东营市',370000union
select143,370600,'烟台市',370000union
select144,370700,'潍坊市',370000union
select145,370800,'济宁市',370000union
select146,370900,'泰安市',370000union
select147,371000,'威海市',370000union
select148,371100,'日照市',370000union
select149,371200,'莱芜市',370000union
select150,371300,'临沂市',370000union
select151,371400,'德州市',370000union
select152,371500,'聊城市',370000union
select153,371600,'滨州市',370000union
select154,371700,'荷泽市',370000union
select155,410100,'郑州市',410000union
select156,410200,'开封市',410000union
select157,410300,'洛阳市',410000union
select158,410400,'平顶山市',410000union
select159,410500,'安阳市',410000union
select160,410600,'鹤壁市',410000union
select161,410700,'新乡市',410000union
select162,410800,'焦作市',410000union
select163,410900,'濮阳市',410000union
select164,411000,'许昌市',410000union
select165,411100,'漯河市',410000union
select166,411200,'三门峡市',410000union
select167,411300,'南阳市',410000union
select168,411400,'商丘市',410000union
select169,411500,'信阳市',410000union
select170,411600,'周口市',410000union
select171,411700,'驻马店市',410000
INSERTcity（id,cityID,city,fatherID）
select172,420100,'武汉市',420000union
select173,420200,'黄石市',420000union
select174,420300,'十堰市',420000union
select175,420500,'宜昌市',420000union
select176,420600,'襄樊市',420000union
select177,420700,'鄂州市',420000union
select178,420800,'荆门市',420000union
select179,420900,'孝感市',420000union
select180,421000,'荆州市',420000union
select181,421100,'黄冈市',420000union
select182,421200,'咸宁市',420000union
select183,421300,'随州市',420000union
select184,422800,'恩施土家族苗族自治州',420000union
select185,429000,'省直辖行政单位',420000union
select186,430100,'长沙市',430000union
select187,430200,'株洲市',430000union
select188,430300,'湘潭市',430000union
select189,430400,'衡阳市',430000union
select190,430500,'邵阳市',430000union
select191,430600,'岳阳市',430000union
select192,430700,'常德市',430000union
select193,430800,'张家界市',430000union
select194,430900,'益阳市',430000union
select195,431000,'郴州市',430000union
select196,431100,'永州市',430000union
select197,431200,'怀化市',430000union
select198,431300,'娄底市',430000union
select199,433100,'湘西土家族苗族自治州',430000union
select200,440100,'广州市',440000union
select201,440200,'韶关市',440000union
select202,440300,'深圳市',440000union
select203,440400,'珠海市',440000union
select204,440500,'汕头市',440000union
select205,440600,'佛山市',440000union
select206,440700,'江门市',440000union
select207,440800,'湛江市',440000union
select208,440900,'茂名市',440000union
select209,441200,'肇庆市',440000union
select210,441300,'惠州市',440000union
select211,441400,'梅州市',440000union
select212,441500,'汕尾市',440000union
select213,441600,'河源市',440000union
select214,441700,'阳江市',440000union
select215,441800,'清远市',440000union
select216,441900,'东莞市',440000
升级会员 