-- 表的结构 areaDROP TABLE area;CREATE TABLE area ( id int NOT NULL, areaID int NOT NULL, area varchar(200) NOT NULL, fatherID int NOT NULL, PRIMARY KEY (id)

)

DROP TABLE city;CREATE TABLE city select id int NOT NULL, cityID int NOT NULL, city varcharselect 200) NOT NULL, PRIMARY KEY select id))

---- 导出表中的数据 city--

-- --------------------------------------------------------

---- 表的结构 province--

DROP TABLE province;CREATE TABLE province select id int NOT NULL, provinceID int NOT NULL, province varcharselect 200) NOT NULL, PRIMARY KEY select id))

insert province(id,provinceID,province) select 1,110000,'北京市' unionselect 2,120000,'天津市' unionselect 3,130000,'河北省' unionselect 4,140000,'山西省' unionselect 5,150000,'内蒙古自治区'unionselect 6,210000,'辽宁省' unionselect 7,220000,'吉林省' unionselect 8,230000,'黑龙江省' unionselect 9,310000,'上海市' unionselect 10,320000,'江苏省' unionselect 11,330000,'浙江省' unionselect 12,340000,'安徽省' unionselect 13,350000,'福建省' unionselect 14,360000,'江西省' unionselect 15,370000,'山东省' unionselect 16,410000,'河南省' unionselect 17,420000,'湖北省' unionselect 18,430000,'湖南省' unionselect 19,440000,'广东省' unionselect 20,450000,'广西壮族自治区' unionselect 21,460000,'海南省' unionselect 22,500000,'重庆市' unionselect 23,510000,'四川省' unionselect 24,520000,'贵州省' unionselect 25,530000,'云南省' unionselect 26,540000,'西藏自治区' unionselect 27,610000,'陕西省' unionselect 28,620000,'甘肃省' unionselect 29,630000,'青海省' unionselect 30,640000,'宁夏回族自治区' unionselect 31,650000,'新疆维吾尔自治区' unionselect 32,710000,'台湾省' unionselect 33,810000,'香港特别行政区' unionselect 34,820000,'澳门特别行政区'

INSERT city (id,cityID,city,fatherID) select 1,110100,'市辖区',110000 unionselect 2,110200,'县',110000 unionselect 3,120100,120000 unionselect 4,120200,120000 unionselect 5,130100,'石家庄市',130000 unionselect 6,130200,'唐山市',130000 unionselect 7,130300,'秦皇岛市',130000 unionselect 8,130400,'邯郸市',130000 unionselect 9,130500,'邢台市',130000 unionselect 10,130600,'保定市',130000 unionselect 11,130700,'张家口市',130000 unionselect 12,130800,'承德市',130000 unionselect 13,130900,'沧州市',130000 unionselect 14,131000,'廊坊市',130000 unionselect 15,131100,'衡水市',130000 unionselect 16,140100,'太原市',140000 unionselect 17,140200,'大同市',140000 unionselect 18,140300,'阳泉市',140000 unionselect 19,140400,'长治市',140000 unionselect 20,140500,'晋城市',140000 unionselect 21,140600,'朔州市',140000 unionselect 22,140700,'晋中市',140000 unionselect 23,140800,'运城市',140000 unionselect 24,140900,'忻州市',140000 unionselect 25,141000,'临汾市',140000 unionselect 26,141100,'吕梁市',140000

INSERT city (id,fatherID) select 27,150100,'呼和浩特市',150000 unionselect 28,150200,'包头市',150000 unionselect 29,150300,'乌海市',150000 unionselect 30,150400,'赤峰市',150000 unionselect 31,150500,'通辽市',150000 unionselect 32,150600,'鄂尔多斯市',150000 unionselect 33,150700,'呼伦贝尔市',150000 unionselect 34,150800,'巴彦淖尔市',150000 unionselect 35,150900,'乌兰察布市',150000 unionselect 36,152200,'兴安盟',150000 unionselect 37,152500,'锡林郭勒盟',150000 unionselect 38,152900,'阿拉善盟',150000 unionselect 39,210100,'沈阳市',210000 unionselect 40,210200,'大连市',210000 unionselect 41,210300,'鞍山市',210000 unionselect 42,210400,'抚顺市',210000 unionselect 43,210500,'本溪市',210000 unionselect 44,210600,'丹东市',210000 unionselect 45,210700,'锦州市',210000 unionselect 46,210800,'营口市',210000 unionselect 47,210900,'阜新市',210000 unionselect 48,211000,'辽阳市',210000 unionselect 49,211100,'盘锦市',210000 unionselect 50,211200,'铁岭市',210000 unionselect 51,211300,'朝阳市',210000 unionselect 52,211400,'葫芦岛市',210000 unionselect 53,220100,'长春市',220000 unionselect 54,220200,'吉林市',220000 unionselect 55,220300,'四平市',220000 unionselect 56,220400,'辽源市',220000 unionselect 57,220500,'通化市',220000 unionselect 58,220600,'白山市',220000 unionselect 59,220700,'松原市',220000 unionselect 60,220800,'白城市',220000 unionselect 61,222400,'延边朝鲜族自治州',220000 unionselect 62,230100,'哈尔滨市',230000 unionselect 63,230200,'齐齐哈尔市',230000 unionselect 64,230300,'鸡西市',230000 unionselect 65,230400,'鹤岗市',230000 unionselect 66,230500,'双鸭山市',230000 unionselect 67,230600,'大庆市',230000 unionselect 68,230700,'伊春市',230000 unionselect 69,230800,'佳木斯市',230000 unionselect 70,230900,'七台河市',230000 unionselect 71,231000,'牡丹江市',230000 unionselect 72,231100,'黑河市',230000 unionselect 73,231200,'绥化市',230000 unionselect 74,232700,'大兴安岭地区',230000 unionselect 75,310100,310000 unionselect 76,310200,310000 unionselect 77,320100,'南京市',320000 unionselect 78,320200,'无锡市',320000 unionselect 79,320300,'徐州市',320000 unionselect 80,320400,'常州市',320000 unionselect 81,320500,'苏州市',320000 unionselect 82,320600,'南通市',320000 unionselect 83,320700,'连云港市',320000 unionselect 84,320800,'淮安市',320000 unionselect 85,320900,'盐城市',320000 unionselect 86,321000,'扬州市',320000 unionselect 87,321100,'镇江市',320000 unionselect 88,321200,'泰州市',320000 unionselect 89,321300,'宿迁市',320000 unionselect 90,330100,'杭州市',330000 unionselect 91,330200,'宁波市',330000 unionselect 92,330300,'温州市',330000 unionselect 93,330400,'嘉兴市',330000 unionselect 94,330500,'湖州市',330000 unionselect 95,330600,'绍兴市',330000 unionselect 96,330700,'金华市',330000 unionselect 97,330800,'衢州市',330000 unionselect 98,330900,'舟山市',330000 unionselect 99,331000,'台州市',330000 unionselect 100,331100,'丽水市',330000 unionselect 101,340100,'合肥市',340000 unionselect 102,340200,'芜湖市',340000 unionselect 103,340300,'蚌埠市',340000 unionselect 104,340400,'淮南市',340000 unionselect 105,340500,'马鞍山市',340000 unionselect 106,340600,'淮北市',340000 unionselect 107,340700,'铜陵市',340000 unionselect 108,340800,'安庆市',340000 unionselect 109,341000,'黄山市',340000 unionselect 110,341100,'滁州市',340000 unionselect 111,341200,'阜阳市',340000 unionselect 112,341300,'宿州市',340000 unionselect 113,341400,'巢湖市',340000 unionselect 114,341500,'六安市',340000 unionselect 115,341600,'亳州市',340000 unionselect 116,341700,'池州市',340000 unionselect 117,341800,'宣城市',340000 unionselect 118,350100,'福州市',350000 unionselect 119,350200,'厦门市',350000 unionselect 120,350300,'莆田市',350000 unionselect 121,350400,'三明市',350000 unionselect 122,350500,'泉州市',350000 unionselect 123,350600,'漳州市',350000 unionselect 124,350700,'南平市',350000 unionselect 125,350800,'龙岩市',350000 unionselect 126,350900,'宁德市',350000

INSERT city (id,fatherID) select 127,360100,'南昌市',360000 unionselect 128,360200,'景德镇市',360000 unionselect 129,360300,'萍乡市',360000 unionselect 130,360400,'九江市',360000 unionselect 131,360500,'新余市',360000 unionselect 132,360600,'鹰潭市',360000 unionselect 133,360700,'赣州市',360000 unionselect 134,360800,'吉安市',360000 unionselect 135,360900,'宜春市',360000 unionselect 136,361000,'抚州市',360000 unionselect 137,361100,'上饶市',360000 unionselect 138,370100,'济南市',370000 unionselect 139,370200,'青岛市',370000 unionselect 140,370300,'淄博市',370000 unionselect 141,370400,'枣庄市',370000 unionselect 142,370500,'东营市',370000 unionselect 143,370600,'烟台市',370000 unionselect 144,370700,'潍坊市',370000 unionselect 145,370800,'济宁市',370000 unionselect 146,370900,'泰安市',370000 unionselect 147,371000,'威海市',370000 unionselect 148,371100,'日照市',370000 unionselect 149,371200,'莱芜市',370000 unionselect 150,371300,'临沂市',370000 unionselect 151,371400,'德州市',370000 unionselect 152,371500,'聊城市',370000 unionselect 153,371600,'滨州市',370000 unionselect 154,371700,'荷泽市',370000 unionselect 155,410100,'郑州市',410000 unionselect 156,410200,'开封市',410000 unionselect 157,410300,'洛阳市',410000 unionselect 158,410400,'平顶山市',410000 unionselect 159,410500,'安阳市',410000 unionselect 160,410600,'鹤壁市',410000 unionselect 161,410700,'新乡市',410000 unionselect 162,410800,'焦作市',410000 unionselect 163,410900,'濮阳市',410000 unionselect 164,411000,'许昌市',410000 unionselect 165,411100,'漯河市',410000 unionselect 166,411200,'三门峡市',410000 unionselect 167,411300,'南阳市',410000 unionselect 168,411400,'商丘市',410000 unionselect 169,411500,'信阳市',410000 unionselect 170,411600,'周口市',410000 unionselect 171,411700,'驻马店市',410000

（编辑：安卓应用网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!