mysql 2018最新行政代码导入方法(包括递级关系)

简单方便方法如下：

1.到民政部下载2018最新行政区域代码

2.将下载好代码，存入 mysql表中。如下表：

CREATE TABLE "public"."NewTable" (
"id" int4 NOT NULL,
"code" varchar(255) COLLATE "default",
"name" varchar(255) COLLATE "default",
"sort" int2,
"prentid" varchar COLLATE "default",
PRIMARY KEY ("id")
)

3.根据上述数据，再数据分层(上下级关系)

select * from test
where code like '%0000'

update test set sort=1,prentid=0
where code like '%0000'

---------------------
select left(code,2)||'0000' from test
where code like '%00' and sort is null

update test set sort=2,prentid=left(code,2)||'0000'
where code like '%00' and sort is null

---------------------------------
select *,left(code,4)||'00' from test
where code not like '%00' and sort is null

update test set sort=3,prentid=left(code,4)||'00'
where code not like '%00' and sort is null
-----------------------------------