本文来源：中国省份与城市数据插入 - xlx - CSDN博客 在Google找到这个，实在是爱不释手，就转过来了，很多项目都需要用到这些数据。 if exists (select * from sysobjects where id = OBJECT_ID('[province]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [province] CREATE TABLE [province] ( [id] [int] NOT NULL, [provinceID] [nvarchar] (12) NOT NULL, [province] [nvarchar] (80) NOT NULL) ALTER TABLE [province] WITH NOCHECK ADD CONSTRAINT [PK_province] PRIMARY KEY NONCLUSTERED ( [id] )INSERT [province] ([id],[provinceID],[province]) VALUES ( 1,'110000','北京市') INSERT [province] ([id],[provinceID],[province]) VALUES ( 2,'120000','天津市') INSERT [province] ([id],[provinceID],[province]) VALUES ( 3,'130000','河北省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 4,'140000','山西省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 5,'150000','内蒙古自治区') INSERT [province] ([id],[provinceID],[province]) VALUES ( 6,'210000','辽宁省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 7,'220000','吉林省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 8,'230000','黑龙江省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 9,'310000','上海市') INSERT [province] ([id],[provinceID],[province]) VALUES ( 10,'320000','江苏省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 11,'330000','浙江省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 12,'340000','安徽省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 13,'350000','福建省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 14,'360000','江西省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 15,'370000','山东省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 16,'410000','河南省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 17,'420000','湖北省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 18,'430000','湖南省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 19,'440000','广东省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 20,'450000','广西壮族自治区') INSERT [province] ([id],[provinceID],[province]) VALUES ( 21,'460000','海南省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 22,'500000','重庆市') INSERT [province] ([id],[provinceID],[province]) VALUES ( 23,'510000','四川省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 24,'520000','贵州省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 25,'530000','云南省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 26,'540000','西藏自治区') INSERT [province] ([id],[provinceID],[province]) VALUES ( 27,'610000','陕西省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 28,'620000','甘肃省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 29,'630000','青海省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 30,'640000','宁夏回族自治区') INSERT [province] ([id],[provinceID],[province]) VALUES ( 31,'650000','新疆维吾尔自治区') INSERT [province] ([id],[provinceID],[province]) VALUES ( 32,'710000','台湾省') INSERT [province] ([id],[provinceID],[province]) VALUES ( 33,'810000','香港特别行政区') INSERT [province] ([id],[provinceID],[province]) VALUES ( 34,'820000','澳门特别行政区') if exists (select * from sysobjects where id = OBJECT_ID('[area]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [area] CREATE TABLE [area] ( [id] [int] NOT NULL, [cityID] [nvarchar] (12) NOT NULL, [city] [nvarchar] (100) NOT NULL, [father] [nvarchar] (12) NOT NULL) ALTER TABLE [area] WITH NOCHECK ADD CONSTRAINT [PK_area] PRIMARY KEY NONCLUSTERED ( [id] )INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 1,'110100','市辖区','110000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 2,'110200','县','110000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 3,'120100','市辖区','120000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 4,'120200','县','120000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 5,'130100','石家庄市','130000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 6,'130200','唐山市','130000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 7,'130300','秦皇岛市','130000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 8,'130400','邯郸市','130000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 9,'130500','邢台市','130000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 10,'130600','保定市','130000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 11,'130700','张家口市','130000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 12,'130800','承德市','130000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 13,'130900','沧州市','130000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 14,'131000','廊坊市','130000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 15,'131100','衡水市','130000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 16,'140100','太原市','140000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 17,'140200','大同市','140000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 18,'140300','阳泉市','140000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 19,'140400','长治市','140000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 20,'140500','晋城市','140000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 21,'140600','朔州市','140000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 22,'140700','晋中市','140000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 23,'140800','运城市','140000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 24,'140900','忻州市','140000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 25,'141000','临汾市','140000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 26,'141100','吕梁市','140000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 27,'150100','呼和浩特市','150000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 28,'150200','包头市','150000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 29,'150300','乌海市','150000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 30,'150400','赤峰市','150000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 31,'150500','通辽市','150000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 32,'150600','鄂尔多斯市','150000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 33,'150700','呼伦贝尔市','150000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 34,'150800','巴彦淖尔市','150000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 35,'150900','乌兰察布市','150000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 36,'152200','兴安盟','150000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 37,'152500','锡林郭勒盟','150000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 38,'152900','阿拉善盟','150000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 39,'210100','沈阳市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 40,'210200','大连市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 41,'210300','鞍山市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 42,'210400','抚顺市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 43,'210500','本溪市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 44,'210600','丹东市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 45,'210700','锦州市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 46,'210800','营口市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 47,'210900','阜新市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 48,'211000','辽阳市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 49,'211100','盘锦市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 50,'211200','铁岭市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 51,'211300','朝阳市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 52,'211400','葫芦岛市','210000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 53,'220100','长春市','220000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 54,'220200','吉林市','220000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 55,'220300','四平市','220000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 56,'220400','辽源市','220000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 57,'220500','通化市','220000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 58,'220600','白山市','220000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 59,'220700','松原市','220000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 60,'220800','白城市','220000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 61,'222400','延边朝鲜族自治州','220000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 62,'230100','哈尔滨市','230000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 63,'230200','齐齐哈尔市','230000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 64,'230300','鸡西市','230000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 65,'230400','鹤岗市','230000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 66,'230500','双鸭山市','230000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 67,'230600','大庆市','230000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 68,'230700','伊春市','230000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 69,'230800','佳木斯市','230000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 70,'230900','七台河市','230000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 71,'231000','牡丹江市','230000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 72,'231100','黑河市','230000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 73,'231200','绥化市','230000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 74,'232700','大兴安岭地区','230000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 75,'310100','市辖区','310000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 76,'310200','县','310000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 77,'320100','南京市','320000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 78,'320200','无锡市','320000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 79,'320300','徐州市','320000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 80,'320400','常州市','320000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 81,'320500','苏州市','320000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 82,'320600','南通市','320000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 83,'320700','连云港市','320000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 84,'320800','淮安市','320000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 85,'320900','盐城市','320000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 86,'321000','扬州市','320000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 87,'321100','镇江市','320000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 88,'321200','泰州市','320000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 89,'321300','宿迁市','320000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 90,'330100','杭州市','330000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 91,'330200','宁波市','330000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 92,'330300','温州市','330000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 93,'330400','嘉兴市','330000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 94,'330500','湖州市','330000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 95,'330600','绍兴市','330000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 96,'330700','金华市','330000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 97,'330800','衢州市','330000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 98,'330900','舟山市','330000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 99,'331000','台州市','330000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 100,'331100','丽水市','330000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 101,'340100','合肥市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 102,'340200','芜湖市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 103,'340300','蚌埠市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 104,'340400','淮南市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 105,'340500','马鞍山市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 106,'340600','淮北市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 107,'340700','铜陵市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 108,'340800','安庆市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 109,'341000','黄山市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 110,'341100','滁州市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 111,'341200','阜阳市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 112,'341300','宿州市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 113,'341400','巢湖市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 114,'341500','六安市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 115,'341600','亳州市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 116,'341700','池州市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 117,'341800','宣城市','340000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 118,'350100','福州市','350000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 119,'350200','厦门市','350000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 120,'350300','莆田市','350000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 121,'350400','三明市','350000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 122,'350500','泉州市','350000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 123,'350600','漳州市','350000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 124,'350700','南平市','350000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 125,'350800','龙岩市','350000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 126,'350900','宁德市','350000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 127,'360100','南昌市','360000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 128,'360200','景德镇市','360000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 129,'360300','萍乡市','360000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 130,'360400','九江市','360000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 131,'360500','新余市','360000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 132,'360600','鹰潭市','360000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 133,'360700','赣州市','360000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 134,'360800','吉安市','360000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 135,'360900','宜春市','360000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 136,'361000','抚州市','360000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 137,'361100','上饶市','360000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 138,'370100','济南市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 139,'370200','青岛市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 140,'370300','淄博市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 141,'370400','枣庄市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 142,'370500','东营市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 143,'370600','烟台市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 144,'370700','潍坊市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 145,'370800','济宁市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 146,'370900','泰安市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 147,'371000','威海市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 148,'371100','日照市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 149,'371200','莱芜市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 150,'371300','临沂市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 151,'371400','德州市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 152,'371500','聊城市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 153,'371600','滨州市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 154,'371700','荷泽市','370000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 155,'410100','郑州市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 156,'410200','开封市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 157,'410300','洛阳市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 158,'410400','平顶山市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 159,'410500','安阳市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 160,'410600','鹤壁市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 161,'410700','新乡市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 162,'410800','焦作市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 163,'410900','濮阳市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 164,'411000','许昌市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 165,'411100','漯河市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 166,'411200','三门峡市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 167,'411300','南阳市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 168,'411400','商丘市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 169,'411500','信阳市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 170,'411600','周口市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 171,'411700','驻马店市','410000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 172,'420100','武汉市','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 173,'420200','黄石市','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 174,'420300','十堰市','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 175,'420500','宜昌市','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 176,'420600','襄樊市','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 177,'420700','鄂州市','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 178,'420800','荆门市','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 179,'420900','孝感市','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 180,'421000','荆州市','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 181,'421100','黄冈市','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 182,'421200','咸宁市','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 183,'421300','随州市','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 184,'422800','恩施土家族苗族自治州','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 185,'429000','省直辖行政单位','420000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 186,'430100','长沙市','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 187,'430200','株洲市','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 188,'430300','湘潭市','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 189,'430400','衡阳市','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 190,'430500','邵阳市','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 191,'430600','岳阳市','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 192,'430700','常德市','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 193,'430800','张家界市','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 194,'430900','益阳市','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 195,'431000','郴州市','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 196,'431100','永州市','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 197,'431200','怀化市','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 198,'431300','娄底市','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 199,'433100','湘西土家族苗族自治州','430000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 200,'440100','广州市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 201,'440200','韶关市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 202,'440300','深圳市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 203,'440400','珠海市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 204,'440500','汕头市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 205,'440600','佛山市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 206,'440700','江门市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 207,'440800','湛江市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 208,'440900','茂名市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 209,'441200','肇庆市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 210,'441300','惠州市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 211,'441400','梅州市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 212,'441500','汕尾市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 213,'441600','河源市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 214,'441700','阳江市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 215,'441800','清远市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 216,'441900','东莞市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 217,'442000','中山市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 218,'445100','潮州市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 219,'445200','揭阳市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 220,'445300','云浮市','440000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 221,'450100','南宁市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 222,'450200','柳州市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 223,'450300','桂林市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 224,'450400','梧州市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 225,'450500','北海市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 226,'450600','防城港市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 227,'450700','钦州市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 228,'450800','贵港市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 229,'450900','玉林市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 230,'451000','百色市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 231,'451100','贺州市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 232,'451200','河池市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 233,'451300','来宾市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 234,'451400','崇左市','450000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 235,'460100','海口市','460000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 236,'460200','三亚市','460000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 237,'469000','省直辖县级行政单位','460000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 238,'500100','市辖区','500000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 239,'500200','县','500000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 240,'500300','市','500000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 241,'510100','成都市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 242,'510300','自贡市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 243,'510400','攀枝花市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 244,'510500','泸州市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 245,'510600','德阳市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 246,'510700','绵阳市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 247,'510800','广元市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 248,'510900','遂宁市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 249,'511000','内江市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 250,'511100','乐山市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 251,'511300','南充市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 252,'511400','眉山市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 253,'511500','宜宾市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 254,'511600','广安市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 255,'511700','达州市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 256,'511800','雅安市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 257,'511900','巴中市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 258,'512000','资阳市','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 259,'513200','阿坝藏族羌族自治州','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 260,'513300','甘孜藏族自治州','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 261,'513400','凉山彝族自治州','510000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 262,'520100','贵阳市','520000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 263,'520200','六盘水市','520000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 264,'520300','遵义市','520000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 265,'520400','安顺市','520000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 266,'522200','铜仁地区','520000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 267,'522300','黔西南布依族苗族自治州','520000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 268,'522400','毕节地区','520000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 269,'522600','黔东南苗族侗族自治州','520000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 270,'522700','黔南布依族苗族自治州','520000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 271,'530100','昆明市','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 272,'530300','曲靖市','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 273,'530400','玉溪市','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 274,'530500','保山市','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 275,'530600','昭通市','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 276,'530700','丽江市','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 277,'530800','思茅市','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 278,'530900','临沧市','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 279,'532300','楚雄彝族自治州','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 280,'532500','红河哈尼族彝族自治州','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 281,'532600','文山壮族苗族自治州','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 282,'532800','西双版纳傣族自治州','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 283,'532900','大理白族自治州','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 284,'533100','德宏傣族景颇族自治州','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 285,'533300','怒江傈僳族自治州','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 286,'533400','迪庆藏族自治州','530000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 287,'540100','拉萨市','540000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 288,'542100','昌都地区','540000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 289,'542200','山南地区','540000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 290,'542300','日喀则地区','540000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 291,'542400','那曲地区','540000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 292,'542500','阿里地区','540000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 293,'542600','林芝地区','540000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 294,'610100','西安市','610000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 295,'610200','铜川市','610000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 296,'610300','宝鸡市','610000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 297,'610400','咸阳市','610000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 298,'610500','渭南市','610000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 299,'610600','延安市','610000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 300,'610700','汉中市','610000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 301,'610800','榆林市','610000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 302,'610900','安康市','610000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 303,'611000','商洛市','610000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 304,'620100','兰州市','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 305,'620200','嘉峪关市','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 306,'620300','金昌市','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 307,'620400','白银市','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 308,'620500','天水市','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 309,'620600','武威市','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 310,'620700','张掖市','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 311,'620800','平凉市','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 312,'620900','酒泉市','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 313,'621000','庆阳市','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 314,'621100','定西市','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 315,'621200','陇南市','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 316,'622900','临夏回族自治州','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 317,'623000','甘南藏族自治州','620000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 318,'630100','西宁市','630000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 319,'632100','海东地区','630000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 320,'632200','海北藏族自治州','630000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 321,'632300','黄南藏族自治州','630000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 322,'632500','海南藏族自治州','630000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 323,'632600','果洛藏族自治州','630000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 324,'632700','玉树藏族自治州','630000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 325,'632800','海西蒙古族藏族自治州','630000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 326,'640100','银川市','640000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 327,'640200','石嘴山市','640000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 328,'640300','吴忠市','640000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 329,'640400','固原市','640000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 330,'640500','中卫市','640000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 331,'650100','乌鲁木齐市','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 332,'650200','克拉玛依市','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 333,'652100','吐鲁番地区','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 334,'652200','哈密地区','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 335,'652300','昌吉回族自治州','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 336,'652700','博尔塔拉蒙古自治州','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 337,'652800','巴音郭楞蒙古自治州','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 338,'652900','阿克苏地区','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 339,'653000','克孜勒苏柯尔克孜自治州','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 340,'653100','喀什地区','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 341,'653200','和田地区','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 342,'654000','伊犁哈萨克自治州','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 343,'654200','塔城地区','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 344,'654300','阿勒泰地区','650000') INSERT [area] ([id],[cityID],[city],[father]) VALUES ( 345,'659000','省直辖行政单位','650000')

上图，啥也不说了 泪奔啊，考了四级，这次大爆发，把四级绝杀了~~~ 话说上半年真顺，考啥过啥。下面考虑驾照或者日语，二选一了

我是五月份从百度空间转过来的《爷爷的一亩三分地》，之后那个空间就停止了维护，但是还有几个好友坚守在 百度空间，我还是会经常去后台看看好友的新文章。 刚去百度空间的管理空间看好友动态，无意中发现百度居然有了几个应用 荣光医院、开心宝贝、德克萨斯扑克、小游戏、狗狗、测试、礼物 这些典型的SNS小应用。 之前的百度Hi空间只有一个简单的宠物应用，现在推出了这么多应用，加上以前推出对好友的日志回复功能，百度空间明显有转向SNS形式的趋势。 只不过这种转型速度很慢，可以看出百度高层并不是很重视百度空间发展，百度空间的文章在内容和形式上都明显质量不如一些其他博客系统，而且比较依赖百度搜索功能。我感 觉百度空间无论怎么转型都难以撼动校内和开心网的地位。 ...

这两天没有写日志，白天挺忙，晚上也忙，打真三变态版~~ 白天在公司天天写文档，从概要设计写到详细设计，公司用的是CMMIL3开发过程，大大小小文档挺多。我没事就捧着个PetShop研究半天，然后再在[豆丁网](h ttp://www.docin.com/)搜索CMMI文档。 这个项目居然交给了我们三个实习生~~纠结了~~~ 没劲，CMMI那一套我还完全没有看过，就上马写文档，这种文档显得没有什么意义。 终于体会到之前老师说的项目开发的猫腻，我总结为「中国式开发」~~~ ...

iGoogle大家可能都知道，是Google提供的一个定制度很高的Google界面，我习惯于再上面直接使用GoogleReader和其他一些Google提供 的Wiggett。 G.cn和Google.com都提供iGoogle服务，但是很显然，我们不欢迎G.cn这个阉割版的iGoogle，Google.com提供了大量好玩有用的小 工具，也能集成一些Google提供的服务如WebMaster, Chat等等。 ...

原文链接：《wordpress关键字自动链接匹配插件 | 长沙SEO特色高端咨询顾问服务》 相关链接：《wordpress插件 中文关键词自动连接 | Muboard》（这位博主曾为该插件0.3x版本做过中文优化） 中文版下载地址：猛击这里下载 wordpress关键字自动匹配链接插件 这个工具非常好使，我找了很久了，以后发文章就省事多了，不用一个一个去加链接了，呵呵，So Cool！ 下面引用原文： Wordpress Keyword Link Plugin This is a little Wordpress 2.3+ plugin that helps you to automatically link defined keywords to certain articles on your own blog, or elsewhere on the internet. A plugin that allows you to define keyword/link pairs. The keywords are automatically linked in each of your posts. This is usefull for improving the internal cross referencing pages inside your site or to automatically link to external partners (SEO). ...

买了空间后，就一直使用iNove主题，虽然iNove这个主题很优秀，但时间长了，难免有些审美疲劳。我一直想换一个主题，但苦于喜欢的主题要么没有汉化，要么在I E6下不兼容，要么就是色调、字体大小不符合我的要求。 我喜欢大气，亲切一点的主题，比如说Fusion，我也花了几天时间汉化了Fusion的主题，可惜最后关节，发现Fusion在IE6下显示不正常，我又没有勇气抛 弃IE6的用户，只能作罢。国内毕竟过半的人仍然在XP/IE6这个平台下，真无奈。 ...

今天总监给我配了一台电脑，是HP的服务器，志强的X3210处理器。这样以后再也不用背着电脑翻墙了~ 在这台服务器里发现了Visual Studio 2008 Team System，这好东西啊，不用自己下，我赶紧找移动硬盘来考它。 试了好一会，Windows Server 2003都没有认出这个移动硬盘，显示正确的，就是不出现盘符。我一度认为自己的移动硬盘又出了事情，最好发现原来是Windows Server 2003使用移动硬盘盒Linux一样，需要加载一下。 相关链接《[解决windows server 2003不认U盘或移动硬盘_蓝色天空](http://hi.baidu.com/cheng_allen/blo g/item/5a46d307004a05c97a894746.html)》 ...

7月底回到学校，当时徐州整天阴天，查查天气预报，说是零星小雨，吓得我不敢晒被子，就盖着裹了一个月的被子褥子将就着睡。 结果可好，我为此付出了一个多星期的惨痛代价。 起初是身上起肿块，红色的，痒痒的，特别是右腿部位，我以为是蚊子叮咬，一边咒骂的徐州的蚊子，一边喷着花露水。宿舍小白还要嘲笑我RP差，说蚊子只咬坏人。 现在想来，我宁愿是被蚊子咬了。 几天之后，情况越发严重，身上的小疙瘩如雨后春笋般的冒出（原谅我使用了这个成语）。我意识到情况不对：虽然我的肉也被称为「烂肉」，也不至于被叮的这么厉害吧，何况 我蚊帐扎的那么严实。 ...

曾经说过国内几大SNS网络，校内和开心做的最好，但校内的硬伤在于它的名字，我一学生走向社会，肯定不是校园用户了，那么开心网就是我最好的选择了。 今天登陆校内时候，发现一个通知，校内更名为人人，下面是文字介绍。 新品牌的含义 新品牌标志由两个抽象的人字变形，人字成圈形寓意每个人的人际圈，同时两个人字中间发生交集，寓意人与人的沟通和交流，中间的红色象征着人与人之间的情感。文字部分拼 音renren，同时也是网址renren.com。由图形和域名共同组合成的新标志，象征着renren.com是一个人与人的沟通分享平台，分享真实、沟通快乐。 ...