省市地区的二级分类SQL脚本（含数据）

于 2011-04-18 10:54:00 发布
阅读量2.6k 收藏 1
点赞数
分类专栏： 开发 文章标签： 脚本 sql insert null table 360
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sea0x/article/details/6330591
版权

CREATE TABLE [tbl_Area] (
 [ParentCode] [int] NULL ,
 [AreaCode] [int] NOT NULL ,
 [AreaName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

 


INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (1,'北京市');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (2,'天津市');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (3,'上海市');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (4,'重庆市');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (5,'河北省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (6,'山西省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (7,'台湾省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (8,'辽宁省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (9,'吉林省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (10,'黑龙江省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (11,'江苏省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (12,'浙江省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (13,'安徽省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (14,'福建省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (15,'江西省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (16,'山东省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (17,'河南省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (18,'湖北省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (19,'湖南省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (20,'广东省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (21,'甘肃省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (22,'四川省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (23,'贵州省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (24,'海南省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (25,'云南省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (26,'青海省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (27,'陕西省');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (28,'广西壮族自治区');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (29,'西藏自治区');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (30,'宁夏回族自治区');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (31,'新疆维吾尔自治区');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (32,'内蒙古自治区');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (33,'澳门特别行政区');
INSERT INTO tbl_Area(AreaCode, AreaName) VALUES (34,'香港特别行政区');

update tbl_Area set ParentCode=0

INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (100,'北京市',1);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (101,'天津市',2);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (102,'上海市',3);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (103,'重庆市',4);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (104,'石家庄市',5);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (105,'保定市',5);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (106,'唐山市',5);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (107,'廊坊市',5);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (108,'张家口市',5);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (109,'承德市',5);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (110,'沧州市',5);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (111,'秦皇岛市',5);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (112,'衡水市',5);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (113,'邢台市',5);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (114,'邯郸市',5);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (115,'太原市',6);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (116, '临汾市',6);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (117,'吕梁市',6);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (118,'大同市',6);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (119,'忻州市',6);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (120,'晋中市',6);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (121,'晋城市',6);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (122,'朔州市',6);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (123,'运城市',6);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (124,'长治市',6);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (125,'阳泉市',6);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (126,'台北市',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (127,'云林县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (128,'南投县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (129,'台东县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (130,'台中县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (131,'台中市',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (132,'台北县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (133,'台南县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (134,'台南市',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (135,'嘉义县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (136,'嘉义市',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (137,'基隆市',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (138,'宜兰县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (139,'屏东县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (140,'彰化县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (141,'新竹县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (142,'新竹市',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (143,'桃园县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (144,'澎湖县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (145,'花莲县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (146,'苗栗县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (147,'高雄县',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (148,'高雄市',7);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (149,'沈阳市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (150,'大连市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (151,'丹东市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (152,'抚顺市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (153,'朝阳市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (154,'本溪市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (155,'盘锦市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (156,'营口市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (157,'葫芦岛市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (158,'辽阳市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (159,'铁岭市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (160,'锦州市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (161,'阜新市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (162,'鞍山市',8);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (163,'长春市',9);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (164,'吉林市',9);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (165,'四平市',9);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (166,'延边朝鲜族自治州',9);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (167,'松原市',9);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (168,'白城市',9);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (169,'白山市',9);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (170,'辽源市',9);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (171,'通化市',9);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (172,'哈尔滨市',10);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (173,'七台河市',10);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (174,'伊 春 市',10);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (175,'佳木斯市',10);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (176,'双鸭山市',10);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (177,'大 庆 市',10);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (178,'大兴安岭地区',10);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (179,'牡丹江市',10);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (180,'绥 化 市',10);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (181,'鸡 西 市',10);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (182,'鹤 岗 市',10);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (183,'黑 河 市',10);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (184,'齐齐哈尔市',10);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (185,'南京市',11);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (186,'南通市',11);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (187,'宿迁市',11);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (188,'常州市',11);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (189,'徐州市',11);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (190,'扬州市',11);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (191,'无锡市',11);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (192,'泰州市',11);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (193,'淮安市',11);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (194,'盐城市',11);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (195,'苏州市',11);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (196,'连云港市',11);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (197,'镇江市',11);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (198,'杭州市',12);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (199,'丽水市',12);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (200,'台州市',12);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (201,'嘉兴市',12);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (202,'宁波市',12);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (203,'温州市',12);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (204,'湖州市',12);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (205,'绍兴市',12);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (206,'舟山市',12);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (207,'衢州市',12);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (208,'金华市',12);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (209,'合肥市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (210,'亳州市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (211,'六安市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (212,'安庆市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (213,'宣城市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (214,'宿州市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (215,'巢湖市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (216,'池州市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (217,'淮北市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (218,'淮南市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (219,'滁州市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (220,'芜湖市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (221,'蚌埠市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (222,'铜陵市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (223,'阜阳市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (224,'马鞍山市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (225,'黄山市',13);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (226,'福州市',14);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (227,'三明市',14);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (228,'南平市',14);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (229,'厦门市',14);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (230,'宁德市',14);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (231,'泉州市',14);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (232,'漳州市',14);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (233,'莆田市',14);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (234,'龙岩市',14);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (235,'南昌市',15);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (236,'上饶市',15);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (237,'九江市',15);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (238,'吉安市',15);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (239,'宜春市',15);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (240,'抚州市',15);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (241,'新余市',15);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (242,'景德镇市',15);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (243,'萍乡市',15);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (244,'赣州市',15);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (245,'鹰潭市',15);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (246,'济南市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (247,'东营市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (248,'临沂市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (249,'威海市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (250,'德州市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (251,'日照市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (252,'枣庄市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (253,'泰安市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (254,'济宁市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (255,'淄博市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (256,'滨州市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (257,'潍坊市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (258,'烟台市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (259,'聊城市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (260,'莱芜市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (261,'菏泽市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (262,'青岛市',16);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (263,'郑州市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (264,'三门峡市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (265,'信阳市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (266,'南阳市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (267,'周口市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (268,'商丘市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (269,'安阳市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (270,'平顶山市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (271,'开封市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (272,'新乡市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (273,'洛阳市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (274,'济源市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (275,'漯河市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (276,'濮阳市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (277,'焦作市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (278,'许昌市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (279,'驻马店市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (280,'鹤壁市',17);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (281,'武汉市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (282,'仙桃市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (283,'十堰市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (284,'咸宁市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (285,'天门市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (286,'孝感市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (287,'宜昌市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (288,'恩施土家族苗族自治州',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (289,'潜江市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (290,'神农架林区',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (291,'荆州市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (292,'荆门市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (293,'襄樊市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (294,'鄂州市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (295,'随州市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (296,'黄冈市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (297,'黄石市',18);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (298,'长沙市',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (299,'娄底市',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (300,'岳阳市',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (301,'常德市',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (302,'张家界市',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (303,'怀化市',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (304,'株洲市',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (305,'永州市',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (306,'湘潭市',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (307,'湘西土家族苗族自治州',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (308,'益阳市',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (309,'衡阳市',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (310,'邵阳市',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (311,'郴州市',19);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (312,'广州市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (313,'东莞市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (314,'中山市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (315,'云浮市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (316,'佛山市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (317,'惠州市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (318,'揭阳市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (319,'梅州市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (320,'汕头市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (321,'汕尾市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (322,'江门市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (323,'河源市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (324,'深圳市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (325,'清远市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (326,'湛江市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (327,'潮州市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (328,'珠海市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (329,'肇庆市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (330,'茂名市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (331,'阳江市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (332,'韶关市',20);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (333,'兰州市',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (334,'临夏回族自治州',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (335,'嘉峪关市',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (336,'天水市',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (337,'定西市',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (338,'平凉市',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (339,'庆阳市',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (340,'张掖市',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (341,'武威市',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (342,'甘南藏族自治州',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (343,'白银市',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (344,'酒泉市',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (345,'金昌市',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (346,'陇南市',21);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (347,'成都市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (348,'乐山市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (349,'内江市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (350,'凉山彝族自治州',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (351,'南充市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (352,'宜宾市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (353,'巴中市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (354,'广元市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (355,'广安市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (356,'德阳市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (357,'攀枝花市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (358,'泸州市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (359,'甘孜藏族自治州',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (360,'眉山市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (361,'绵阳市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (362,'自贡市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (363,'资阳市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (364,'达州市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (365,'遂宁市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (366,'阿坝藏族羌族自治州',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (367,'雅安市',22);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (368,'贵阳市',23);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (369,'六盘水市',23);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (370,'安顺市',23);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (371,'毕节地区',23);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (372,'遵义市',23);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (373,'铜仁地区',23);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (374,'黔东南苗族侗族自治州',23);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (375,'黔南布依族苗族自治州',23);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (376,'黔西南布依族苗族自治州',23);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (377,'海口市',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (378,'万宁市',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (379,'三亚市',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (380,'东方市',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (381,'临高县',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (382,'乐东黎族自治县',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (383,'五指山市',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (384,'保亭黎族苗族自治县',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (385,'儋州市',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (386,'定安县',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (387,'屯昌县',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (388,'文昌市',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (389,'昌江黎族自治县',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (390,'澄迈县',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (391,'琼中黎族苗族自治县',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (392,'琼海市',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (393,'白沙黎族自治县',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (394,'陵水黎族自治县',24);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (395,'昆明市',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (396,'临沧市',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (397,'丽江市',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (398,'保山市',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (399,'大理白族自治州',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (400,'德宏傣族景颇族自治州',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (401,'怒江傈傈族自治州',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (402,'思茅市',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (403,'文山壮族苗族自治州',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (404,'昭通市',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (405,'曲靖市',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (406,'楚雄彝族自治州',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (407,'玉溪市',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (408,'红河哈尼族彝族自治州',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (409,'西双版纳傣族自治州',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (410,'迪庆藏族自治州',25);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (411,'西宁市',26);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (412,'果洛藏族自治州',26);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (413,'海东地区',26);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (414,'海北藏族自治州',26);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (415,'海南藏族自治州',26);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (416,'海西蒙古族藏族自治州',26);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (417,'玉树藏族自治州',26);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (418,'黄南藏族自治州',26);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (419,'西安市',27);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (420,'咸阳市',27);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (421,'商洛市',27);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (422,'安康市',27);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (423,'宝鸡市',27);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (424,'延安市',27);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (425,'榆林市',27);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (426,'汉中市',27);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (427,'渭南市',27);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (428,'铜川市',27);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (429,'桂林市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (430,'北海市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (431,'南宁市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (432,'崇左市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (433,'来宾市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (434,'柳州市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (435,'梧州市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (436,'河池市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (437,'玉林市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (438,'百色市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (439,'贵港市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (440,'贺州市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (441,'钦州市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (442,'防城港市',28);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (443,'拉萨市',29);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (444,'山南地区',29);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (445,'日喀则地区',29);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (446,'昌都地区',29);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (447,'林芝地区',29);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (448,'那曲地区',29);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (449,'阿里地区',29);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (450,'中卫市',30);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (451,'吴忠市',30);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (452,'固原市',30);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (453,'石嘴山市',30);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (454,'银川市',30);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (455,'乌鲁木齐市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (456,'乌苏市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (457,'五家渠市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (458,'伊宁市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (459,'克拉玛依市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (460,'博乐市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (461,'吐鲁番市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (462,'和田市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (463,'哈密市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (464,'喀什市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (465,'图木舒克市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (466,'塔城市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (467,'奎屯市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (468,'库尔勒市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (469,'昌吉市　',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (470,'石河子市　',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (471,'米泉市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (472,'阜康市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (473,'阿克苏市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (474,'阿勒泰市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (475,'阿图什市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (476,'阿拉尔市',31);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (477,'呼和浩特市',32);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (478,'乌兰察布市',32);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (479,'乌海市',32);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (480,'兴安盟',32);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (481,'包头市',32);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (482,'呼伦贝尔市',32);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (483,'巴彦淖尔市',32);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (484,'赤峰市',32);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (485,'通辽市',32);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (486,'鄂尔多斯市',32);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (487,'锡林郭勒盟',32);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (488,'阿拉善盟',32);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (489,'澳门特别行政区',33);
INSERT INTO tbl_Area(AreaCode, AreaName, ParentCode) VALUES (490,'香港特别行政区',34);

sea0x
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
省市级联mysql数据_省市二级联动(省市数据存于数据库)
weixin_30635747的博客
02-12 1163
思路：1、加载省份信息，id,name2、选择省份，触发一个javascript函数(传递一个id)，函数异步去调用一个服务(xxx.aspx,xxx.ashx)，($.ajax(),$a.get())3、服务会返回一串htmlonchange=””>杭州湖州……4、接受到返回的html，并显示，$(“#city”).html(retHTML)步骤：1、数据库设计：Pid表示上一级标识(pa...
中国省市二级联动sql语句
06-28
中国省市二级联动，有2种, 单表的和2张表的, 单表的方便生成三级联动,
mysql 全国省市二级sql表
10-05
只有一张表，通过父ID关联，并且只有省市二级，没有区，下载的请注意。 mysql 数据库噢。
全国省市数据库 二级 sql语句
03-30
全国省市数据库 二级 sql语句全国省市数据库 二级 sql语句全国省市数据库 二级 sql语句全国省市数据库 二级 sql语句全国省市数据库 二级 sql语句
省市二级行政区域树SQL.sql
10-27
自用整理好的省市二级行政区域树结构，直接导入SQL脚本可用，也可以根据自己需求修改脚本再导入使用
MySQL SQL 省市县三级联动（含台湾）
11-30
"MySQL SQL 省市县三级联动（含台湾）"这个主题聚焦于一个特定的数据模型，即用于存储中国行政区域划分的数据库结构，它涉及到省级、市级和县级的层级关系，并且包含了台湾地区的数据。这样的设计在很多应用中都有...
省市县镇4级联动数据库脚本和数据mysql版
05-18
在Web开发中，四级联动指的是在一个下拉菜单或选择框中，用户选择一级地区（如国家），接着会显示对应的二级地区（如省份），然后是三级地区（如城市），最后是四级地区（如区县或城镇）。这种设计常用于地址填写、...
全国省市区三级联动-包括台湾香港澳门--以及56个民族sql
04-29
5. **area.sql**：这个文件名很可能就是包含上述所有信息的SQL脚本文件，用户可以通过导入这个脚本到自己的SQL数据库中，快速建立起完整的省市区及民族的数据结构。 在实际使用这些数据时，开发人员需要考虑如何...
全国省市区sql
02-28
表结构设计合理且简洁，能够满足大多数地区数据查询的需求。 **表结构说明：** - `id` (int类型, 11位整数): 主键字段，用于唯一标识每一个记录。 - `code` (varchar类型, 最多6个字符): 行政区划代码，按照国家...
全国（中国）省市两级联动 mysql数据库文件
09-21
全国（中国）省市两级联动 mysql数据库文件 导入即可、真实可用
mysql一张表存储 全国地区表 省 市 二级地区
09-29
mysql全国地区表，二级地区表，全国省份，市区，一张表存全部
sql二级的地区表
03-28
mysql省市的代码表 直接source district sql就好了 格式： id code name citycode city 1 "110101" "东城区" "110100" 1
大学专业二级分类表数据库
10-22
大学专业二级分类表,比较全面
省市二级联动代码与数据库
10-14
省市联动的查询显示页面，查到了省自动将省下面的市显示在页面上！
JS实现的省市二级联动的脚本
wenchang4you的专栏
10-27 2万+
 html>head>    title>title>    script language="javascript" type="text/javascript">        //定义 城市 数据数组cityArray = new Array(); cityArray[0] = new Array("北京市","东城|西城|崇文|宣武|朝阳|丰台|石景山|
mysql省市区邮政编码和区号级联sql文件
热门推荐
wyyl1的专栏
05-12 3万+
文章主要内容来源于csdn的lookbbs的资源，是他提供的sql语句，我只是删除了原语句中的“ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3145“因为这句有可能导致部分生成时编码错误。  DROP TABLE IF EXISTS `areas`;CREATE TABLE `areas` (  `id` int(11) NO
全国省市区县数据库脚本
09-13
全国省市区县数据库脚本，导入执行即可
全国各省份市县地区分级sql数据
05-12
全国各省市区县，parentId形式分级存储sql数据 完整版
世界地区二级 sql
最新发布
12-20
世界地区二级sql是指根据世界地理位置和传统文化等因素将世界划分为多个二级地区的数据库查询语言。通过这种二级sql可以实现对世界各地区的数据进行详细的筛选和分析，从而更好地了解各个地区的特点，制定相应的区域发展政策和措施。 这种二级sql可以用于查询世界各地区的人口数量、经济发展水平、自然资源分布、文化特色等多方面的信息，为全球各国和地区的政府、企业和研究机构提供重要参考。比如可以通过二级sql查询各个地区的人口密度情况，了解人口聚集的地区和人口分布的情况，为制定人口政策提供数据支持。 另外，通过世界地区二级sql还可以对不同地区的经济发展水平进行比较和分析，了解各地区的产业结构、经济增长速度，为制定区域经济发展规划提供重要参考。同时，还可以通过二级sql查询各地区的自然资源分布情况，了解各地区的资源优势和短板，为资源开发和保护提供决策支持。 总之，世界地区二级sql是一个可以实现对世界各地区数据进行细化查询和分析的工具，可以为全球范围内的决策者提供重要的数据支持和决策依据。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值