身份证前6位地址码+码表+MySQL

不知道什么原因会出现*

去这里复制码云Gitee

完整 SQL 码表已移到静态文件，避免文章页面直接渲染数千行 SQL 影响加载速度。

下载完整 address-code.sql

insert into smd_address_code(add_code,address) values('110000','北京市');
insert into smd_address_code(add_code,address) values('110100','北京市市辖区');
insert into smd_address_code(add_code,address) values('110101','北京市东城区');
insert into smd_address_code(add_code,address) values('110102','北京市*城区');
insert into smd_address_code(add_code,address) values('110103','北京市崇文区');
insert into smd_address_code(add_code,address) values('110104','北京市宣武区');
insert into smd_address_code(add_code,address) values('110105','北京市朝阳区');
insert into smd_address_code(add_code,address) values('110106','北京市丰台区');
insert into smd_address_code(add_code,address) values('110107','北京市石景山区');
insert into smd_address_code(add_code,address) values('110108','北京市海淀区');
insert into smd_address_code(add_code,address) values('110109','北京市门头沟区');
insert into smd_address_code(add_code,address) values('110111','北京市房山区');
insert into smd_address_code(add_code,address) values('110112','北京市通州区');
insert into smd_address_code(add_code,address) values('110113','北京市顺义区');
insert into smd_address_code(add_code,address) values('110200','北京市县');
insert into smd_address_code(add_code,address) values('110221','北京市昌*县');
insert into smd_address_code(add_code,address) values('110224','北京市大兴县');
insert into smd_address_code(add_code,address) values('110226','北京市*谷县');
insert into smd_address_code(add_code,address) values('110227','北京市怀柔县');
insert into smd_address_code(add_code,address) values('110228','北京市密云县');
-- 其余内容请下载完整 SQL 文件查看