2010-08-18
省份
create table tb_province
(
id int primary key,
name nvarchar(50)
)
insert into tb_province (id,name) values (1,'北京市')
insert into tb_province (id,name) values (2,'天津市')
insert into tb_province (id,name) values (3,'河北省')
insert into tb_province (id,name) values (4,'山西省')
insert into tb_province (id,name) values (5,'内蒙古自治区')
insert into tb_province (id,name) values (6,'辽宁省')
insert into tb_province (id,name) values (7,'吉林省')
insert into tb_province (id,name) values (8,'黑龙江省')
insert into tb_province (id,name) values (9,'上海市')
insert into tb_province (id,name) values (10,'江苏省')
insert into tb_province (id,name) values (11,'浙江省')
insert into tb_province (id,name) values (12,'安徽省')
insert into tb_province (id,name) values (13,'福建省')
insert into tb_province (id,name) values (14,'江西省')
insert into tb_province (id,name) values (15,'山东省')
insert into tb_province (id,name) values (16,'河南省')
insert into tb_province (id,name) values (17,'湖北省')
insert into tb_province (id,name) values (18,'湖南省')
insert into tb_province (id,name) values (19,'广东省')
insert into tb_province (id,name) values (20,'广西壮族自治区')
insert into tb_province (id,name) values (21,'海南省')
insert into tb_province (id,name) values (22,'重庆市')
insert into tb_province (id,name) values (23,'四川省')
insert into tb_province (id,name) values (24,'贵州省')
insert into tb_province (id,name) values (25,'云南省')
insert into tb_province (id,name) values (26,'西藏自治区')
insert into tb_province (id,name) values (27,'陕西省')
insert into tb_province (id,name) values (28,'甘肃省')
insert into tb_province (id,name) values (29,'青海省')
insert into tb_province (id,name) values (30,'宁夏回族自治区')
insert into tb_province (id,name) values (31,'新疆维吾尔自治区')
insert into tb_province (id,name) values (32,'香港特别行政区')
insert into tb_province (id,name) values (33,'澳门特别行政区')
insert into tb_province (id,name) values (34,'台湾省')
select * from tb_province
城市
create table tb_city
(
id int primary key,
name nvarchar(50),
provinceid int
)
insert into tb_city (id,name,provinceid) values (1,'北京市',1)
insert into tb_city (id,name,provinceid) values (2,'天津市',2)
insert into tb_city (id,name,provinceid) values (3,'石家庄市',3)
insert into tb_city (id,name,provinceid) values (4,'唐山市',3)
insert into tb_city (id,name,provinceid) values (5,'秦皇岛市',3)
insert into tb_city (id,name,provinceid) values (6,'邯郸市',3)
insert into tb_city (id,name,provinceid) values (7,'邢台市',3)
insert into tb_city (id,name,provinceid) values (8,'保定市',3)
insert into tb_city (id,name,provinceid) values (9,'张家口市',3)
insert into tb_city (id,name,provinceid) values (10,'承德市',3)
insert into tb_city (id,name,provinceid) values (11,'沧州市',3)
insert into tb_city (id,name,provinceid) values (12,'廊坊市',3)
insert into tb_city (id,name,provinceid) values (13,'衡水市',3)
insert into tb_city (id,name,provinceid) values (14,'太原市',4)
insert into tb_city (id,name,provinceid) values (15,'大同市',4)
insert into tb_city (id,name,provinceid) values (16,'阳泉市',4)
insert into tb_city (id,name,provinceid) values (17,'长治市',4)
insert into tb_city (id,name,provinceid) values (18,'晋城市',4)
insert into tb_city (id,name,provinceid) values (19,'朔州市',4)
insert into tb_city (id,name,provinceid) values (20,'晋中市',4)
insert into tb_city (id,name,provinceid) values (21,'运城市',4)
insert into tb_city (id,name,provinceid) values (22,'忻州市',4)
insert into tb_city (id,name,provinceid) values (23,'临汾市',4)
insert into tb_city (id,name,provinceid) values (24,'吕梁市',4)
insert into tb_city (id,name,provinceid) values (25,'呼和浩特市',5)
insert into tb_city (id,name,provinceid) values (26,'包头市',5)
insert into tb_city (id,name,provinceid) values (27,'乌海市',5)
insert into tb_city (id,name,provinceid) values (28,'赤峰市',5)
insert into tb_city (id,name,provinceid) values (29,'通辽市',5)
insert into tb_city (id,name,provinceid) values (30,'鄂尔多斯市',5)
insert into tb_city (id,name,provinceid) values (31,'呼伦贝尔市',5)
insert into tb_city (id,name,provinceid) values (32,'巴彦淖尔市',5)
insert into tb_city (id,name,provinceid) values (33,'乌兰察布市',5)
insert into tb_city (id,name,provinceid) values (34,'兴安盟',5)
insert into tb_city (id,name,provinceid) values (35,'锡林郭勒盟',5)
insert into tb_city (id,name,provinceid) values (36,'阿拉善盟',5)
insert into tb_city (id,name,provinceid) values (37,'沈阳市',6)
insert into tb_city (id,name,provinceid) values (38,'大连市',6)
insert into tb_city (id,name,provinceid) values (39,'鞍山市',6)
insert into tb_city (id,name,provinceid) values (40,'抚顺市',6)
insert into tb_city (id,name,provinceid) values (41,'本溪市',6)
insert into tb_city (id,name,provinceid) values (42,'丹东市',6)
insert into tb_city (id,name,provinceid) values (43,'锦州市',6)
insert into tb_city (id,name,provinceid) values (44,'营口市',6)
insert into tb_city (id,name,provinceid) values (45,'阜新市',6)
insert into tb_city (id,name,provinceid) values (46,'辽阳市',6)
insert into tb_city (id,name,provinceid) values (47,'盘锦市',6)
insert into tb_city (id,name,provinceid) values (48,'铁岭市',6)
insert into tb_city (id,name,provinceid) values (49,'朝阳市',6)
insert into tb_city (id,name,provinceid) values (50,'葫芦岛市',6)
insert into tb_city (id,name,provinceid) values (51,'长春市',7)
insert into tb_city (id,name,provinceid) values (52,'吉林市',7)
insert into tb_city (id,name,provinceid) values (53,'四平市',7)
insert into tb_city (id,name,provinceid) values (54,'辽源市',7)
insert into tb_city (id,name,provinceid) values (55,'通化市',7)
insert into tb_city (id,name,provinceid) values (56,'白山市',7)
insert into tb_city (id,name,provinceid) values (57,'松原市',7)
insert into tb_city (id,name,provinceid) values (58,'白城市',7)
insert into tb_city (id,name,provinceid) values (59,'延边朝鲜族自治州',7)
insert into tb_city (id,name,provinceid) values (60,'哈尔滨市',8)
insert into tb_city (id,name,provinceid) values (61,'齐齐哈尔市',8)
insert into tb_city (id,name,provinceid) values (62,'鸡西市',8)
insert into tb_city (id,name,provinceid) values (63,'鹤岗市',8)
insert into tb_city (id,name,provinceid) values (64,'双鸭山市',8)
insert into tb_city (id,name,provinceid) values (65,'大庆市',8)
insert into tb_city (id,name,provinceid) values (66,'伊春市',8)
insert into tb_city (id,name,provinceid) values (67,'佳木斯市',8)
insert into tb_city (id,name,provinceid) values (68,'七台河市',8)
insert into tb_city (id,name,provinceid) values (69,'牡丹江市',8)
insert into tb_city (id,name,provinceid) values (70,'黑河市',8)
insert into tb_city (id,name,provinceid) values (71,'绥化市',8)
insert into tb_city (id,name,provinceid) values (72,'大兴安岭地区',8)
insert into tb_city (id,name,provinceid) values (73,'上海市',9)
insert into tb_city (id,name,provinceid) values (74,'南京市',10)
insert into tb_city (id,name,provinceid) values (75,'无锡市',10)
insert into tb_city (id,name,provinceid) values (76,'徐州市',10)
insert into tb_city (id,name,provinceid) values (77,'常州市',10)
insert into tb_city (id,name,provinceid) values (78,'苏州市',10)
insert into tb_city (id,name,provinceid) values (79,'南通市',10)
insert into tb_city (id,name,provinceid) values (80,'连云港市',10)
insert into tb_city (id,name,provinceid) values (81,'淮安市',10)
insert into tb_city (id,name,provinceid) values (82,'盐城市',10)
insert into tb_city (id,name,provinceid) values (83,'扬州市',10)
insert into tb_city (id,name,provinceid) values (84,'镇江市',10)
insert into tb_city (id,name,provinceid) values (85,'泰州市',10)
insert into tb_city (id,name,provinceid) values (86,'宿迁市',10)
insert into tb_city (id,name,provinceid) values (87,'杭州市',11)
insert into tb_city (id,name,provinceid) values (88,'宁波市',11)
insert into tb_city (id,name,provinceid) values (89,'温州市',11)
insert into tb_city (id,name,provinceid) values (90,'嘉兴市',11)
insert into tb_city (id,name,provinceid) values (91,'湖州市',11)
insert into tb_city (id,name,provinceid) values (92,'绍兴市',11)
insert into tb_city (id,name,provinceid) values (93,'金华市',11)
insert into tb_city (id,name,provinceid) values (94,'衢州市',11)
insert into tb_city (id,name,provinceid) values (95,'舟山市',11)
insert into tb_city (id,name,provinceid) values (96,'台州市',11)
insert into tb_city (id,name,provinceid) values (97,'丽水市',11)
insert into tb_city (id,name,provinceid) values (98,'合肥市',12)
insert into tb_city (id,name,provinceid) values (99,'芜湖市',12)
insert into tb_city (id,name,provinceid) values (100,'蚌埠市',12)
insert into tb_city (id,name,provinceid) values (101,'淮南市',12)
insert into tb_city (id,name,provinceid) values (102,'马鞍山市',12)
insert into tb_city (id,name,provinceid) values (103,'淮北市',12)
insert into tb_city (id,name,provinceid) values (104,'铜陵市',12)
insert into tb_city (id,name,provinceid) values (105,'安庆市',12)
insert into tb_city (id,name,provinceid) values (106,'黄山市',12)
insert into tb_city (id,name,provinceid) values (107,'滁州市',12)
insert into tb_city (id,name,provinceid) values (108,'阜阳市',12)
insert into tb_city (id,name,provinceid) values (109,'宿州市',12)
insert into tb_city (id,name,provinceid) values (110,'巢湖市',12)
insert into tb_city (id,name,provinceid) values (111,'六安市',12)
insert into tb_city (id,name,provinceid) values (112,'亳州市',12)
insert into tb_city (id,name,provinceid) values (113,'池州市',12)
insert into tb_city (id,name,provinceid) values (114,'宣城市',12)
insert into tb_city (id,name,provinceid) values (115,'福州市',13)
insert into tb_city (id,name,provinceid) values (116,'厦门市',13)
insert into tb_city (id,name,provinceid) values (117,'莆田市',13)
insert into tb_city (id,name,provinceid) values (118,'三明市',13)
insert into tb_city (id,name,provinceid) values (119,'泉州市',13)
insert into tb_city (id,name,provinceid) values (120,'漳州市',13)
insert into tb_city (id,name,provinceid) values (121,'南平市',13)
insert into tb_city (id,name,provinceid) values (122,'龙岩市',13)
insert into tb_city (id,name,provinceid) values (123,'宁德市',13)
insert into tb_city (id,name,provinceid) values (124,'南昌市',14)
insert into tb_city (id,name,provinceid) values (125,'景德镇市',14)
insert into tb_city (id,name,provinceid) values (126,'萍乡市',14)
insert into tb_city (id,name,provinceid) values (127,'九江市',14)
insert into tb_city (id,name,provinceid) values (128,'新余市',14)
insert into tb_city (id,name,provinceid) values (129,'鹰潭市',14)
insert into tb_city (id,name,provinceid) values (130,'赣州市',14)
insert into tb_city (id,name,provinceid) values (131,'吉安市',14)
insert into tb_city (id,name,provinceid) values (132,'宜春市',14)
insert into tb_city (id,name,provinceid) values (133,'抚州市',14)
insert into tb_city (id,name,provinceid) values (134,'上饶市',14)
insert into tb_city (id,name,provinceid) values (135,'济南市',15)
insert into tb_city (id,name,provinceid) values (136,'青岛市',15)
insert into tb_city (id,name,provinceid) values (137,'淄博市',15)
insert into tb_city (id,name,provinceid) values (138,'枣庄市',15)
insert into tb_city (id,name,provinceid) values (139,'东营市',15)
insert into tb_city (id,name,provinceid) values (140,'烟台市',15)
insert into tb_city (id,name,provinceid) values (141,'潍坊市',15)
insert into tb_city (id,name,provinceid) values (142,'济宁市',15)
insert into tb_city (id,name,provinceid) values (143,'泰安市',15)
insert into tb_city (id,name,provinceid) values (144,'威海市',15)
insert into tb_city (id,name,provinceid) values (145,'日照市',15)
insert into tb_city (id,name,provinceid) values (146,'莱芜市',15)
insert into tb_city (id,name,provinceid) values (147,'临沂市',15)
insert into tb_city (id,name,provinceid) values (148,'德州市',15)
insert into tb_city (id,name,provinceid) values (149,'聊城市',15)
insert into tb_city (id,name,provinceid) values (150,'滨州市',15)
insert into tb_city (id,name,provinceid) values (151,'荷泽市',15)
insert into tb_city (id,name,provinceid) values (152,'郑州市',16)
insert into tb_city (id,name,provinceid) values (153,'开封市',16)
insert into tb_city (id,name,provinceid) values (154,'洛阳市',16)
insert into tb_city (id,name,provinceid) values (155,'平顶山市',16)
insert into tb_city (id,name,provinceid) values (156,'安阳市',16)
insert into tb_city (id,name,provinceid) values (157,'鹤壁市',16)
insert into tb_city (id,name,provinceid) values (158,'新乡市',16)
insert into tb_city (id,name,provinceid) values (159,'焦作市',16)
insert into tb_city (id,name,provinceid) values (160,'濮阳市',16)
insert into tb_city (id,name,provinceid) values (161,'许昌市',16)
insert into tb_city (id,name,provinceid) values (162,'漯河市',16)
insert into tb_city (id,name,provinceid) values (163,'三门峡市',16)
insert into tb_city (id,name,provinceid) values (164,'南阳市',16)
insert into tb_city (id,name,provinceid) values (165,'商丘市',16)
insert into tb_city (id,name,provinceid) values (166,'信阳市',16)
insert into tb_city (id,name,provinceid) values (167,'周口市',16)
insert into tb_city (id,name,provinceid) values (168,'驻马店市',16)
insert into tb_city (id,name,provinceid) values (169,'武汉市',17)
insert into tb_city (id,name,provinceid) values (170,'黄石市',17)
insert into tb_city (id,name,provinceid) values (171,'十堰市',17)
insert into tb_city (id,name,provinceid) values (172,'宜昌市',17)
insert into tb_city (id,name,provinceid) values (173,'襄樊市',17)
insert into tb_city (id,name,provinceid) values (174,'鄂州市',17)
insert into tb_city (id,name,provinceid) values (175,'荆门市',17)
insert into tb_city (id,name,provinceid) values (176,'孝感市',17)
insert into tb_city (id,name,provinceid) values (177,'荆州市',17)
insert into tb_city (id,name,provinceid) values (178,'黄冈市',17)
insert into tb_city (id,name,provinceid) values (179,'咸宁市',17)
insert into tb_city (id,name,provinceid) values (180,'随州市',17)
insert into tb_city (id,name,provinceid) values (181,'恩施土家族苗族自治州',17)
insert into tb_city (id,name,provinceid) values (182,'神农架',17)
insert into tb_city (id,name,provinceid) values (183,'长沙市',18)
insert into tb_city (id,name,provinceid) values (184,'株洲市',18)
insert into tb_city (id,name,provinceid) values (185,'湘潭市',18)
insert into tb_city (id,name,provinceid) values (186,'衡阳市',18)
insert into tb_city (id,name,provinceid) values (187,'邵阳市',18)
insert into tb_city (id,name,provinceid) values (188,'岳阳市',18)
insert into tb_city (id,name,provinceid) values (189,'常德市',18)
insert into tb_city (id,name,provinceid) values (190,'张家界市',18)
insert into tb_city (id,name,provinceid) values (191,'益阳市',18)
insert into tb_city (id,name,provinceid) values (192,'郴州市',18)
insert into tb_city (id,name,provinceid) values (193,'永州市',18)
insert into tb_city (id,name,provinceid) values (194,'怀化市',18)
insert into tb_city (id,name,provinceid) values (195,'娄底市',18)
insert into tb_city (id,name,provinceid) values (196,'湘西土家族苗族自治州',18)
insert into tb_city (id,name,provinceid) values (197,'广州市',19)
insert into tb_city (id,name,provinceid) values (198,'韶关市',19)
insert into tb_city (id,name,provinceid) values (199,'深圳市',19)
insert into tb_city (id,name,provinceid) values (200,'珠海市',19)
insert into tb_city (id,name,provinceid) values (201,'汕头市',19)
insert into tb_city (id,name,provinceid) values (202,'佛山市',19)
insert into tb_city (id,name,provinceid) values (203,'江门市',19)
insert into tb_city (id,name,provinceid) values (204,'湛江市',19)
insert into tb_city (id,name,provinceid) values (205,'茂名市',19)
insert into tb_city (id,name,provinceid) values (206,'肇庆市',19)
insert into tb_city (id,name,provinceid) values (207,'惠州市',19)
insert into tb_city (id,name,provinceid) values (208,'梅州市',19)
insert into tb_city (id,name,provinceid) values (209,'汕尾市',19)
insert into tb_city (id,name,provinceid) values (210,'河源市',19)
insert into tb_city (id,name,provinceid) values (211,'阳江市',19)
insert into tb_city (id,name,provinceid) values (212,'清远市',19)
insert into tb_city (id,name,provinceid) values (213,'东莞市',19)
insert into tb_city (id,name,provinceid) values (214,'中山市',19)
insert into tb_city (id,name,provinceid) values (215,'潮州市',19)
insert into tb_city (id,name,provinceid) values (216,'揭阳市',19)
insert into tb_city (id,name,provinceid) values (217,'云浮市',19)
insert into tb_city (id,name,provinceid) values (218,'南宁市',20)
insert into tb_city (id,name,provinceid) values (219,'柳州市',20)
insert into tb_city (id,name,provinceid) values (220,'桂林市',20)
insert into tb_city (id,name,provinceid) values (221,'梧州市',20)
insert into tb_city (id,name,provinceid) values (222,'北海市',20)
insert into tb_city (id,name,provinceid) values (223,'防城港市',20)
insert into tb_city (id,name,provinceid) values (224,'钦州市',20)
insert into tb_city (id,name,provinceid) values (225,'贵港市',20)
insert into tb_city (id,name,provinceid) values (226,'玉林市',20)
insert into tb_city (id,name,provinceid) values (227,'百色市',20)
insert into tb_city (id,name,provinceid) values (228,'贺州市',20)
insert into tb_city (id,name,provinceid) values (229,'河池市',20)
insert into tb_city (id,name,provinceid) values (230,'来宾市',20)
insert into tb_city (id,name,provinceid) values (231,'崇左市',20)
insert into tb_city (id,name,provinceid) values (232,'海口市',21)
insert into tb_city (id,name,provinceid) values (233,'三亚市',21)
insert into tb_city (id,name,provinceid) values (234,'重庆市',22)
insert into tb_city (id,name,provinceid) values (235,'成都市',23)
insert into tb_city (id,name,provinceid) values (236,'自贡市',23)
insert into tb_city (id,name,provinceid) values (237,'攀枝花市',23)
insert into tb_city (id,name,provinceid) values (238,'泸州市',23)
insert into tb_city (id,name,provinceid) values (239,'德阳市',23)
insert into tb_city (id,name,provinceid) values (240,'绵阳市',23)
insert into tb_city (id,name,provinceid) values (241,'广元市',23)
insert into tb_city (id,name,provinceid) values (242,'遂宁市',23)
insert into tb_city (id,name,provinceid) values (243,'内江市',23)
insert into tb_city (id,name,provinceid) values (244,'乐山市',23)
insert into tb_city (id,name,provinceid) values (245,'南充市',23)
insert into tb_city (id,name,provinceid) values (246,'眉山市',23)
insert into tb_city (id,name,provinceid) values (247,'宜宾市',23)
insert into tb_city (id,name,provinceid) values (248,'广安市',23)
insert into tb_city (id,name,provinceid) values (249,'达州市',23)
insert into tb_city (id,name,provinceid) values (250,'雅安市',23)
insert into tb_city (id,name,provinceid) values (251,'巴中市',23)
insert into tb_city (id,name,provinceid) values (252,'资阳市',23)
insert into tb_city (id,name,provinceid) values (253,'阿坝藏族羌族自治州',23)
insert into tb_city (id,name,provinceid) values (254,'甘孜藏族自治州',23)
insert into tb_city (id,name,provinceid) values (255,'凉山彝族自治州',23)
insert into tb_city (id,name,provinceid) values (256,'贵阳市',24)
insert into tb_city (id,name,provinceid) values (257,'六盘水市',24)
insert into tb_city (id,name,provinceid) values (258,'遵义市',24)
insert into tb_city (id,name,provinceid) values (259,'安顺市',24)
insert into tb_city (id,name,provinceid) values (260,'铜仁地区',24)
insert into tb_city (id,name,provinceid) values (261,'黔西南布依族苗族自治州',24)
insert into tb_city (id,name,provinceid) values (262,'毕节地区',24)
insert into tb_city (id,name,provinceid) values (263,'黔东南苗族侗族自治州',24)
insert into tb_city (id,name,provinceid) values (264,'黔南布依族苗族自治州',24)
insert into tb_city (id,name,provinceid) values (265,'昆明市',25)
insert into tb_city (id,name,provinceid) values (266,'曲靖市',25)
insert into tb_city (id,name,provinceid) values (267,'玉溪市',25)
insert into tb_city (id,name,provinceid) values (268,'保山市',25)
insert into tb_city (id,name,provinceid) values (269,'昭通市',25)
insert into tb_city (id,name,provinceid) values (270,'丽江市',25)
insert into tb_city (id,name,provinceid) values (271,'思茅市',25)
insert into tb_city (id,name,provinceid) values (272,'临沧市',25)
insert into tb_city (id,name,provinceid) values (273,'楚雄彝族自治州',25)
insert into tb_city (id,name,provinceid) values (274,'红河哈尼族彝族自治州',25)
insert into tb_city (id,name,provinceid) values (275,'文山壮族苗族自治州',25)
insert into tb_city (id,name,provinceid) values (276,'西双版纳傣族自治州',25)
insert into tb_city (id,name,provinceid) values (277,'大理白族自治州',25)
insert into tb_city (id,name,provinceid) values (278,'德宏傣族景颇族自治州',25)
insert into tb_city (id,name,provinceid) values (279,'怒江傈僳族自治州',25)
insert into tb_city (id,name,provinceid) values (280,'迪庆藏族自治州',25)
insert into tb_city (id,name,provinceid) values (281,'拉萨市',26)
insert into tb_city (id,name,provinceid) values (282,'昌都地区',26)
insert into tb_city (id,name,provinceid) values (283,'山南地区',26)
insert into tb_city (id,name,provinceid) values (284,'日喀则地区',26)
insert into tb_city (id,name,provinceid) values (285,'那曲地区',26)
insert into tb_city (id,name,provinceid) values (286,'阿里地区',26)
insert into tb_city (id,name,provinceid) values (287,'林芝地区',26)
insert into tb_city (id,name,provinceid) values (288,'西安市',27)
insert into tb_city (id,name,provinceid) values (289,'铜川市',27)
insert into tb_city (id,name,provinceid) values (290,'宝鸡市',27)
insert into tb_city (id,name,provinceid) values (291,'咸阳市',27)
insert into tb_city (id,name,provinceid) values (292,'渭南市',27)
insert into tb_city (id,name,provinceid) values (293,'延安市',27)
insert into tb_city (id,name,provinceid) values (294,'汉中市',27)
insert into tb_city (id,name,provinceid) values (295,'榆林市',27)
insert into tb_city (id,name,provinceid) values (296,'安康市',27)
insert into tb_city (id,name,provinceid) values (297,'商洛市',27)
insert into tb_city (id,name,provinceid) values (298,'兰州市',28)
insert into tb_city (id,name,provinceid) values (299,'嘉峪关市',28)
insert into tb_city (id,name,provinceid) values (300,'金昌市',28)
insert into tb_city (id,name,provinceid) values (301,'白银市',28)
insert into tb_city (id,name,provinceid) values (302,'天水市',28)
insert into tb_city (id,name,provinceid) values (303,'武威市',28)
insert into tb_city (id,name,provinceid) values (304,'张掖市',28)
insert into tb_city (id,name,provinceid) values (305,'平凉市',28)
insert into tb_city (id,name,provinceid) values (306,'酒泉市',28)
insert into tb_city (id,name,provinceid) values (307,'庆阳市',28)
insert into tb_city (id,name,provinceid) values (308,'定西市',28)
insert into tb_city (id,name,provinceid) values (309,'陇南市',28)
insert into tb_city (id,name,provinceid) values (310,'临夏回族自治州',28)
insert into tb_city (id,name,provinceid) values (311,'甘南藏族自治州',28)
insert into tb_city (id,name,provinceid) values (312,'西宁市',29)
insert into tb_city (id,name,provinceid) values (313,'海东地区',29)
insert into tb_city (id,name,provinceid) values (314,'海北藏族自治州',29)
insert into tb_city (id,name,provinceid) values (315,'黄南藏族自治州',29)
insert into tb_city (id,name,provinceid) values (316,'海南藏族自治州',29)
insert into tb_city (id,name,provinceid) values (317,'果洛藏族自治州',29)
insert into tb_city (id,name,provinceid) values (318,'玉树藏族自治州',29)
insert into tb_city (id,name,provinceid) values (319,'海西蒙古族藏族自治州',29)
insert into tb_city (id,name,provinceid) values (320,'银川市',30)
insert into tb_city (id,name,provinceid) values (321,'石嘴山市',30)
insert into tb_city (id,name,provinceid) values (322,'吴忠市',30)
insert into tb_city (id,name,provinceid) values (323,'固原市',30)
insert into tb_city (id,name,provinceid) values (324,'中卫市',30)
insert into tb_city (id,name,provinceid) values (325,'乌鲁木齐市',31)
insert into tb_city (id,name,provinceid) values (326,'克拉玛依市',31)
insert into tb_city (id,name,provinceid) values (327,'吐鲁番地区',31)
insert into tb_city (id,name,provinceid) values (328,'哈密地区',31)
insert into tb_city (id,name,provinceid) values (329,'昌吉回族自治州',31)
insert into tb_city (id,name,provinceid) values (330,'博尔塔拉蒙古自治州',31)
insert into tb_city (id,name,provinceid) values (331,'巴音郭楞蒙古自治州',31)
insert into tb_city (id,name,provinceid) values (332,'阿克苏地区',31)
insert into tb_city (id,name,provinceid) values (333,'克孜勒苏柯尔克孜自治州',31)
insert into tb_city (id,name,provinceid) values (334,'喀什地区',31)
insert into tb_city (id,name,provinceid) values (335,'和田地区',31)
insert into tb_city (id,name,provinceid) values (336,'伊犁哈萨克自治州',31)
insert into tb_city (id,name,provinceid) values (337,'塔城地区',31)
insert into tb_city (id,name,provinceid) values (338,'阿勒泰地区',31)
insert into tb_city (id,name,provinceid) values (339,'石河子市',31)
insert into tb_city (id,name,provinceid) values (340,'阿拉尔市',31)
insert into tb_city (id,name,provinceid) values (341,'图木舒克市',31)
insert into tb_city (id,name,provinceid) values (342,'五家渠市',31)
insert into tb_city (id,name,provinceid) values (343,'香港特别行政区',32)
insert into tb_city (id,name,provinceid) values (344,'澳门特别行政区',33)
insert into tb_city (id,name,provinceid) values (345,'台湾省',34)
select * from tb_city
各区县的数据比较的大，下载地址为
http://download.csdn.net/detail/huangzhe10/2947487
呵呵