MySQL中国省市区数据表
DROP TABLE IF EXISTS `dgtx_places`;
CREATE TABLE `dgtx_places` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`cname` varchar(120) NOT NULL DEFAULT '',
`ctype` tinyint(1) NOT NULL DEFAULT '2',
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`),
KEY `ctype` (`ctype`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/
*国家/省/市数据信息*/
INSERT INTO `dgtx_places` VALUES (1,0,'中国',0);
INSERT INTO `dgtx_places` VALUES (2,1,'北京',1);
INSERT INTO `dgtx_places` VALUES (3,1,'安徽',1);
INSERT INTO `dgtx_places` VALUES (4,1,'福建',1);
INSERT INTO `dgtx_places` VALUES (5,1,'⽢肃',1);
INSERT INTO `dgtx_places` VALUES (6,1,'⼴东',1);
INSERT INTO `dgtx_places` VALUES (7,1,'⼴西',1);
INSERT INTO `dgtx_places` VALUES (8,1,'贵州',1);
INSERT INTO `dgtx_places` VALUES (9,1,'海南',1);
INSERT INTO `dgtx_places` VALUES (10,1,'河北',1);
INSERT INTO `dgtx_places` VALUES (11,1,'河南',1);
INSERT INTO `dgtx_places` VALUES (12,1,'⿊龙江',1);
INSERT INTO `dgtx_places` VALUES (13,1,'湖北',1);
INSERT INTO `dgtx_places` VALUES (14,1,'湖南',1);
INSERT INTO `dgtx_places` VALUES (15,1,'吉林',1);
INSERT INTO `dgtx_places` VALUES (16,1,'江苏',1);
drop table if exists adminINSERT INTO `dgtx_places` VALUES (17,1,'江西',1);
INSERT INTO `dgtx_places` VALUES (18,1,'辽宁',1);
INSERT INTO `dgtx_places` VALUES (19,1,'内蒙古',1);
INSERT INTO `dgtx_places` VALUES (20,1,'宁夏',1);
INSERT INTO `dgtx_places` VALUES (21,1,'青海',1);
INSERT INTO `dgtx_places` VALUES (22,1,'⼭东',1);
INSERT INTO `dgtx_places` VALUES (23,1,'⼭西',1);
INSERT INTO `dgtx_places` VALUES (24,1,'陕西',1);
INSERT INTO `dgtx_places` VALUES (25,1,'上海',1);
INSERT INTO `dgtx_places` VALUES (26,1,'四川',1);
INSERT INTO `dgtx_places` VALUES (27,1,'天津',1);
INSERT INTO `dgtx_places` VALUES (28,1,'西藏',1);
INSERT INTO `dgtx_places` VALUES (29,1,'新疆',1);
INSERT INTO `dgtx_places` VALUES (30,1,'云南',1);
INSERT INTO `dgtx_places` VALUES (31,1,'浙江',1);
INSERT INTO `dgtx_places` VALUES (32,1,'重庆',1);
INSERT INTO `dgtx_places` VALUES (33,1,'⾹港',1);
INSERT INTO `dgtx_places` VALUES (34,1,'澳门',1);
INSERT INTO `dgtx_places` VALUES (42,3,'淮北',2); INSERT INTO `dgtx_places` VALUES (43,3,'淮南',2); INSERT INTO `dgtx_places` VALUES (44,3,'黄⼭',2); INSERT INTO `dgtx_places` VALUES (45,3,'六安',2); INSERT INTO `dgtx_places` VALUES (46,3,'马鞍⼭',2); INSERT INTO `dgtx_places` VALUES (47,3,'宿州',2); INSERT INTO `dgtx_places` VALUES (48,3,'铜陵',2); INSERT INTO `dgtx_places` VALUES (49,3,'芜湖',2); INSERT INTO `dgtx_places` VALUES (50,3,'宣城',2); INSERT INTO `dgtx_places` VALUES (51,3,'亳州',2); INSERT INTO `dgtx_places` VALUES (52,2,'北京',2); INSERT INTO `dgtx_places` VALUES (53,4,'福州',2); INSERT INTO `dgtx_places` VALUES (54,4,'龙岩',2); INSERT INTO `dgtx_places` VALUES (55,4,'南平',2); INSERT INTO `dgtx_places` VALUES (56,4,'宁德',2); INSERT INTO `dgtx_places` VALUES (57,4,'莆⽥',2); INSERT INTO `dgtx_places` VALUES (58,4,'泉州',2); INSERT INTO `dgtx_places` VALUES (59,4,'三明',2); INSERT INTO `dgtx_places` VALUES (60,4,'厦门',2); INSERT INTO `dgtx_places` VALUES (61,4,'漳州',2); INSERT INTO `dgtx_places` VALUES (62,5,'兰州',2); INSERT INTO `dgtx_places` VALUES (63,5,'⽩银',2); INSERT INTO `dgtx_places` VALUES (64,5,'定西',2); INSERT INTO `dgtx_places` VALUES (65,5,'⽢南',2); INSERT INTO `dgtx_places` VALUES (66,5,'嘉峪关',2); INSERT INTO `dgtx_places` VALUES (6
7,5,'⾦昌',2); INSERT INTO `dgtx_places` VALUES (68,5,'酒泉',2); INSERT INTO `dgtx_places` VALUES (69,5,'临夏',2); INSERT INTO `dgtx_places` VALUES (70,5,'陇南',2); INSERT INTO `dgtx_places` VALUES (71,5,'平凉',2); INSERT INTO `dgtx_places` VALUES (72,5,'庆阳',2); INSERT INTO `dgtx_places` VALUES (73,5,'天⽔',2); INSERT INTO `dgtx_places` VALUES (74,5,'武威',2); INSERT INTO `dgtx_places` VALUES (75,5,'张掖',2); INSERT INTO `dgtx_places` VALUES (76,6,'⼴州',2); INSERT INTO `dgtx_places` VALUES (77,6,'深圳',2); INSERT INTO `dgtx_places` VALUES (78,6,'潮州',2); INSERT INTO `dgtx_places` VALUES (79,6,'东莞',2); INSERT INTO `dgtx_places` VALUES (80,6,'佛⼭',2); INSERT INTO `dgtx_places` VALUES (81,6,'河源',2); INSERT INTO `dgtx_places` VALUES (82,6,'惠州',2); INSERT INTO `dgtx_places` VALUES (83,6,'江门',2); INSERT INTO `dgtx_places` VALUES (84,6,'揭阳',2); INSERT INTO `dgtx_places` VALUES (85,6,'茂名',2);
INSERT INTO `dgtx_places` VALUES (93,6,'湛江',2); INSERT INTO `dgtx_places` VALUES (94,6,'肇庆',2); INSERT INTO `dgtx_places` VALUES (95,6,'中⼭',2); INSERT INTO `dgtx_places` VALUES (96,6,'珠海',2); INSERT INTO `dgtx_places` VALUES (97,7,'南宁',2); INSERT INTO `dgtx_places` VALUES (98,7,'桂林',2); INSERT INTO `dgtx_places` VALUES (99,7,'百⾊',2); INSERT INTO `dgtx_places` VALUES (100,7,'北海',2); INSERT INTO `dgtx_places` VALUES (101,7,'崇左',2); INSERT INTO `dgtx_places` VALUES (102,7,'防城港',2); INSERT INTO `dgtx_places` VALUES (103,7,
'贵港',2); INSERT INTO `dgtx_places` VALUES (104,7,'河池',2); INSERT INTO `dgtx_places` VALUES (105,7,'贺州',2); INSERT INTO `dgtx_places` VALUES (106,7,'来宾',2); INSERT INTO `dgtx_places` VALUES (107,7,'柳州',2); INSERT INTO `dgtx_places` VALUES (108,7,'钦州',2); INSERT INTO `dgtx_places` VALUES (109,7,'梧州',2); INSERT INTO `dgtx_places` VALUES (110,7,'⽟林',2); INSERT INTO `dgtx_places` VALUES (111,8,'贵阳',2); INSERT INTO `dgtx_places` VALUES (112,8,'安顺',2); INSERT INTO `dgtx_places` VALUES (113,8,'毕节',2); INSERT INTO `dgtx_places` VALUES (114,8,'六盘⽔',2); INSERT INTO `dgtx_places` VALUES (115,8,'黔东南',2); INSERT INTO `dgtx_places` VALUES (116,8,'黔南',2); INSERT INTO `dgtx_places` VALUES (117,8,'黔西南',2); INSERT INTO `dgtx_places` VALUES (118,8,'铜仁',2); INSERT INTO `dgtx_places` VALUES (119,8,'遵义',2); INSERT INTO `dgtx_places` VALUES (120,9,'海⼝',2); INSERT INTO `dgtx_places` VALUES (121,9,'三亚',2); INSERT INTO `dgtx_places` VALUES (122,9,'⽩沙',2); INSERT INTO `dgtx_places` VALUES (123,9,'保亭',2); INSERT INTO `dgtx_places` VALUES (124,9,'昌江',2); INSERT INTO `dgtx_places` VALUES (125,9,'澄迈县',2); INSERT INTO `dgtx_places` VALUES (126,9,'定安县',2); INSERT INTO `dgtx_places` VALUES (127,9,'东⽅',2); INSERT INTO `dgtx_places` VALUES (128,9,'乐东',2); INSERT INTO `dgtx_places` VALUES (129,9,'临⾼县',2); INSERT INTO `dgtx_places` VALUES (130,9,'陵⽔',2); INSERT INTO `dgtx_places` VALUES (131,9,'琼海',2); INSERT INTO `dgtx_places` VALUES (132,9,'琼中',2); INSERT INTO `dgtx_places` VALUES (133,9,'屯昌县',2); INSERT INTO `dgtx
_places` VALUES (134,9,'万宁',2); INSERT INTO `dgtx_places` VALUES (135,9,'⽂昌',2); INSERT INTO `dgtx_places` VALUES (136,9,'五指⼭',2);
INSERT INTO `dgtx_places` VALUES (144,10,'廊坊',2); INSERT INTO `dgtx_places` VALUES (145,10,'秦皇岛',2); INSERT INTO `dgtx_places` VALUES (146,10,'唐⼭',2); INSERT INTO `dgtx_places` VALUES (147,10,'邢台',2); INSERT INTO `dgtx_places` VALUES (148,10,'张家⼝',2); INSERT INTO `dgtx_places` VALUES (149,11,'郑州',2); INSERT INTO `dgtx_places` VALUES (150,11,'洛阳',2); INSERT INTO `dgtx_places` VALUES (151,11,'开封',2); INSERT INTO `dgtx_places` VALUES (152,11,'安阳',2); INSERT INTO `dgtx_places` VALUES (153,11,'鹤壁',2); INSERT INTO `dgtx_places` VALUES (154,11,'济源',2); INSERT INTO `dgtx_places` VALUES (155,11,'焦作',2); INSERT INTO `dgtx_places` VALUES (156,11,'南阳',2); INSERT INTO `dgtx_places` VALUES (157,11,'平顶⼭',2); INSERT INTO `dgtx_places` VALUES (158,11,'三门峡',2); INSERT INTO `dgtx_places` VALUES (159,11,'商丘',2); INSERT INTO `dgtx_places` VALUES (160,11,'新乡',2); INSERT INTO `dgtx_places` VALUES (161,11,'信阳',2); INSERT INTO `dgtx_places` VALUES (162,11,'许昌',2); INSERT INTO `dgtx_places` VALUES (163,11,'周⼝',2); INSERT INTO `dgtx_places` VALUES (164,11,'驻马店',2); INSERT INTO `dgtx_places` VALUES (165,11,'漯河',2); INSERT INTO `dgtx_places` VALUES (166,11,'濮阳',2); INSERT INTO `dgtx_places` VALUES (167,12,'哈尔滨',2); IN
SERT INTO `dgtx_places` VALUES (168,12,'⼤庆',2); INSERT INTO `dgtx_places` VALUES (169,12,'⼤兴安岭',2); INSERT INTO `dgtx_places` VALUES (170,12,'鹤岗',2); INSERT INTO `dgtx_places` VALUES (171,12,'⿊河',2); INSERT INTO `dgtx_places` VALUES (172,12,'鸡西',2); INSERT INTO `dgtx_places` VALUES (173,12,'佳⽊斯',2); INSERT INTO `dgtx_places` VALUES (174,12,'牡丹江',2); INSERT INTO `dgtx_places` VALUES (175,12,'七台河',2); INSERT INTO `dgtx_places` VALUES (176,12,'齐齐哈尔',2); INSERT INTO `dgtx_places` VALUES (177,12,'双鸭⼭',2); INSERT INTO `dgtx_places` VALUES (178,12,'绥化',2); INSERT INTO `dgtx_places` VALUES (179,12,'伊春',2); INSERT INTO `dgtx_places` VALUES (180,13,'武汉',2); INSERT INTO `dgtx_places` VALUES (181,13,'仙桃',2); INSERT INTO `dgtx_places` VALUES (182,13,'鄂州',2); INSERT INTO `dgtx_places` VALUES (183,13,'黄冈',2); INSERT INTO `dgtx_places` VALUES (184,13,'黄⽯',2); INSERT INTO `dgtx_places` VALUES (185,13,'荆门',2); INSERT INTO `dgtx_places` VALUES (186,13,'荆州',2); INSERT INTO `dgtx_places` VALUES (187,13,'潜江',2);
INSERT INTO `dgtx_places` VALUES (195,13,'宜昌',2); INSERT INTO `dgtx_places` VALUES (196,13,'恩施',2); INSERT INTO `dgtx_places` VALUES (197,14,'长沙',2); INSERT INTO `dgtx_places` VALUES (198,14,'张家界',2); INSERT INTO `dgtx_places` VALUES (199,14,'常德',2); INSERT INTO `dgtx_places` VALUES (200,14,'郴州',2); INSERT INTO `dgtx_places` VALUES (201,14,'衡阳',2); INSE
RT INTO `dgtx_places` VALUES (202,14,'怀化',2); INSERT INTO `dgtx_places` VALUES (203,14,'娄底',2); INSERT INTO `dgtx_places` VALUES (204,14,'邵阳',2); INSERT INTO `dgtx_places` VALUES (205,14,'湘潭',2); INSERT INTO `dgtx_places` VALUES (206,14,'湘西',2); INSERT INTO `dgtx_places` VALUES (207,14,'益阳',2); INSERT INTO `dgtx_places` VALUES (208,14,'永州',2); INSERT INTO `dgtx_places` VALUES (209,14,'岳阳',2); INSERT INTO `dgtx_places` VALUES (210,14,'株洲',2); INSERT INTO `dgtx_places` VALUES (211,15,'长春',2); INSERT INTO `dgtx_places` VALUES (212,15,'吉林',2); INSERT INTO `dgtx_places` VALUES (213,15,'⽩城',2); INSERT INTO `dgtx_places` VALUES (214,15,'⽩⼭',2); INSERT INTO `dgtx_places` VALUES (215,15,'辽源',2); INSERT INTO `dgtx_places` VALUES (216,15,'四平',2); INSERT INTO `dgtx_places` VALUES (217,15,'松原',2); INSERT INTO `dgtx_places` VALUES (218,15,'通化',2); INSERT INTO `dgtx_places` VALUES (219,15,'延边',2); INSERT INTO `dgtx_places` VALUES (220,16,'南京',2); INSERT INTO `dgtx_places` VALUES (221,16,'苏州',2); INSERT INTO `dgtx_places` VALUES (222,16,'⽆锡',2); INSERT INTO `dgtx_places` VALUES (223,16,'常州',2); INSERT INTO `dgtx_places` VALUES (224,16,'淮安',2); INSERT INTO `dgtx_places` VALUES (225,16,'连云港',2); INSERT INTO `dgtx_places` VALUES (226,16,'南通',2); INSERT INTO `dgtx_places` VALUES (227,16,'宿迁',2); INSERT INTO `dgtx_places` VALUES (228,16,'泰州',2); INSERT INTO `dgtx_places` VALUES (229,16,'徐州',2); INSERT INTO `dgtx_places` VALUES (230,16,'盐城',2); INSERT INTO `dgtx_places` VALUES (231,16,'扬州',2); INSE
RT INTO `dgtx_places` VALUES (232,16,'镇江',2); INSERT INTO `dgtx_places` VALUES (233,17,'南昌',2); INSERT INTO `dgtx_places` VALUES (234,17,'抚州',2); INSERT INTO `dgtx_places` VALUES (235,17,'赣州',2); INSERT INTO `dgtx_places` VALUES (236,17,'吉安',2); INSERT INTO `dgtx_places` VALUES (237,17,'景德镇',2); INSERT INTO `dgtx_places` VALUES (238,17,'九江',2);
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
发表评论