mysql全国地域的数据汇总.docx
- 文档编号:29587624
- 上传时间:2023-07-24
- 格式:DOCX
- 页数:20
- 大小:18.14KB
mysql全国地域的数据汇总.docx
《mysql全国地域的数据汇总.docx》由会员分享,可在线阅读,更多相关《mysql全国地域的数据汇总.docx(20页珍藏版)》请在冰豆网上搜索。
mysql全国地域的数据汇总
MYSQL数据库地域汇总
insertintoab_szdq(id,name,parent_id,fx)values(1,'中国',0,0);
insertintoab_szdq(id,name,parent_id,fx)values(2,'北京',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(3,'北京',2,0);
insertintoab_szdq(id,name,parent_id,fx)values(4,'上海',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(5,'上海',4,0);
insertintoab_szdq(id,name,parent_id,fx)values(6,'香港特别行政区',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(7,'香港特别行政区',6,0);
insertintoab_szdq(id,name,parent_id,fx)values(8,'澳门特别行政区',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(9,'澳门特别行政区',8,0);
insertintoab_szdq(id,name,parent_id,fx)values(10,'河北',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(11,'石家庄',10,0);
insertintoab_szdq(id,name,parent_id,fx)values(12,'唐山',10,0);
insertintoab_szdq(id,name,parent_id,fx)values(13,'保定',10,0);
insertintoab_szdq(id,name,parent_id,fx)values(14,'衡水',10,0);
insertintoab_szdq(id,name,parent_id,fx)values(15,'秦皇岛',10,0);
insertintoab_szdq(id,name,parent_id,fx)values(16,'邯郸',10,0);
insertintoab_szdq(id,name,parent_id,fx)values(17,'邢台',10,0);
insertintoab_szdq(id,name,parent_id,fx)values(18,'保定',10,0);
insertintoab_szdq(id,name,parent_id,fx)values(19,'张家口',10,0);
insertintoab_szdq(id,name,parent_id,fx)values(20,'承德',10,0);
insertintoab_szdq(id,name,parent_id,fx)values(21,'沧州',10,0);
insertintoab_szdq(id,name,parent_id,fx)values(22,'廊坊',10,0);
insertintoab_szdq(id,name,parent_id,fx)values(23,'山西',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(24,'太原',23,0);
insertintoab_szdq(id,name,parent_id,fx)values(25,'大同',23,0);
insertintoab_szdq(id,name,parent_id,fx)values(26,'阳泉',23,0);
insertintoab_szdq(id,name,parent_id,fx)values(27,'长治',23,0);
insertintoab_szdq(id,name,parent_id,fx)values(28,'晋城',23,0);
insertintoab_szdq(id,name,parent_id,fx)values(29,'吕梁',23,0);
insertintoab_szdq(id,name,parent_id,fx)values(30,'晋中',23,0);
insertintoab_szdq(id,name,parent_id,fx)values(31,'运城',23,0);
insertintoab_szdq(id,name,parent_id,fx)values(32,'临汾',23,0);
insertintoab_szdq(id,name,parent_id,fx)values(33,'朔州',23,0);
insertintoab_szdq(id,name,parent_id,fx)values(34,'忻州',23,0);
insertintoab_szdq(id,name,parent_id,fx)values(35,'辽宁',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(36,'沈阳',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(37,'大连',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(38,'鞍山',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(39,'抚顺',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(40,'本溪',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(41,'丹东',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(42,'锦州',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(43,'葫芦岛',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(44,'营口',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(45,'盘锦',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(46,'阜新',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(47,'朝阳',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(48,'辽阳',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(49,'铁岭',35,0);
insertintoab_szdq(id,name,parent_id,fx)values(50,'吉林',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(51,'长春',50,0);
insertintoab_szdq(id,name,parent_id,fx)values(52,'四平',50,0);
insertintoab_szdq(id,name,parent_id,fx)values(53,'辽源',50,0);
insertintoab_szdq(id,name,parent_id,fx)values(54,'通化',50,0);
insertintoab_szdq(id,name,parent_id,fx)values(55,'白山',50,0);
insertintoab_szdq(id,name,parent_id,fx)values(56,'松原',50,0);
insertintoab_szdq(id,name,parent_id,fx)values(57,'白城',50,0);
insertintoab_szdq(id,name,parent_id,fx)values(58,'延边朝鲜族自治州',50,0);
insertintoab_szdq(id,name,parent_id,fx)values(59,'吉林',50,0);
insertintoab_szdq(id,name,parent_id,fx)values(60,'黑龙江',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(61,'哈尔滨',60,0);
insertintoab_szdq(id,name,parent_id,fx)values(62,'齐齐哈尔',60,0);
insertintoab_szdq(id,name,parent_id,fx)values(63,'鹤岗',60,0);
insertintoab_szdq(id,name,parent_id,fx)values(64,'双鸭山',60,0);
insertintoab_szdq(id,name,parent_id,fx)values(65,'鸡西',60,0);
insertintoab_szdq(id,name,parent_id,fx)values(66,'大庆',60,0);
insertintoab_szdq(id,name,parent_id,fx)values(67,'伊春',60,0);
insertintoab_szdq(id,name,parent_id,fx)values(68,'牡丹江',60,0);
insertintoab_szdq(id,name,parent_id,fx)values(69,'佳木斯',60,0);
insertintoab_szdq(id,name,parent_id,fx)values(70,'七台河',60,0);
insertintoab_szdq(id,name,parent_id,fx)values(71,'黑河',60,0);
insertintoab_szdq(id,name,parent_id,fx)values(72,'绥化',60,0);
insertintoab_szdq(id,name,parent_id,fx)values(73,'大兴安岭地区',60,0);
insertintoab_szdq(id,name,parent_id,fx)values(74,'江苏',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(75,'南京',74,0);
insertintoab_szdq(id,name,parent_id,fx)values(76,'南通',74,0);
insertintoab_szdq(id,name,parent_id,fx)values(77,'苏州',74,0);
insertintoab_szdq(id,name,parent_id,fx)values(78,'扬州',74,0);
insertintoab_szdq(id,name,parent_id,fx)values(79,'无锡',74,0);
insertintoab_szdq(id,name,parent_id,fx)values(80,'常州',74,0);
insertintoab_szdq(id,name,parent_id,fx)values(81,'淮安',74,0);
insertintoab_szdq(id,name,parent_id,fx)values(82,'盐城',74,0);
insertintoab_szdq(id,name,parent_id,fx)values(83,'宿迁',74,0);
insertintoab_szdq(id,name,parent_id,fx)values(84,'徐州',74,0);
insertintoab_szdq(id,name,parent_id,fx)values(85,'连云港',74,0);
insertintoab_szdq(id,name,parent_id,fx)values(86,'镇江',74,0);
insertintoab_szdq(id,name,parent_id,fx)values(87,'泰州',74,0);
insertintoab_szdq(id,name,parent_id,fx)values(88,'浙江',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(89,'杭州',88,0);
insertintoab_szdq(id,name,parent_id,fx)values(90,'宁波',88,0);
insertintoab_szdq(id,name,parent_id,fx)values(91,'嘉兴',88,0);
insertintoab_szdq(id,name,parent_id,fx)values(92,'绍兴',88,0);
insertintoab_szdq(id,name,parent_id,fx)values(93,'温州',88,0);
insertintoab_szdq(id,name,parent_id,fx)values(94,'义乌',88,0);
insertintoab_szdq(id,name,parent_id,fx)values(95,'金华',88,0);
insertintoab_szdq(id,name,parent_id,fx)values(96,'舟山',88,0);
insertintoab_szdq(id,name,parent_id,fx)values(97,'湖州',88,0);
insertintoab_szdq(id,name,parent_id,fx)values(98,'衢州',88,0);
insertintoab_szdq(id,name,parent_id,fx)values(99,'台州',88,0);
insertintoab_szdq(id,name,parent_id,fx)values(100,'丽水',88,0);
insertintoab_szdq(id,name,parent_id,fx)values(101,'安徽',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(102,'合肥',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(103,'淮南',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(104,'马鞍山',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(105,'淮北',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(106,'安庆',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(107,'黄山',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(108,'阜阳',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(109,'宿州',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(110,'六安',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(111,'毫州',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(112,'池州',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(113,'宣城',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(114,'巢湖',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(115,'芜湖',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(116,'蚌埠',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(117,'铜陵',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(118,'滁州',101,0);
insertintoab_szdq(id,name,parent_id,fx)values(119,'福建',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(120,'福州',119,0);
insertintoab_szdq(id,name,parent_id,fx)values(121,'厦门',119,0);
insertintoab_szdq(id,name,parent_id,fx)values(122,'泉州',119,0);
insertintoab_szdq(id,name,parent_id,fx)values(123,'漳州',119,0);
insertintoab_szdq(id,name,parent_id,fx)values(124,'三明',119,0);
insertintoab_szdq(id,name,parent_id,fx)values(125,'莆田',119,0);
insertintoab_szdq(id,name,parent_id,fx)values(126,'宁德',119,0);
insertintoab_szdq(id,name,parent_id,fx)values(127,'南平',119,0);
insertintoab_szdq(id,name,parent_id,fx)values(128,'龙岩',119,0);
insertintoab_szdq(id,name,parent_id,fx)values(129,'江西',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(130,'南昌',129,0);
insertintoab_szdq(id,name,parent_id,fx)values(131,'新余',129,0);
insertintoab_szdq(id,name,parent_id,fx)values(132,'庐山',129,0);
insertintoab_szdq(id,name,parent_id,fx)values(133,'景德镇',129,0);
insertintoab_szdq(id,name,parent_id,fx)values(134,'萍乡',129,0);
insertintoab_szdq(id,name,parent_id,fx)values(135,'九江',129,0);
insertintoab_szdq(id,name,parent_id,fx)values(136,'鹰潭',129,0);
insertintoab_szdq(id,name,parent_id,fx)values(137,'赣州',129,0);
insertintoab_szdq(id,name,parent_id,fx)values(138,'吉安',129,0);
insertintoab_szdq(id,name,parent_id,fx)values(139,'宜春',129,0);
insertintoab_szdq(id,name,parent_id,fx)values(140,'抚州',129,0);
insertintoab_szdq(id,name,parent_id,fx)values(141,'上饶',129,0);
insertintoab_szdq(id,name,parent_id,fx)values(142,'山东',1,0);
insertintoab_szdq(id,name,parent_id,fx)values(143,'济南',142,0);
insertintoab_szdq(id,name,parent_id,fx)values(144,'青岛',142,0);
insertintoab_szdq(id,name,parent_id,fx)values(145,'淄博',142,0);
insertintoab_szdq(id,name,parent_id,fx)values(146,'枣庄',142,0);
insertintoab_szdq(id,name,parent_id,fx)values(147,'东营',142,0);
insertintoab_szdq(id,name,parent_id,fx)values(148,'烟台',142,0);
insertintoab_szdq(id,name,parent_id,fx)values(149,'威海',142,0);
insertintoab_sz
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- mysql 全国 地域 数据 汇总
![提示](https://static.bdocx.com/images/bang_tan.gif)