mysql 江西省行政区划数据表

CREATE TABLE t_jx_city(
    id INT AUTO_INCREMENT COMMENT '主键id',
    name VARCHAR(250) COMMENT '地名',
    pid INT COMMENT '上级id',
		code BEGIN COMMENT '地区代码'
    PRIMARY KEY(id)
)DEFAULT CHARSET=utf8mb4;

insert into t_jx_city values(1,'江西省',0,360000);

insert into t_jx_city values(2,'南昌市',1,360100);
insert into t_jx_city values(13,'安义县',2,360123);
insert into t_jx_city values(14,'新建区',2,360112);
insert into t_jx_city values(15,'青山湖区',2,360111);
insert into t_jx_city values(16,'红谷滩区',2,360113);
insert into t_jx_city values(17,'东湖区',2,360102);
insert into t_jx_city values(18,'西湖区',2,360103);
insert into t_jx_city values(19,'青云谱区',2,360104);
insert into t_jx_city values(20,'南昌县',2,360121);
insert into t_jx_city values(21,'进贤县',2,360124);


insert into t_jx_city values(3,'景德镇市',1,360200);  
insert into t_jx_city values(22,'浮梁县',3,360222);  
insert into t_jx_city values(23,'珠山区',3,360203);  
insert into t_jx_city values(24,'昌江区',3,360202);  
insert into t_jx_city values(25,'乐平市',3,360281);  



insert into t_jx_city values(4,'萍乡市',1,360300);  
insert into t_jx_city values(26,'上栗县',4,360322);  
insert into t_jx_city values(27,'安源区',4,360302);  
insert into t_jx_city values(28,'芦溪县',4,360323);  
insert into t_jx_city values(29,'湘东区',4,360313);  
insert into t_jx_city values(30,'莲花县',4,360321);  


insert into t_jx_city values(5,'九江市',1,360400);  
insert into t_jx_city values(31,'修水县',5,360424);  
insert into t_jx_city values(32,'武宁县',5,360423);  
insert into t_jx_city values(33,'瑞昌市',5,360481);  
insert into t_jx_city values(34,'德安县',5,360426);  
insert into t_jx_city values(35,'永修县',5,360425);  
insert into t_jx_city values(36,'共青城市',5,360482);  
insert into t_jx_city values(37,'庐山市',5,360483);  
insert into t_jx_city values(38,'柴桑区',5,360404);  
insert into t_jx_city values(39,'濂溪区',5,360402);  
insert into t_jx_city values(40,'浔阳区',5,360403);  
insert into t_jx_city values(41,'湖口县',5,360429);  
insert into t_jx_city values(42,'都昌县',5,360428);  
insert into t_jx_city values(43,'彭泽县',5,360430);  


insert into t_jx_city values(6,'新余市',1,360500);
insert into t_jx_city values(44,'分宜县',6,360521);   
insert into t_jx_city values(45,'渝水区',6,360502);


insert into t_jx_city values(7,'鹰潭市',1,360600);   
insert into t_jx_city values(46,'贵溪市',7,360681);   
insert into t_jx_city values(47,'月湖区',7,360602);   
insert into t_jx_city values(48,'余江区',7,360603);

insert into t_jx_city values(8,'赣州市',1,360700);   
insert into t_jx_city values(49,'上犹县',8,360724);   
insert into t_jx_city values(50,'崇义县',8,360725);   
insert into t_jx_city values(51,'大余县',8,360723);   
insert into t_jx_city values(52,'南康区',8,360702);   
insert into t_jx_city values(53,'章贡区',8,360702);   
insert into t_jx_city values(54,'赣县区',8,360704);   
insert into t_jx_city values(55,'于都县',8,360731);   
insert into t_jx_city values(56,'兴国县',8,360732);   
insert into t_jx_city values(57,'宁都县',8,360730);   
insert into t_jx_city values(58,'石城县',8,360735);
insert into t_jx_city values(59,'瑞金市',8,360781);
insert into t_jx_city values(60,'会昌县',8,360733);
insert into t_jx_city values(61,'安远县',8,360726);
insert into t_jx_city values(62,'信丰县',8,360722);
insert into t_jx_city values(63,'全南县',8,360729);
insert into t_jx_city values(64,'龙南市',8,360782);
insert into t_jx_city values(65,'定南县',8,360728);
insert into t_jx_city values(66,'寻乌县',8,360734);


insert into t_jx_city values(9,'吉安市',1,360800); 
insert into t_jx_city values(67,'新干县',9,360824);   
insert into t_jx_city values(68,'峡江县',9,360823);   
insert into t_jx_city values(69,'永丰县',9,360825);   
insert into t_jx_city values(70,'吉水县',9,360822);   
insert into t_jx_city values(71,'青原区',9,360803); 
insert into t_jx_city values(72,'吉州区',9,360802);   
insert into t_jx_city values(73,'吉安县',9,360821);   
insert into t_jx_city values(74,'安福县',9,360829);   
insert into t_jx_city values(75,'永新县',9,360830);   
insert into t_jx_city values(76,'井冈山市',9,360881);   
insert into t_jx_city values(77,'泰和县',9,360826);   
insert into t_jx_city values(78,'万安县',9,360828);   
insert into t_jx_city values(79,'遂川县',9,360827); 





insert into t_jx_city values(10,'宜春市',1,360900);
insert into t_jx_city values(80,'靖安县',10,360925);   
insert into t_jx_city values(81,'奉新县',10,360921);   
insert into t_jx_city values(82,'铜鼓县',10,360926);   
insert into t_jx_city values(83,'宜丰县',10,360924);   
insert into t_jx_city values(84,'高安市',10,360983);   
insert into t_jx_city values(85,'上高县',10,360923);   
insert into t_jx_city values(86,'万载县',10,360922);   
insert into t_jx_city values(87,'樟树市',10,360982);   
insert into t_jx_city values(88,'丰城市',10,360981);   
insert into t_jx_city values(89,'袁州区',10,360902);   


insert into t_jx_city values(11,'抚州市',1,361000);
insert into t_jx_city values(90,'东乡区',11,361003);   
insert into t_jx_city values(91,'金溪县',11,361027);  
insert into t_jx_city values(92,'临川区',11,361002);   
insert into t_jx_city values(93,'崇仁县',11,361024);   
insert into t_jx_city values(94,'资溪县',11,361028);   
insert into t_jx_city values(95,'南城县',11,361021);   
insert into t_jx_city values(96,'宜黄县',11,361026);   
insert into t_jx_city values(97,'乐安县',11,361025);   
insert into t_jx_city values(98,'黎川县',11,361022);   
insert into t_jx_city values(99,'南丰县',11,361023);   
insert into t_jx_city values(100,'广昌县',11,361030);   

insert into t_jx_city values(12,'上饶市',1,361100);
insert into t_jx_city values(101,'鄱阳县',12,361128);   
insert into t_jx_city values(102,'余干县',12,361127);   
insert into t_jx_city values(103,'万年县',12,361129);   
insert into t_jx_city values(104,'德兴市',12,361181);   
insert into t_jx_city values(105,'玉山县',12,361123);   
insert into t_jx_city values(106,'弋阳县',12,361126);   
insert into t_jx_city values(107,'横峰县',12,361125);   
insert into t_jx_city values(108,'信州区',12,361102);   
insert into t_jx_city values(109,'广信区',12,361104);   
insert into t_jx_city values(110,'广丰区',12,361103);   
insert into t_jx_city values(111,'铅山县',12,361124);  
insert into t_jx_city values(112,'婺源县',12,361130);