SQL怎么约束仅限全国34个省市的取值
发布网友
发布时间：2022-04-08 03:47
共2个回答
懂视网
时间：2022-04-08 08:08
CREATE TABLE [dbo].[region](
[region_id] [int] NULL,
[region_name] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[parend_id] [int] NULL,
[sort_id] [int] NULL,
[region_mome] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
INSERT INTO REGION (region_id,region_name,sort_id,region_mome) VALUES(2,‘北京市‘,1,‘直辖市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(3,‘北京市‘,2,1,‘北京市-北京市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(4,‘东城区‘,3,1,‘北京市-北京市-东城区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(5,‘西城区‘,3,2,‘北京市-北京市-西城区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(6,‘崇文区‘,3,3,‘北京市-北京市-崇文区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(7,‘宣武区‘,3,4,‘北京市-北京市-宣武区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(8,‘朝阳区‘,3,5,‘北京市-北京市-朝阳区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(9,‘丰台区‘,3,6,‘北京市-北京市-丰台区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(10,‘石景山区‘,3,7,‘北京市-北京市-石景山区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(11,‘海淀区‘,3,8,‘北京市-北京市-海淀区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(12,‘门头沟区‘,3,9,‘北京市-北京市-门头沟区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(13,‘房山区‘,3,10,‘北京市-北京市-房山区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(14,‘通州区‘,3,11,‘北京市-北京市-通州区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(15,‘顺义区‘,3,12,‘北京市-北京市-顺义区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(16,‘昌平区‘,3,13,‘北京市-北京市-昌平区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(17,‘大兴区‘,3,14,‘北京市-北京市-大兴区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(18,‘怀柔区‘,3,15,‘北京市-北京市-怀柔区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(19,‘平谷区‘,3,16,‘北京市-北京市-平谷区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(20,‘密云县‘,3,17,‘北京市-北京市-密云县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(21,‘延庆县‘,3,18,‘北京市-北京市-延庆县‘)
INSERT INTO REGION (region_id,region_name,sort_id,region_mome) VALUES(22,‘天津市‘,2,‘直辖市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(23,‘天津市‘,22,1,‘天津市-天津市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(24,‘和平区‘,23,1,‘天津市-天津市-和平区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(25,‘河东区‘,23,2,‘天津市-天津市-河东区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(26,‘河西区‘,23,3,‘天津市-天津市-河西区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(27,‘南开区‘,23,4,‘天津市-天津市-南开区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(28,‘河北区‘,23,5,‘天津市-天津市-河北区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(29,‘红桥区‘,23,6,‘天津市-天津市-红桥区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(30,‘塘沽区‘,23,7,‘天津市-天津市-塘沽区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(31,‘汉沽区‘,23,8,‘天津市-天津市-汉沽区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(32,‘大港区‘,23,9,‘天津市-天津市-大港区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(33,‘东丽区‘,23,10,‘天津市-天津市-东丽区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(34,‘西青区‘,23,11,‘天津市-天津市-西青区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(35,‘津南区‘,23,12,‘天津市-天津市-津南区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(36,‘北辰区‘,23,13,‘天津市-天津市-北辰区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(37,‘武清区‘,23,14,‘天津市-天津市-武清区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(38,‘宝坻区‘,23,15,‘天津市-天津市-宝坻区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(39,‘宁河县‘,23,16,‘天津市-天津市-宁河县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(40,‘静海县‘,23,17,‘天津市-天津市-静海县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(41,‘蓟县‘,23,18,‘天津市-天津市-蓟县‘)
INSERT INTO REGION (region_id,region_name,sort_id,region_mome) VALUES(42,‘河北省‘,5,‘省份‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(43,‘邯郸市‘,42,1,‘河北省-邯郸市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(44,‘邯山区‘,43,1,‘河北省-邯郸市-邯山区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(45,‘丛台区‘,43,2,‘河北省-邯郸市-丛台区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(46,‘复兴区‘,43,3,‘河北省-邯郸市-复兴区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(47,‘峰峰矿区‘,43,4,‘河北省-邯郸市-峰峰矿区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(48,‘邯郸县‘,43,5,‘河北省-邯郸市-邯郸县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(49,‘临漳县‘,43,6,‘河北省-邯郸市-临漳县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(50,‘成安县‘,43,7,‘河北省-邯郸市-成安县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(51,‘大名县‘,43,8,‘河北省-邯郸市-大名县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(52,‘涉县‘,43,9,‘河北省-邯郸市-涉县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(53,‘磁县‘,43,10,‘河北省-邯郸市-磁县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(54,‘肥乡县‘,43,11,‘河北省-邯郸市-肥乡县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(55,‘永年县‘,43,12,‘河北省-邯郸市-永年县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(56,‘邱县‘,43,13,‘河北省-邯郸市-邱县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(57,‘鸡泽县‘,43,14,‘河北省-邯郸市-鸡泽县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(58,‘广平县‘,43,15,‘河北省-邯郸市-广平县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(59,‘馆陶县‘,43,16,‘河北省-邯郸市-馆陶县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(60,‘魏县‘,43,17,‘河北省-邯郸市-魏县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(61,‘曲周县‘,43,18,‘河北省-邯郸市-曲周县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(62,‘武安市‘,43,19,‘河北省-邯郸市-武安市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(63,‘石家庄市‘,42,2,‘河北省-石家庄市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(64,‘长安区‘,63,1,‘河北省-石家庄市-长安区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(65,‘桥东区‘,63,2,‘河北省-石家庄市-桥东区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(66,‘桥西区‘,63,3,‘河北省-石家庄市-桥西区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(67,‘新华区‘,63,4,‘河北省-石家庄市-新华区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(68,‘井陉矿区‘,63,5,‘河北省-石家庄市-井陉矿区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(69,‘裕华区‘,63,6,‘河北省-石家庄市-裕华区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(70,‘井陉县‘,63,7,‘河北省-石家庄市-井陉县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(71,‘正定县‘,63,8,‘河北省-石家庄市-正定县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(72,‘栾城县‘,63,9,‘河北省-石家庄市-栾城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(73,‘行唐县‘,63,10,‘河北省-石家庄市-行唐县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(74,‘灵寿县‘,63,11,‘河北省-石家庄市-灵寿县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(75,‘高邑县‘,63,12,‘河北省-石家庄市-高邑县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(76,‘深泽县‘,63,13,‘河北省-石家庄市-深泽县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(77,‘赞皇县‘,63,14,‘河北省-石家庄市-赞皇县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(78,‘无极县‘,63,15,‘河北省-石家庄市-无极县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(79,‘平山县‘,63,16,‘河北省-石家庄市-平山县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(80,‘元氏县‘,63,17,‘河北省-石家庄市-元氏县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(81,‘赵县‘,63,18,‘河北省-石家庄市-赵县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(82,‘辛集市‘,63,19,‘河北省-石家庄市-辛集市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(83,‘藁城市‘,63,20,‘河北省-石家庄市-藁城市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(84,‘晋州市‘,63,21,‘河北省-石家庄市-晋州市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(85,‘新乐市‘,63,22,‘河北省-石家庄市-新乐市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(86,‘鹿泉市‘,63,23,‘河北省-石家庄市-鹿泉市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(87,‘保定市‘,42,3,‘河北省-保定市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(88,‘新市区‘,87,1,‘河北省-保定市-新市区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(89,‘北市区‘,87,2,‘河北省-保定市-北市区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(90,‘南市区‘,87,3,‘河北省-保定市-南市区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(91,‘满城县‘,87,4,‘河北省-保定市-满城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(92,‘清苑县‘,87,5,‘河北省-保定市-清苑县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(93,‘涞水县‘,87,6,‘河北省-保定市-涞水县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(94,‘阜平县‘,87,7,‘河北省-保定市-阜平县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(95,‘徐水县‘,87,8,‘河北省-保定市-徐水县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(96,‘定兴县‘,87,9,‘河北省-保定市-定兴县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(97,‘唐县‘,87,10,‘河北省-保定市-唐县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(98,‘高阳县‘,87,11,‘河北省-保定市-高阳县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(99,‘容城县‘,87,12,‘河北省-保定市-容城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(100,‘涞源县‘,87,13,‘河北省-保定市-涞源县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(101,‘望都县‘,87,14,‘河北省-保定市-望都县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(102,‘安新县‘,87,15,‘河北省-保定市-安新县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(103,‘易县‘,87,16,‘河北省-保定市-易县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(104,‘曲阳县‘,87,17,‘河北省-保定市-曲阳县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(105,‘蠡县‘,87,18,‘河北省-保定市-蠡县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(106,‘顺平县‘,87,19,‘河北省-保定市-顺平县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(107,‘博野县‘,87,20,‘河北省-保定市-博野县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(108,‘雄县‘,87,21,‘河北省-保定市-雄县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(109,‘涿州市‘,87,22,‘河北省-保定市-涿州市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(110,‘定州市‘,87,23,‘河北省-保定市-定州市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(111,‘安国市‘,87,24,‘河北省-保定市-安国市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(112,‘高碑店市‘,87,25,‘河北省-保定市-高碑店市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(113,‘张家口市‘,42,4,‘河北省-张家口市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(114,‘桥东区‘,113,1,‘河北省-张家口市-桥东区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(115,‘桥西区‘,113,2,‘河北省-张家口市-桥西区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(116,‘宣化区‘,113,3,‘河北省-张家口市-宣化区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(117,‘下花园区‘,113,4,‘河北省-张家口市-下花园区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(118,‘宣化县‘,113,5,‘河北省-张家口市-宣化县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(119,‘张北县‘,113,6,‘河北省-张家口市-张北县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(120,‘康保县‘,113,7,‘河北省-张家口市-康保县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(121,‘沽源县‘,113,8,‘河北省-张家口市-沽源县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(122,‘尚义县‘,113,9,‘河北省-张家口市-尚义县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(123,‘蔚县‘,113,10,‘河北省-张家口市-蔚县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(124,‘阳原县‘,113,11,‘河北省-张家口市-阳原县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(125,‘怀安县‘,113,12,‘河北省-张家口市-怀安县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(126,‘万全县‘,113,13,‘河北省-张家口市-万全县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(127,‘怀来县‘,113,14,‘河北省-张家口市-怀来县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(128,‘涿鹿县‘,113,15,‘河北省-张家口市-涿鹿县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(129,‘赤城县‘,113,16,‘河北省-张家口市-赤城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(130,‘崇礼县‘,113,17,‘河北省-张家口市-崇礼县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(131,‘承德市‘,42,5,‘河北省-承德市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(132,‘双桥区‘,131,1,‘河北省-承德市-双桥区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(133,‘双滦区‘,131,2,‘河北省-承德市-双滦区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(134,‘鹰手营子矿区‘,131,3,‘河北省-承德市-鹰手营子矿区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(135,‘承德县‘,131,4,‘河北省-承德市-承德县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(136,‘兴隆县‘,131,5,‘河北省-承德市-兴隆县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(137,‘平泉县‘,131,6,‘河北省-承德市-平泉县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(138,‘滦平县‘,131,7,‘河北省-承德市-滦平县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(139,‘隆化县‘,131,8,‘河北省-承德市-隆化县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(140,‘丰宁满族自治县‘,131,9,‘河北省-承德市-丰宁满族自治县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(141,‘宽城满族自治县‘,131,10,‘河北省-承德市-宽城满族自治县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(142,‘围场满族蒙古族自治县‘,131,11,‘河北省-承德市-围场满族蒙古族自治县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(143,‘唐山市‘,42,6,‘河北省-唐山市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(144,‘路南区‘,143,1,‘河北省-唐山市-路南区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(145,‘路北区‘,143,2,‘河北省-唐山市-路北区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(146,‘古冶区‘,143,3,‘河北省-唐山市-古冶区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(147,‘开平区‘,143,4,‘河北省-唐山市-开平区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(148,‘丰南区‘,143,5,‘河北省-唐山市-丰南区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(149,‘丰润区‘,143,6,‘河北省-唐山市-丰润区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(150,‘滦县‘,143,7,‘河北省-唐山市-滦县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(151,‘滦南县‘,143,8,‘河北省-唐山市-滦南县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(152,‘乐亭县‘,143,9,‘河北省-唐山市-乐亭县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(153,‘迁西县‘,143,10,‘河北省-唐山市-迁西县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(154,‘玉田县‘,143,11,‘河北省-唐山市-玉田县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(155,‘唐海县‘,143,12,‘河北省-唐山市-唐海县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(156,‘遵化市‘,143,13,‘河北省-唐山市-遵化市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(157,‘迁安市‘,143,14,‘河北省-唐山市-迁安市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(158,‘廊坊市‘,42,7,‘河北省-廊坊市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(159,‘安次区‘,158,1,‘河北省-廊坊市-安次区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(160,‘广阳区‘,158,2,‘河北省-廊坊市-广阳区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(161,‘固安县‘,158,3,‘河北省-廊坊市-固安县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(162,‘永清县‘,158,4,‘河北省-廊坊市-永清县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(163,‘香河县‘,158,5,‘河北省-廊坊市-香河县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(164,‘大城县‘,158,6,‘河北省-廊坊市-大城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(165,‘文安县‘,158,7,‘河北省-廊坊市-文安县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(166,‘大厂回族自治县‘,158,8,‘河北省-廊坊市-大厂回族自治县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(167,‘霸州市‘,158,9,‘河北省-廊坊市-霸州市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(168,‘三河市‘,158,10,‘河北省-廊坊市-三河市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(169,‘沧州市‘,42,8,‘河北省-沧州市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(170,‘新华区‘,169,1,‘河北省-沧州市-新华区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(171,‘运河区‘,169,2,‘河北省-沧州市-运河区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(172,‘沧县‘,169,3,‘河北省-沧州市-沧县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(173,‘青县‘,169,4,‘河北省-沧州市-青县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(174,‘东光县‘,169,5,‘河北省-沧州市-东光县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(175,‘海兴县‘,169,6,‘河北省-沧州市-海兴县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(176,‘盐山县‘,169,7,‘河北省-沧州市-盐山县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(177,‘肃宁县‘,169,8,‘河北省-沧州市-肃宁县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(178,‘南皮县‘,169,9,‘河北省-沧州市-南皮县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(179,‘吴桥县‘,169,10,‘河北省-沧州市-吴桥县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(180,‘献县‘,169,11,‘河北省-沧州市-献县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(181,‘孟村回族自治县‘,169,12,‘河北省-沧州市-孟村回族自治县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(182,‘泊头市‘,169,13,‘河北省-沧州市-泊头市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(183,‘任丘市‘,169,14,‘河北省-沧州市-任丘市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(184,‘黄骅市‘,169,15,‘河北省-沧州市-黄骅市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(185,‘河间市‘,169,16,‘河北省-沧州市-河间市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(186,‘衡水市‘,42,9,‘河北省-衡水市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(187,‘桃城区‘,186,1,‘河北省-衡水市-桃城区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(188,‘枣强县‘,186,2,‘河北省-衡水市-枣强县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(189,‘武邑县‘,186,3,‘河北省-衡水市-武邑县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(190,‘武强县‘,186,4,‘河北省-衡水市-武强县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(191,‘饶阳县‘,186,5,‘河北省-衡水市-饶阳县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(192,‘安平县‘,186,6,‘河北省-衡水市-安平县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(193,‘故城县‘,186,7,‘河北省-衡水市-故城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(194,‘景县‘,186,8,‘河北省-衡水市-景县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(195,‘阜城县‘,186,9,‘河北省-衡水市-阜城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(196,‘冀州市‘,186,10,‘河北省-衡水市-冀州市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(197,‘深州市‘,186,11,‘河北省-衡水市-深州市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(198,‘邢台市‘,42,10,‘河北省-邢台市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(199,‘桥东区‘,198,1,‘河北省-邢台市-桥东区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(200,‘桥西区‘,198,2,‘河北省-邢台市-桥西区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(201,‘邢台县‘,198,3,‘河北省-邢台市-邢台县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(202,‘临城县‘,198,4,‘河北省-邢台市-临城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(203,‘内丘县‘,198,5,‘河北省-邢台市-内丘县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(204,‘柏乡县‘,198,6,‘河北省-邢台市-柏乡县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(205,‘隆尧县‘,198,7,‘河北省-邢台市-隆尧县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(206,‘任县‘,198,8,‘河北省-邢台市-任县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(207,‘南和县‘,198,9,‘河北省-邢台市-南和县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(208,‘宁晋县‘,198,10,‘河北省-邢台市-宁晋县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(209,‘巨鹿县‘,198,11,‘河北省-邢台市-巨鹿县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(210,‘新河县‘,198,12,‘河北省-邢台市-新河县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(211,‘广宗县‘,198,13,‘河北省-邢台市-广宗县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(212,‘平乡县‘,198,14,‘河北省-邢台市-平乡县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(213,‘威县‘,198,15,‘河北省-邢台市-威县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(214,‘清河县‘,198,16,‘河北省-邢台市-清河县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(215,‘临西县‘,198,17,‘河北省-邢台市-临西县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(216,‘南宫市‘,198,18,‘河北省-邢台市-南宫市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(217,‘沙河市‘,198,19,‘河北省-邢台市-沙河市‘)
INSERT INTO REGION (region_id,region_name,sort_id,region_mome) VALUES(218,‘山西省‘,6,‘省份‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(219,‘朔州市‘,218,1,‘山西省-朔州市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(220,‘朔城区‘,219,1,‘山西省-朔州市-朔城区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(221,‘平鲁区‘,219,2,‘山西省-朔州市-平鲁区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(222,‘山阴县‘,219,3,‘山西省-朔州市-山阴县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(223,‘应县‘,219,4,‘山西省-朔州市-应县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(224,‘右玉县‘,219,5,‘山西省-朔州市-右玉县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(225,‘怀仁县‘,219,6,‘山西省-朔州市-怀仁县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(226,‘忻州市‘,218,2,‘山西省-忻州市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(227,‘忻府区‘,226,1,‘山西省-忻州市-忻府区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(228,‘定襄县‘,226,2,‘山西省-忻州市-定襄县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(229,‘五台县‘,226,3,‘山西省-忻州市-五台县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(230,‘代县‘,226,4,‘山西省-忻州市-代县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(231,‘繁峙县‘,226,5,‘山西省-忻州市-繁峙县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(232,‘宁武县‘,226,6,‘山西省-忻州市-宁武县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(233,‘静乐县‘,226,7,‘山西省-忻州市-静乐县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(234,‘神池县‘,226,8,‘山西省-忻州市-神池县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(235,‘五寨县‘,226,9,‘山西省-忻州市-五寨县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(236,‘岢岚县‘,226,10,‘山西省-忻州市-岢岚县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(237,‘河曲县‘,226,11,‘山西省-忻州市-河曲县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(238,‘保德县‘,226,12,‘山西省-忻州市-保德县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(239,‘偏关县‘,226,13,‘山西省-忻州市-偏关县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(240,‘原平市‘,226,14,‘山西省-忻州市-原平市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(241,‘太原市‘,218,3,‘山西省-太原市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(242,‘小店区‘,241,1,‘山西省-太原市-小店区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(243,‘迎泽区‘,241,2,‘山西省-太原市-迎泽区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(244,‘杏花岭区‘,241,3,‘山西省-太原市-杏花岭区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(245,‘尖草坪区‘,241,4,‘山西省-太原市-尖草坪区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(246,‘万柏林区‘,241,5,‘山西省-太原市-万柏林区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(247,‘晋源区‘,241,6,‘山西省-太原市-晋源区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(248,‘清徐县‘,241,7,‘山西省-太原市-清徐县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(249,‘阳曲县‘,241,8,‘山西省-太原市-阳曲县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(250,‘娄烦县‘,241,9,‘山西省-太原市-娄烦县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(251,‘古交市‘,241,10,‘山西省-太原市-古交市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(252,‘大同市‘,218,4,‘山西省-大同市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(253,‘矿区‘,252,1,‘山西省-大同市-矿区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(254,‘南郊区‘,252,2,‘山西省-大同市-南郊区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(255,‘新荣区‘,252,3,‘山西省-大同市-新荣区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(256,‘阳高县‘,252,4,‘山西省-大同市-阳高县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(257,‘天镇县‘,252,5,‘山西省-大同市-天镇县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(258,‘广灵县‘,252,6,‘山西省-大同市-广灵县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(259,‘灵丘县‘,252,7,‘山西省-大同市-灵丘县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(260,‘浑源县‘,252,8,‘山西省-大同市-浑源县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(261,‘左云县‘,252,9,‘山西省-大同市-左云县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(262,‘大同县‘,252,10,‘山西省-大同市-大同县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(263,‘阳泉市‘,218,5,‘山西省-阳泉市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(264,‘矿区‘,263,1,‘山西省-阳泉市-矿区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(265,‘平定县‘,263,2,‘山西省-阳泉市-平定县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(266,‘盂县‘,263,3,‘山西省-阳泉市-盂县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(267,‘晋中市‘,218,6,‘山西省-晋中市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(268,‘榆次区‘,267,1,‘山西省-晋中市-榆次区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(269,‘榆社县‘,267,2,‘山西省-晋中市-榆社县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(270,‘左权县‘,267,3,‘山西省-晋中市-左权县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(271,‘和顺县‘,267,4,‘山西省-晋中市-和顺县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(272,‘昔阳县‘,267,5,‘山西省-晋中市-昔阳县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(273,‘寿阳县‘,267,6,‘山西省-晋中市-寿阳县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(274,‘太谷县‘,267,7,‘山西省-晋中市-太谷县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(275,‘祁县‘,267,8,‘山西省-晋中市-祁县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(276,‘平遥县‘,267,9,‘山西省-晋中市-平遥县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(277,‘灵石县‘,267,10,‘山西省-晋中市-灵石县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(278,‘介休市‘,267,11,‘山西省-晋中市-介休市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(279,‘长治市‘,218,7,‘山西省-长治市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(280,‘长治县‘,279,1,‘山西省-长治市-长治县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(281,‘襄垣县‘,279,2,‘山西省-长治市-襄垣县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(282,‘屯留县‘,279,3,‘山西省-长治市-屯留县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(283,‘平顺县‘,279,4,‘山西省-长治市-平顺县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(284,‘黎城县‘,279,5,‘山西省-长治市-黎城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(285,‘壶关县‘,279,6,‘山西省-长治市-壶关县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(286,‘长子县‘,279,7,‘山西省-长治市-长子县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(287,‘武乡县‘,279,8,‘山西省-长治市-武乡县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(288,‘沁县‘,279,9,‘山西省-长治市-沁县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(289,‘沁源县‘,279,10,‘山西省-长治市-沁源县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(290,‘潞城市‘,279,11,‘山西省-长治市-潞城市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(291,‘晋城市‘,218,8,‘山西省-晋城市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(292,‘沁水县‘,291,1,‘山西省-晋城市-沁水县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(293,‘阳城县‘,291,2,‘山西省-晋城市-阳城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(294,‘陵川县‘,291,3,‘山西省-晋城市-陵川县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(295,‘泽州县‘,291,4,‘山西省-晋城市-泽州县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(296,‘高平市‘,291,5,‘山西省-晋城市-高平市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(297,‘临汾市‘,218,9,‘山西省-临汾市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(298,‘尧都区‘,297,1,‘山西省-临汾市-尧都区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(299,‘曲沃县‘,297,2,‘山西省-临汾市-曲沃县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(300,‘翼城县‘,297,3,‘山西省-临汾市-翼城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(301,‘襄汾县‘,297,4,‘山西省-临汾市-襄汾县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(302,‘洪洞县‘,297,5,‘山西省-临汾市-洪洞县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(303,‘古县‘,297,6,‘山西省-临汾市-古县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(304,‘安泽县‘,297,7,‘山西省-临汾市-安泽县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(305,‘浮山县‘,297,8,‘山西省-临汾市-浮山县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(306,‘吉县‘,297,9,‘山西省-临汾市-吉县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(307,‘乡宁县‘,297,10,‘山西省-临汾市-乡宁县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(308,‘大宁县‘,297,11,‘山西省-临汾市-大宁县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(309,‘隰县‘,297,12,‘山西省-临汾市-隰县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(310,‘永和县‘,297,13,‘山西省-临汾市-永和县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(311,‘蒲县‘,297,14,‘山西省-临汾市-蒲县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(312,‘汾西县‘,297,15,‘山西省-临汾市-汾西县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(313,‘侯马市‘,297,16,‘山西省-临汾市-侯马市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(314,‘霍州市‘,297,17,‘山西省-临汾市-霍州市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(315,‘吕梁市‘,218,10,‘山西省-吕梁市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(316,‘离石区‘,315,1,‘山西省-吕梁市-离石区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(317,‘文水县‘,315,2,‘山西省-吕梁市-文水县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(318,‘交城县‘,315,3,‘山西省-吕梁市-交城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(319,‘兴县‘,315,4,‘山西省-吕梁市-兴县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(320,‘临县‘,315,5,‘山西省-吕梁市-临县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(321,‘柳林县‘,315,6,‘山西省-吕梁市-柳林县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(322,‘石楼县‘,315,7,‘山西省-吕梁市-石楼县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(323,‘岚县‘,315,8,‘山西省-吕梁市-岚县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(324,‘方山县‘,315,9,‘山西省-吕梁市-方山县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(325,‘中阳县‘,315,10,‘山西省-吕梁市-中阳县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(326,‘交口县‘,315,11,‘山西省-吕梁市-交口县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(327,‘孝义市‘,315,12,‘山西省-吕梁市-孝义市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(328,‘汾阳市‘,315,13,‘山西省-吕梁市-汾阳市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(329,‘运城市‘,218,11,‘山西省-运城市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(330,‘盐湖区‘,329,1,‘山西省-运城市-盐湖区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(331,‘临猗县‘,329,2,‘山西省-运城市-临猗县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(332,‘万荣县‘,329,3,‘山西省-运城市-万荣县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(333,‘闻喜县‘,329,4,‘山西省-运城市-闻喜县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(334,‘稷山县‘,329,5,‘山西省-运城市-稷山县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(335,‘新绛县‘,329,6,‘山西省-运城市-新绛县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(336,‘绛县‘,329,7,‘山西省-运城市-绛县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(337,‘垣曲县‘,329,8,‘山西省-运城市-垣曲县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(338,‘夏县‘,329,9,‘山西省-运城市-夏县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(339,‘平陆县‘,329,10,‘山西省-运城市-平陆县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(340,‘芮城县‘,329,11,‘山西省-运城市-芮城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(341,‘永济市‘,329,12,‘山西省-运城市-永济市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(342,‘河津市‘,329,13,‘山西省-运城市-河津市‘)
INSERT INTO REGION (region_id,region_name,sort_id,region_mome) VALUES(343,‘内蒙古自治区‘,32,‘自治区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(344,‘呼伦贝尔市‘,343,1,‘内蒙古自治区-呼伦贝尔市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(345,‘海拉尔区‘,344,1,‘内蒙古自治区-呼伦贝尔市-海拉尔区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(346,‘阿荣旗‘,344,2,‘内蒙古自治区-呼伦贝尔市-阿荣旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(347,‘莫力达瓦达斡尔族自治旗‘,344,3,‘内蒙古自治区-呼伦贝尔市-莫力达瓦达斡尔族自治旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(348,‘鄂伦春自治旗‘,344,4,‘内蒙古自治区-呼伦贝尔市-鄂伦春自治旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(349,‘鄂温克族自治旗‘,344,5,‘内蒙古自治区-呼伦贝尔市-鄂温克族自治旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(350,‘陈巴尔虎旗‘,344,6,‘内蒙古自治区-呼伦贝尔市-陈巴尔虎旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(351,‘新巴尔虎左旗‘,344,7,‘内蒙古自治区-呼伦贝尔市-新巴尔虎左旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(352,‘新巴尔虎右旗‘,344,8,‘内蒙古自治区-呼伦贝尔市-新巴尔虎右旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(353,‘满洲里市‘,344,9,‘内蒙古自治区-呼伦贝尔市-满洲里市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(354,‘牙克石市‘,344,10,‘内蒙古自治区-呼伦贝尔市-牙克石市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(355,‘扎兰屯市‘,344,11,‘内蒙古自治区-呼伦贝尔市-扎兰屯市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(356,‘额尔古纳市‘,344,12,‘内蒙古自治区-呼伦贝尔市-额尔古纳市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(357,‘根河市‘,344,13,‘内蒙古自治区-呼伦贝尔市-根河市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(358,‘呼和浩特市‘,343,2,‘内蒙古自治区-呼和浩特市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(359,‘新城区‘,358,1,‘内蒙古自治区-呼和浩特市-新城区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(360,‘回民区‘,358,2,‘内蒙古自治区-呼和浩特市-回民区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(361,‘玉泉区‘,358,3,‘内蒙古自治区-呼和浩特市-玉泉区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(362,‘赛罕区‘,358,4,‘内蒙古自治区-呼和浩特市-赛罕区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(363,‘土默特左旗‘,358,5,‘内蒙古自治区-呼和浩特市-土默特左旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(364,‘托克托县‘,358,6,‘内蒙古自治区-呼和浩特市-托克托县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(365,‘和林格尔县‘,358,7,‘内蒙古自治区-呼和浩特市-和林格尔县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(366,‘清水河县‘,358,8,‘内蒙古自治区-呼和浩特市-清水河县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(367,‘武川县‘,358,9,‘内蒙古自治区-呼和浩特市-武川县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(368,‘包头市‘,343,3,‘内蒙古自治区-包头市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(369,‘东河区‘,368,1,‘内蒙古自治区-包头市-东河区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(370,‘昆都仑区‘,368,2,‘内蒙古自治区-包头市-昆都仑区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(371,‘青山区‘,368,3,‘内蒙古自治区-包头市-青山区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(372,‘石拐区‘,368,4,‘内蒙古自治区-包头市-石拐区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(373,‘白云鄂博矿区‘,368,5,‘内蒙古自治区-包头市-白云鄂博矿区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(374,‘九原区‘,368,6,‘内蒙古自治区-包头市-九原区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(375,‘土默特右旗‘,368,7,‘内蒙古自治区-包头市-土默特右旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(376,‘固阳县‘,368,8,‘内蒙古自治区-包头市-固阳县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(377,‘达尔罕茂明安联合旗‘,368,9,‘内蒙古自治区-包头市-达尔罕茂明安联合旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(378,‘乌海市‘,343,4,‘内蒙古自治区-乌海市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(379,‘海勃湾区‘,378,1,‘内蒙古自治区-乌海市-海勃湾区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(380,‘海南区‘,378,2,‘内蒙古自治区-乌海市-海南区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(381,‘乌达区‘,378,3,‘内蒙古自治区-乌海市-乌达区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(382,‘乌兰察布市‘,343,5,‘内蒙古自治区-乌兰察布市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(383,‘集宁区‘,382,1,‘内蒙古自治区-乌兰察布市-集宁区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(384,‘卓资县‘,382,2,‘内蒙古自治区-乌兰察布市-卓资县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(385,‘化德县‘,382,3,‘内蒙古自治区-乌兰察布市-化德县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(386,‘商都县‘,382,4,‘内蒙古自治区-乌兰察布市-商都县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(387,‘兴和县‘,382,5,‘内蒙古自治区-乌兰察布市-兴和县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(388,‘凉城县‘,382,6,‘内蒙古自治区-乌兰察布市-凉城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(389,‘察哈尔右翼前旗‘,382,7,‘内蒙古自治区-乌兰察布市-察哈尔右翼前旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(390,‘察哈尔右翼中旗‘,382,8,‘内蒙古自治区-乌兰察布市-察哈尔右翼中旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(391,‘察哈尔右翼后旗‘,382,9,‘内蒙古自治区-乌兰察布市-察哈尔右翼后旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(392,‘四子王旗‘,382,10,‘内蒙古自治区-乌兰察布市-四子王旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(393,‘丰镇市‘,382,11,‘内蒙古自治区-乌兰察布市-丰镇市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(394,‘通辽市‘,343,6,‘内蒙古自治区-通辽市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(395,‘科尔沁区‘,394,1,‘内蒙古自治区-通辽市-科尔沁区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(396,‘科尔沁左翼中旗‘,394,2,‘内蒙古自治区-通辽市-科尔沁左翼中旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(397,‘科尔沁左翼后旗‘,394,3,‘内蒙古自治区-通辽市-科尔沁左翼后旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(398,‘开鲁县‘,394,4,‘内蒙古自治区-通辽市-开鲁县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(399,‘库伦旗‘,394,5,‘内蒙古自治区-通辽市-库伦旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(400,‘奈曼旗‘,394,6,‘内蒙古自治区-通辽市-奈曼旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(401,‘扎鲁特旗‘,394,7,‘内蒙古自治区-通辽市-扎鲁特旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(402,‘霍林郭勒市‘,394,8,‘内蒙古自治区-通辽市-霍林郭勒市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(403,‘赤峰市‘,343,7,‘内蒙古自治区-赤峰市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(404,‘红山区‘,403,1,‘内蒙古自治区-赤峰市-红山区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(405,‘元宝山区‘,403,2,‘内蒙古自治区-赤峰市-元宝山区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(406,‘松山区‘,403,3,‘内蒙古自治区-赤峰市-松山区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(407,‘阿鲁科尔沁旗‘,403,4,‘内蒙古自治区-赤峰市-阿鲁科尔沁旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(408,‘巴林左旗‘,403,5,‘内蒙古自治区-赤峰市-巴林左旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(409,‘巴林右旗‘,403,6,‘内蒙古自治区-赤峰市-巴林右旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(410,‘林西县‘,403,7,‘内蒙古自治区-赤峰市-林西县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(411,‘克什克腾旗‘,403,8,‘内蒙古自治区-赤峰市-克什克腾旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(412,‘翁牛特旗‘,403,9,‘内蒙古自治区-赤峰市-翁牛特旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(413,‘喀喇沁旗‘,403,10,‘内蒙古自治区-赤峰市-喀喇沁旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(414,‘宁城县‘,403,11,‘内蒙古自治区-赤峰市-宁城县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(415,‘敖汉旗‘,403,12,‘内蒙古自治区-赤峰市-敖汉旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(416,‘鄂尔多斯市‘,343,8,‘内蒙古自治区-鄂尔多斯市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(417,‘东胜区‘,416,1,‘内蒙古自治区-鄂尔多斯市-东胜区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(418,‘达拉特旗‘,416,2,‘内蒙古自治区-鄂尔多斯市-达拉特旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(419,‘准格尔旗‘,416,3,‘内蒙古自治区-鄂尔多斯市-准格尔旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(420,‘鄂托克前旗‘,416,4,‘内蒙古自治区-鄂尔多斯市-鄂托克前旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(421,‘鄂托克旗‘,416,5,‘内蒙古自治区-鄂尔多斯市-鄂托克旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(422,‘杭锦旗‘,416,6,‘内蒙古自治区-鄂尔多斯市-杭锦旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(423,‘乌审旗‘,416,7,‘内蒙古自治区-鄂尔多斯市-乌审旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(424,‘伊金霍洛旗‘,416,8,‘内蒙古自治区-鄂尔多斯市-伊金霍洛旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(425,‘巴彦淖尔市‘,343,9,‘内蒙古自治区-巴彦淖尔市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(426,‘临河区‘,425,1,‘内蒙古自治区-巴彦淖尔市-临河区‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(427,‘五原县‘,425,2,‘内蒙古自治区-巴彦淖尔市-五原县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(428,‘磴口县‘,425,3,‘内蒙古自治区-巴彦淖尔市-磴口县‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(429,‘乌拉特前旗‘,425,4,‘内蒙古自治区-巴彦淖尔市-乌拉特前旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(430,‘乌拉特中旗‘,425,5,‘内蒙古自治区-巴彦淖尔市-乌拉特中旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(431,‘乌拉特后旗‘,425,6,‘内蒙古自治区-巴彦淖尔市-乌拉特后旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(432,‘杭锦后旗‘,425,7,‘内蒙古自治区-巴彦淖尔市-杭锦后旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(433,‘锡林郭勒盟‘,343,10,‘内蒙古自治区-锡林郭勒盟‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(434,‘二连浩特市‘,433,1,‘内蒙古自治区-锡林郭勒盟-二连浩特市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(435,‘锡林浩特市‘,433,2,‘内蒙古自治区-锡林郭勒盟-锡林浩特市‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(436,‘阿巴嘎旗‘,433,3,‘内蒙古自治区-锡林郭勒盟-阿巴嘎旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(437,‘苏尼特左旗‘,433,4,‘内蒙古自治区-锡林郭勒盟-苏尼特左旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(438,‘苏尼特右旗‘,433,5,‘内蒙古自治区-锡林郭勒盟-苏尼特右旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(439,‘东乌珠穆沁旗‘,433,6,‘内蒙古自治区-锡林郭勒盟-东乌珠穆沁旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(440,‘西乌珠穆沁旗‘,433,7,‘内蒙古自治区-锡林郭勒盟-西乌珠穆沁旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(441,‘太仆寺旗‘,433,8,‘内蒙古自治区-锡林郭勒盟-太仆寺旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(442,‘镶黄旗‘,433,9,‘内蒙古自治区-锡林郭勒盟-镶黄旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(443,‘正镶白旗‘,433,10,‘内蒙古自治区-锡林郭勒盟-正镶白旗‘)
INSERT INTO REGION (region_id,region_name,parend_id,sort_id,region_mome) VALUES(444,‘正蓝旗‘,433,11,‘内蒙
热心网友
时间：2022-04-08 05:16
两个办法：
用外键，先建一个表，存储34个省市的名称，然后其他使用的表和此表建立外键关系。
建立check，check中*：in 这34个省市名称。
