复用数据库之中国地区表（除台湾外精确到地级市）

    SQL脚本。原po建表思路很不错，有点像没优化的并查集的感觉，我略作修改，在这里谢过了。建表语句就不写了，手动也可吧，表名location，一共426条记录，包括1个根节点中国，34个省、直辖市和行政特区，其余为地级市（台湾到县），id可作主键，name不超过15个字符，fid可做外键引用主键id，只有根节点fid字段为空，language字段这里没有实际用处，不用可以插入完删掉。之前没注意弄掉了天津跟重庆，要说原po也是真坏，让我打了好几次补丁。

insert into location (id,name,fid) values(1,'中国',null);

insert into location (id,name,fid) values(2,'北京',1);
insert into location (id,name,fid) values(3,'北京',2);

insert into location (id,name,fid) values(4,'上海',1);
insert into location (id,name,fid) values(5,'上海',4);

insert into location (id,name,fid) values(6,'香港特别行政区',1);
insert into location (id,name,fid) values(7,'香港特别行政区',6);

insert into location (id,name,fid) values(8,'澳门特别行政区',1);
insert into location (id,name,fid) values(9,'澳门特别行政区',8);

insert into location (id,name,fid) values(10,'河北',1);

insert into location (id,name,fid) values(11,'石家庄',10);
insert into location (id,name,fid) values(12,'唐山',10);
insert into location (id,name,fid) values(13,'保定',10);
insert into location (id,name,fid) values(14,'衡水',10);
insert into location (id,name,fid) values(15,'秦皇岛',10);
insert into location (id,name,fid) values(16,'邯郸',10);
insert into location (id,name,fid) values(17,'邢台',10);
insert into location (id,name,fid) values(18,'保定',10);
insert into location (id,name,fid) values(19,'张家口',10);
insert into location (id,name,fid) values(20,'承德',10);
insert into location (id,name,fid) values(21,'沧州',10);
insert into location (id,name,fid) values(22,'廊坊',10);

insert into location (id,name,fid) values(23,'山西',1);

insert into location (id,name,fid) values(24,'太原',23);
insert into location (id,name,fid) values(25,'大同',23);
insert into location (id,name,fid) values(26,'阳泉',23);
insert into location (id,name,fid) values(27,'长治',23);
insert into location (id,name,fid) values(28,'晋城',23);
insert into location (id,name,fid) values(29,'吕梁',23);
insert into location (id,name,fid) values(30,'晋中',23);
insert into location (id,name,fid) values(31,'运城',23);
insert into location (id,name,fid) values(32,'临汾',23);
insert into location (id,name,fid) values(33,'朔州',23);
insert into location (id,name,fid) values(34,'忻州',23);

insert into location (id,name,fid) values(35,'辽宁',1);

insert into location (id,name,fid) values(36,'沈阳',35);
insert into location (id,name,fid) values(37,'大连',35);
insert into location (id,name,fid) values(38,'鞍山',35);
insert into location (id,name,fid) values(39,'抚顺',35);
insert into location (id,name,fid) values(40,'本溪',35);
insert into location (id,name,fid) values(41,'丹东',35);
insert into location (id,name,fid) values(42,'锦州',35);
insert into location (id,name,fid) values(43,'葫芦岛',35);
insert into location (id,name,fid) values(44,'营口',35);
insert into location (id,name,fid) values(45,'盘锦',35);
insert into location (id,name,fid) values(46,'阜新',35);
insert into location (id,name,fid) values(47,'朝阳',35);
insert into location (id,name,fid) values(48,'辽阳',35);
insert into location (id,name,fid) values(49,'铁岭',35);

insert into location (id,name,fid) values(50,'吉林',1);

insert into location (id,name,fid) values(51,'长春',50);
insert into location (id,name,fid) values(52,'四平',50);
insert into location (id,name,fid) values(53,'辽源',50);
insert into location (id,name,fid) values(54,'通化',50);
insert into location (id,name,fid) values(55,'白山',50);
insert into location (id,name,fid) values(56,'松原',50);
insert into location (id,name,fid) values(57,'白城',50);
insert into location (id,name,fid) values(58,'延边朝鲜族自治州',50);
insert into location (id,name,fid) values(59,'吉林',50);

insert into location (id,name,fid) values(60,'黑龙江',1);

insert into location (id,name,fid) values(61,'哈尔滨',60);
insert into location (id,name,fid) values(62,'齐齐哈尔',60);
insert into location (id,name,fid) values(63,'鹤岗',60);
insert into location (id,name,fid) values(64,'双鸭山',60);
insert into location (id,name,fid) values(65,'鸡西 ',60);
insert into location (id,name,fid) values(66,'大庆',60);
insert into location (id,name,fid) values(67,'伊春',60);
insert into location (id,name,fid) values(68,'牡丹江',60);
insert into location (id,name,fid) values(69,'佳木斯',60);
insert into location (id,name,fid) values(70,'七台河',60);
insert into location (id,name,fid) values(71,'黑河',60);
insert into location (id,name,fid) values(72,'绥化',60);
insert into location (id,name,fid) values(73,'大兴安岭地区',60);

insert into location (id,name,fid) values(74,'江苏',1);

insert into location (id,name,fid) values(75,'南京',74);
insert into location (id,name,fid) values(76,'南通',74);
insert into location (id,name,fid) values(77,'苏州',74);
insert into location (id,name,fid) values(78,'扬州',74);
insert into location (id,name,fid) values(79,'无锡',74);
insert into location (id,name,fid) values(80,'常州',74);
insert into location (id,name,fid) values(81,'淮安',74);
insert into location (id,name,fid) values(82,'盐城',74);
insert into location (id,name,fid) values(83,'宿迁',74);
insert into location (id,name,fid) values(84,'徐州',74);
insert into location (id,name,fid) values(85,'连云港',74);
insert into location (id,name,fid) values(86,'镇江',74);
insert into location (id,name,fid) values(87,'泰州',74);

insert into location (id,name,fid) values(88,'浙江',1);

insert into location (id,name,fid) values(89,'杭州',88);
insert into location (id,name,fid) values(90,'宁波',88);
insert into location (id,name,fid) values(91,'嘉兴',88);
insert into location (id,name,fid) values(92,'绍兴',88);
insert into location (id,name,fid) values(93,'温州',88);
insert into location (id,name,fid) values(94,'义乌',88);
insert into location (id,name,fid) values(95,'金华',88);
insert into location (id,name,fid) values(96,'舟山',88);
insert into location (id,name,fid) values(97,'湖州',88);
insert into location (id,name,fid) values(98,'衢州',88);
insert into location (id,name,fid) values(99,'台州',88);
insert into location (id,name,fid) values(100,'丽水',88);

insert into location (id,name,fid) values(101,'安徽',1);

insert into location (id,name,fid) values(102,'合肥',101);
insert into location (id,name,fid) values(103,'淮南',101);
insert into location (id,name,fid) values(104,'马鞍山',101);
insert into location (id,name,fid) values(105,'淮北',101);
insert into location (id,name,fid) values(106,'安庆',101);
insert into location (id,name,fid) values(107,'黄山',101);
insert into location (id,name,fid) values(108,'阜阳',101);
insert into location (id,name,fid) values(109,'宿州',101);
insert into location (id,name,fid) values(110,'六安',101);
insert into location (id,name,fid) values(111,'毫州',101);
insert into location (id,name,fid) values(112,'池州',101);
insert into location (id,name,fid) values(113,'宣城',101);
insert into location (id,name,fid) values(114,'巢湖',101);
insert into location (id,name,fid) values(115,'芜湖',101);
insert into location (id,name,fid) values(116,'蚌埠',101);
insert into location (id,name,fid) values(117,'铜陵',101);
insert into location (id,name,fid) values(118,'滁州',101);

insert into location (id,name,fid) values(119,'福建',1);

insert into location (id,name,fid) values(120,'福州',119);
insert into location (id,name,fid) values(121,'厦门',119);
insert into location (id,name,fid) values(122,'泉州',119);
insert into location (id,name,fid) values(123,'漳州',119);
insert into location (id,name,fid) values(124,'三明',119);
insert into location (id,name,fid) values(125,'莆田',119);
insert into location (id,name,fid) values(126,'宁德',119);
insert into location (id,name,fid) values(127,'南平',119);
insert into location (id,name,fid) values(128,'龙岩',119);

insert into location (id,name,fid) values(129,'江西',1); 

insert into location (id,name,fid) values(130,'南昌',129);
insert into location (id,name,fid) values(131,'新余',129);
insert into location (id,name,fid) values(132,'庐山',129);
insert into location (id,name,fid) values(133,'景德镇',129);
insert into location (id,name,fid) values(134,'萍乡',129);
insert into location (id,name,fid) values(135,'九江',129);
insert into location (id,name,fid) values(136,'鹰潭',129);
insert into location (id,name,fid) values(137,'赣州',129);
insert into location (id,name,fid) values(138,'吉安',129);
insert into location (id,name,fid) values(139,'宜春',129);
insert into location (id,name,fid) values(140,'抚州',129);
insert into location (id,name,fid) values(141,'上饶',129);

insert into location (id,name,fid) values(142,'山东',1);

insert into location (id,name,fid) values(143,'济南',142);
insert into location (id,name,fid) values(144,'青岛',142);
insert into location (id,name,fid) values(145,'淄博',142);
insert into location (id,name,fid) values(146,'枣庄',142);
insert into location (id,name,fid) values(147,'东营',142);
insert into location (id,name,fid) values(148,'烟台',142);
insert into location (id,name,fid) values(149,'威海',142);
insert into location (id,name,fid) values(150,'济宁',142);
insert into location (id,name,fid) values(151,'泰安',142);
insert into location (id,name,fid) values(152,'日照',142);
insert into location (id,name,fid) values(153,'聊城',142);
insert into location (id,name,fid) values(154,'潍坊',142);
insert into location (id,name,fid) values(155,'莱芜',142);
insert into location (id,name,fid) values(156,'临沂',142);
insert into location (id,name,fid) values(157,'德州',142);
insert into location (id,name,fid) values(158,'滨州',142);
insert into location (id,name,fid) values(159,'菏泽',142);

insert into location (id,name,fid) values(160,'河南',1);

insert into location (id,name,fid) values(161,'郑州',160);
insert into location (id,name,fid) values(162,'开封',160);
insert into location (id,name,fid) values(163,'洛阳',160);
insert into location (id,name,fid) values(164,'平顶山',160);
insert into location (id,name,fid) values(165,'焦作',160);
insert into location (id,name,fid) values(166,'新乡',160);
insert into location (id,name,fid) values(167,'安阳',160);
insert into location (id,name,fid) values(168,'南阳',160);
insert into location (id,name,fid) values(169,'许昌',160);
insert into location (id,name,fid) values(170,'周口',160);
insert into location (id,name,fid) values(171,'鹤壁',160);
insert into location (id,name,fid) values(172,'濮阳',160);
insert into location (id,name,fid) values(173,'漯河',160);
insert into location (id,name,fid) values(174,'三门峡',160);
insert into location (id,name,fid) values(175,'商丘',160);
insert into location (id,name,fid) values(176,'信阳',160);
insert into location (id,name,fid) values(177,'驻马店',160);
insert into location (id,name,fid) values(178,'济源',160);

insert into location (id,name,fid) values(179,'湖北',1);

insert into location (id,name,fid) values(180,'武汉',179);
insert into location (id,name,fid) values(181,'黄石',179);
insert into location (id,name,fid) values(182,'襄樊',179);
insert into location (id,name,fid) values(183,'荆州',179);
insert into location (id,name,fid) values(184,'荆门',179);
insert into location (id,name,fid) values(185,'宜昌',179);
insert into location (id,name,fid) values(186,'孝感',179);
insert into location (id,name,fid) values(187,'天门',179);
insert into location (id,name,fid) values(188,'仙桃',179);
insert into location (id,name,fid) values(189,'潜江',179);
insert into location (id,name,fid) values(190,'十堰',179);
insert into location (id,name,fid) values(191,'鄂州',179);
insert into location (id,name,fid) values(192,'黄冈',179);
insert into location (id,name,fid) values(193,'咸宁',179);
insert into location (id,name,fid) values(194,'随州',179);
insert into location (id,name,fid) values(195,'潜江',179);
insert into location (id,name,fid) values(196,'神农架林区',179);
insert into location (id,name,fid) values(197,'恩施土家族苗族自治州',179);

insert into location (id,name,fid) values(198,'湖南',1);

insert into location (id,name,fid) values(199,'长沙',198);
insert into location (id,name,fid) values(200,'株洲',198);
insert into location (id,name,fid) values(201,'湘潭',198);
insert into location (id,name,fid) values(202,'衡阳',198);
insert into location (id,name,fid) values(203,'邵阳',198);
insert into location (id,name,fid) values(204,'岳阳',198);
insert into location (id,name,fid) values(205,'常德',198);
insert into location (id,name,fid) values(206,'张家界',198);
insert into location (id,name,fid) values(207,'益阳',198);
insert into location (id,name,fid) values(208,'娄底',198);
insert into location (id,name,fid) values(209,'郴州',198);
insert into location (id,name,fid) values(210,'永州',198);
insert into location (id,name,fid) values(211,'怀化',198);
insert into location (id,name,fid) values(212,'湘西土家族苗族自治州',198);

insert into location (id,name,fid) values(213,'广东',1);

insert into location (id,name,fid) values(214,'广州',213);
insert into location (id,name,fid) values(215,'深圳',213);
insert into location (id,name,fid) values(216,'珠海',213);
insert into location (id,name,fid) values(217,'汕头',213);
insert into location (id,name,fid) values(218,'韶关',213);
insert into location (id,name,fid) values(219,'佛山',213);
insert into location (id,name,fid) values(220,'中山',213);
insert into location (id,name,fid) values(221,'江门',213);
insert into location (id,name,fid) values(222,'汕尾',213);
insert into location (id,name,fid) values(223,'东莞',213);
insert into location (id,name,fid) values(224,'河源',213);
insert into location (id,name,fid) values(225,'梅州',213);
insert into location (id,name,fid) values(226,'湛江',213);
insert into location (id,name,fid) values(227,'茂名',213);
insert into location (id,name,fid) values(228,'肇庆',213);
insert into location (id,name,fid) values(229,'惠州',213);
insert into location (id,name,fid) values(230,'阳江',213);
insert into location (id,name,fid) values(231,'清远',213);
insert into location (id,name,fid) values(232,'潮州',213);
insert into location (id,name,fid) values(233,'揭阳',213);
insert into location (id,name,fid) values(234,'云浮',213);

insert into location (id,name,fid) values(235,'甘肃',1);

insert into location (id,name,fid) values(236,'兰州',235);
insert into location (id,name,fid) values(237,'金昌',235);
insert into location (id,name,fid) values(238,'白银',235);
insert into location (id,name,fid) values(239,'天水',235);
insert into location (id,name,fid) values(240,'嘉峪关',235);
insert into location (id,name,fid) values(241,'武威',235);
insert into location (id,name,fid) values(242,'张掖',235);
insert into location (id,name,fid) values(243,'平凉',235);
insert into location (id,name,fid) values(244,'酒泉',235);
insert into location (id,name,fid) values(245,'庆阳',235);
insert into location (id,name,fid) values(246,'定西',235);
insert into location (id,name,fid) values(247,'陇南',235);
insert into location (id,name,fid) values(248,'临夏回族自治州',235);
insert into location (id,name,fid) values(249,'甘南藏族自治州',235);


insert into location (id,name,fid) values(250,'四川',1);

insert into location (id,name,fid) values(251,'成都',250);
insert into location (id,name,fid) values(252,'自贡',250);
insert into location (id,name,fid) values(253,'攀枝花',250);
insert into location (id,name,fid) values(254,'泸州',250);
insert into location (id,name,fid) values(255,'德阳',250);
insert into location (id,name,fid) values(256,'绵阳',250);
insert into location (id,name,fid) values(257,'广元',250);
insert into location (id,name,fid) values(258,'遂宁',250);
insert into location (id,name,fid) values(259,'内江',250);
insert into location (id,name,fid) values(260,'乐山',250);
insert into location (id,name,fid) values(261,'南充',250);
insert into location (id,name,fid) values(262,'眉山',250);
insert into location (id,name,fid) values(263,'宜宾',250);
insert into location (id,name,fid) values(264,'广安',250);
insert into location (id,name,fid) values(265,'达州',250);
insert into location (id,name,fid) values(266,'雅安',250);
insert into location (id,name,fid) values(267,'巴中',250);
insert into location (id,name,fid) values(268,'资阳',250);
insert into location (id,name,fid) values(269,'阿坝藏族羌族自治州',250);
insert into location (id,name,fid) values(270,'甘孜藏族自治州',250);
insert into location (id,name,fid) values(271,'凉山彝族自治州',250);


insert into location (id,name,fid) values(272,'贵州',1);

insert into location (id,name,fid) values(273,'贵阳',272);
insert into location (id,name,fid) values(274,'六盘水',272);
insert into location (id,name,fid) values(275,'遵义',272);
insert into location (id,name,fid) values(276,'安顺',272);
insert into location (id,name,fid) values(277,'铜仁地区',272);
insert into location (id,name,fid) values(278,'毕节地区',272);
insert into location (id,name,fid) values(279,'黔西南布依族苗族自治州',272);
insert into location (id,name,fid) values(280,'黔东南苗族侗族自治州',272);
insert into location (id,name,fid) values(281,'黔南布依族苗族自治州',272);


insert into location (id,name,fid) values(282,'海南',1);

insert into location (id,name,fid) values(283,'海口',282);
insert into location (id,name,fid) values(284,'三亚',282);
insert into location (id,name,fid) values(285,'五指山',282);
insert into location (id,name,fid) values(286,'琼海',282);
insert into location (id,name,fid) values(287,'儋州',282);
insert into location (id,name,fid) values(288,'文昌',282);
insert into location (id,name,fid) values(289,'万宁',282);
insert into location (id,name,fid) values(290,'东方',282);
insert into location (id,name,fid) values(291,'澄迈',282);
insert into location (id,name,fid) values(292,'定安',282);
insert into location (id,name,fid) values(293,'屯昌',282);
insert into location (id,name,fid) values(294,'临高',282);
insert into location (id,name,fid) values(295,'白沙黎族自治县',282);
insert into location (id,name,fid) values(296,'昌江黎族自治县',282);
insert into location (id,name,fid) values(297,'乐东黎族自治县',282);
insert into location (id,name,fid) values(298,'陵水黎族自治县',282);
insert into location (id,name,fid) values(299,'保亭黎族苗族自治县',282);
insert into location (id,name,fid) values(300,'琼中黎族苗族自治县',282);


insert into location (id,name,fid) values(301,'云南',1);

insert into location (id,name,fid) values(302,'昆明',301);
insert into location (id,name,fid) values(303,'曲靖',301);
insert into location (id,name,fid) values(304,'玉溪',301);
insert into location (id,name,fid) values(305,'保山',301);
insert into location (id,name,fid) values(306,'昭通',301);
insert into location (id,name,fid) values(307,'丽江',301);
insert into location (id,name,fid) values(308,'思茅',301);
insert into location (id,name,fid) values(309,'临沧',301);
insert into location (id,name,fid) values(310,'文山壮族苗族自治州',301);
insert into location (id,name,fid) values(311,'红河哈尼族彝族自治州',301);
insert into location (id,name,fid) values(312,'西双版纳傣族自治州',301);
insert into location (id,name,fid) values(313,'楚雄彝族自治州',301);
insert into location (id,name,fid) values(314,'大理白族自治州',301);
insert into location (id,name,fid) values(315,'德宏傣族景颇族自治州',301);
insert into location (id,name,fid) values(316,'怒江傈傈族自治州',301);
insert into location (id,name,fid) values(317,'迪庆藏族自治州',301);


insert into location (id,name,fid) values(318,'青海',1);

insert into location (id,name,fid) values(319,'西宁',318);
insert into location (id,name,fid) values(320,'海东地区',318);
insert into location (id,name,fid) values(321,'海北藏族自治州',318);
insert into location (id,name,fid) values(322,'黄南藏族自治州',318);
insert into location (id,name,fid) values(323,'海南藏族自治州',318);
insert into location (id,name,fid) values(324,'果洛藏族自治州',318);
insert into location (id,name,fid) values(325,'玉树藏族自治州',318);
insert into location (id,name,fid) values(326,'海西蒙古族藏族自治州',318);


insert into location (id,name,fid) values(327,'陕西',1);

insert into location (id,name,fid) values(328,'西安',327);
insert into location (id,name,fid) values(329,'铜川',327);
insert into location (id,name,fid) values(330,'宝鸡',327);
insert into location (id,name,fid) values(331,'咸阳',327);
insert into location (id,name,fid) values(332,'渭南',327);
insert into location (id,name,fid) values(333,'延安',327);
insert into location (id,name,fid) values(344,'汉中',327);
insert into location (id,name,fid) values(345,'榆林',327);
insert into location (id,name,fid) values(346,'安康',327);
insert into location (id,name,fid) values(347,'商洛',327);


insert into location (id,name,fid) values(348,'广西壮族自治区',1);

insert into location (id,name,fid) values(349,'南宁',348);
insert into location (id,name,fid) values(350,'柳州',348);
insert into location (id,name,fid) values(351,'桂林',348);
insert into location (id,name,fid) values(352,'梧州',348);
insert into location (id,name,fid) values(353,'北海',348);
insert into location (id,name,fid) values(354,'防城港',348);
insert into location (id,name,fid) values(355,'钦州',348);
insert into location (id,name,fid) values(356,'贵港',348);
insert into location (id,name,fid) values(357,'玉林',348);
insert into location (id,name,fid) values(358,'百色',348);
insert into location (id,name,fid) values(359,'贺州',348);
insert into location (id,name,fid) values(360,'河池',348);
insert into location (id,name,fid) values(361,'来宾',348);
insert into location (id,name,fid) values(362,'崇左',348);


insert into location (id,name,fid) values(363,'西藏自治区',1);

insert into location (id,name,fid) values(364,'拉萨',363);
insert into location (id,name,fid) values(365,'那曲地区',363);
insert into location (id,name,fid) values(366,'昌都地区',363);
insert into location (id,name,fid) values(367,'山南地区',363);
insert into location (id,name,fid) values(368,'日喀则地区',363);
insert into location (id,name,fid) values(369,'阿里地区',363);
insert into location (id,name,fid) values(370,'林芝地区',363);


insert into location (id,name,fid) values(371,'宁夏回族自治区',1);

insert into location (id,name,fid) values(372,'银川',371);
insert into location (id,name,fid) values(373,'石嘴山',371);
insert into location (id,name,fid) values(374,'吴忠',371);
insert into location (id,name,fid) values(375,'固原',371);
insert into location (id,name,fid) values(376,'中卫',371);


insert into location (id,name,fid) values(377,'新疆维吾尔自治区',1);

insert into location (id,name,fid) values(378,'乌鲁木齐',377);
insert into location (id,name,fid) values(379,'克拉玛依',377);
insert into location (id,name,fid) values(380,'石河子',377);
insert into location (id,name,fid) values(381,'阿拉尔',377);
insert into location (id,name,fid) values(382,'图木舒克',377);
insert into location (id,name,fid) values(383,'五家渠',377);
insert into location (id,name,fid) values(384,'吐鲁番',377);
insert into location (id,name,fid) values(385,'阿克苏',377);
insert into location (id,name,fid) values(386,'喀什',377);
insert into location (id,name,fid) values(387,'哈密',377);
insert into location (id,name,fid) values(388,'和田',377);
insert into location (id,name,fid) values(389,'阿图什',377);
insert into location (id,name,fid) values(390,'库尔勒',377);
insert into location (id,name,fid) values(391,'昌吉',377);
insert into location (id,name,fid) values(392,'阜康',377);
insert into location (id,name,fid) values(393,'米泉',377);
insert into location (id,name,fid) values(394,'博乐',377);
insert into location (id,name,fid) values(395,'伊宁',377);
insert into location (id,name,fid) values(396,'奎屯',377);
insert into location (id,name,fid) values(397,'塔城',377);
insert into location (id,name,fid) values(398,'乌苏',377);
insert into location (id,name,fid) values(399,'阿勒泰',377);


insert into location (id,name,fid) values(400,'内蒙古自治区',1);

insert into location (id,name,fid) values(401,'呼和浩特',400);
insert into location (id,name,fid) values(402,'包头',400);
insert into location (id,name,fid) values(403,'乌海',400);
insert into location (id,name,fid) values(404,'赤峰',400);
insert into location (id,name,fid) values(405,'通辽',400);
insert into location (id,name,fid) values(406,'鄂尔多斯',400);
insert into location (id,name,fid) values(407,'呼伦贝尔',400);
insert into location (id,name,fid) values(408,'巴彦卓尔',400);
insert into location (id,name,fid) values(409,'兴安盟',400);
insert into location (id,name,fid) values(410,'乌兰察布',400);
insert into location (id,name,fid) values(411,'锡林郭勒盟',400);
insert into location (id,name,fid) values(412,'阿拉善盟',400);


insert into location (id,name,fid) values(413,'台湾省',1);

insert into location (id,name,fid) values(414,'台北',413);
insert into location (id,name,fid) values(415,'高雄',413);
insert into location (id,name,fid) values(416,'基隆',413);
insert into location (id,name,fid) values(417,'台中',413);
insert into location (id,name,fid) values(418,'台南',413);
insert into location (id,name,fid) values(419,'新竹',413);
insert into location (id,name,fid) values(420,'嘉义',413);
insert into location (id,name,fid) values(421,'台北县',413);
insert into location (id,name,fid) values(422,'宜兰县',413);
insert into location (id,name,fid) values(423,'桃园县',413);
insert into location (id,name,fid) values(424,'新竹县',413);
insert into location (id,name,fid) values(425,'苗栗县',413);
insert into location (id,name,fid) values(426,'台中县',413);
insert into location (id,name,fid) values(427,'彰化县',413);
insert into location (id,name,fid) values(428,'南投县',413);
insert into location (id,name,fid) values(429,'云林县',413);
insert into location (id,name,fid) values(430,'嘉义县',413);
insert into location (id,name,fid) values(431,'台南县',413);
insert into location (id,name,fid) values(432,'高雄县',413);
insert into location (id,name,fid) values(433,'屏东县',413);
insert into location (id,name,fid) values(434,'澎湖县',413);
insert into location (id,name,fid) values(435,'台东县',413);
insert into location (id,name,fid) values(436,'花莲县',413);

update location set id=id-10 where id>333;
update location set fid=fid-10 where id>338 and fid>1;
update location set id=id+4 where id>5;
insert into location (id,name,fid) values(6,'天津',1);
insert into location (id,name,fid) values(7,'天津',6);
insert into location (id,name,fid) values(8,'重庆',1);
insert into location (id,name,fid) values(9,'重庆',8);
update location set fid=fid+4 where id>9 and fid>1;