??? SQL腳本。原po建表思路很不錯，有點像沒優(yōu)化的并查集的感覺，我略作修改，在這里謝過了。建表語句就不寫了，手動也可吧，表名location，一共426條記錄，包括1個根節(jié)點中國，34個省、直轄市和行政特區(qū)，其余為地級市（臺灣到縣），id可作主鍵，name不超過15個字符，fid可做外鍵引用主鍵id，只有根節(jié)點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,'香港特別行政區(qū)',1); insert into location (id,name,fid) values(7,'香港特別行政區(qū)',6);insert into location (id,name,fid) values(8,'澳門特別行政區(qū)',1); insert into location (id,name,fid) values(9,'澳門特別行政區(qū)',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,'大興安嶺地區(qū)',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,'鎮(zhèn)江',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,'景德鎮(zhèn)',129); insert into location (id,name,fid) values(134,'萍鄉(xiāng)',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,'新鄉(xiāng)',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,'神農(nóng)架林區(qū)',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,'韶關(guān)',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,'嘉峪關(guān)',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,'平?jīng)?#39;,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,'內(nèi)江',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,'銅仁地區(qū)',272); insert into location (id,name,fid) values(278,'畢節(jié)地區(qū)',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,'海東地區(qū)',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,'廣西壯族自治區(qū)',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,'西藏自治區(qū)',1);insert into location (id,name,fid) values(364,'拉薩',363); insert into location (id,name,fid) values(365,'那曲地區(qū)',363); insert into location (id,name,fid) values(366,'昌都地區(qū)',363); insert into location (id,name,fid) values(367,'山南地區(qū)',363); insert into location (id,name,fid) values(368,'日喀則地區(qū)',363); insert into location (id,name,fid) values(369,'阿里地區(qū)',363); insert into location (id,name,fid) values(370,'林芝地區(qū)',363);insert into location (id,name,fid) values(371,'寧夏回族自治區(qū)',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,'中衛(wèi)',371);insert into location (id,name,fid) values(377,'新疆維吾爾自治區(qū)',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,'內(nèi)蒙古自治區(qū)',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;

總結(jié)

以上是生活随笔為你收集整理的复用数据库之中国地区表（除台湾外精确到地级市）的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。