全国身份证地域数据库 (sql语句包)

/* SQLyog Ultimate v9.20 MySQL - 5.0.45-community-nt-log ********************************************************************* */ /*!40101 SET NAMES utf8 */; create table `idc` ( `ID` double , `BM` double , `DQ` varchar (765) ); insert into `idc` (`ID`, `BM`, `DQ`) values('1','110000','北京市'); insert into `idc` (`ID`, `BM`, `DQ`) values('2','110100','北京市市辖区'); insert into `idc` (`ID`, `BM`, `DQ`) values('3','110101','北京市东城区'); insert into `idc` (`ID`, `BM`, `DQ`) values('4','110102','北京市西城区'); insert into `idc` (`ID`, `BM`, `DQ`) values('5','110103','北京市崇文区'); insert into `idc` (`ID`, `BM`, `DQ`) values('6','110104','北京市宣武区'); insert into `idc` (`ID`, `BM`, `DQ`) values('7','110105','北京市朝阳区'); insert into `idc` (`ID`, `BM`, `DQ`) values('8','110106','北京市丰台区'); insert into `idc` (`ID`, `BM`, `DQ`) values('9','110107','北京市石景山区'); insert into `idc` (`ID`, `BM`, `DQ`) values('10','110108','北京市海淀区'); insert into `idc` (`ID`, `BM`, `DQ`) values('11','110109','北京市门头沟区'); insert into `idc` (`ID`, `BM`, `DQ`) values('12','110111','北京市房山区'); insert into `idc` (`ID`, `BM`, `DQ`) values('13','110112','北京市通州区'); insert into `idc` (`ID`, `BM`, `DQ`) values('14','110113','北京市顺义区'); insert into `idc` (`ID`, `BM`, `DQ`) values('15','110200','北京市县'); insert into `idc` (`ID`, `BM`, `DQ`) values('16','110221','北京市昌平县'); insert into `idc` (`ID`, `BM`, `DQ`) values('17','110224','北京市大兴县'); insert into `idc` (`ID`, `BM`, `DQ`) values('18','110226','北京市平谷县'); insert into `idc` (`ID`, `BM`, `DQ`) values('19','110227','北京市怀柔县'); insert into `idc` (`ID`, `BM`, `DQ`) values('20','110228','北京市密云县'); insert into `idc` (`ID`, `BM`, `DQ`) values('21','110229','北京市延庆县'); insert into `idc` (`ID`, `BM`, `DQ`) values('22','120000','天津市'); insert into `idc` (`ID`, `BM`, `DQ`) values('23','120100','天津市市辖区'); insert into `idc` (`ID`, `BM`, `DQ`) values('24','120101','天津市和平区'); insert into `idc` (`ID`, `BM`, `DQ`) values('25','120102','天津市河东区'); insert into `idc` (`ID`, `BM`, `DQ`) values('26','120103','天津市河西区'); insert into `idc` (`ID`, `BM`, `DQ`) values('27','120104','天津市南开区'); insert into `idc` (`ID`, `BM`, `DQ`) values('28','120105','天津市河北区'); insert into `idc` (`ID`, `BM`, `DQ`) values('29','120106','天津市红桥区'); insert into `idc` (`ID`, `BM`, `DQ`) values('30','120107','天津市塘沽区'); insert into `idc` (`ID`, `BM`, `DQ`) values('31','120108','天津市汉沽区'); insert into `idc` (`ID`, `BM`, `DQ`) values('32','120109','天津市大港区'); insert into `idc` (`ID`, `BM`, `DQ`) values('33','120110','天津市东丽区'); insert into `idc` (`ID`, `BM`, `DQ`) values('34','120111','天津市西青区'); insert into `idc` (`ID`, `BM`, `DQ`) values('35','120112','天津市津南区'); insert into `idc` (`ID`, `BM`, `DQ`) values('36','120113','天津市北辰区'); insert into `idc` (`ID`, `BM`, `DQ`) values('37','120200','天津市县'); insert into `idc` (`ID`, `BM`, `DQ`) values('38','120221','天津市宁河县'); insert into `idc` (`ID`, `BM`, `DQ`) values('39','120222','天津市武清县'); insert into `idc` (`ID`, `BM`, `DQ`) values('40','120223','天津市静海县'); insert into `idc` (`ID`, `BM`, `DQ`) values('41','120224','天津市宝坻县'); insert into `idc` (`ID`, `BM`, `DQ`) values('42','120225','天津市蓟县'); insert into `idc` (`ID`, `BM`, `DQ`) values('43','130000','河北省'); insert into `idc` (`ID`, `BM`, `DQ`) values('44','130100','河北省石家庄市'); insert into `idc` (`ID`, `BM`, `DQ`) values('45','130101','河北省石家庄市市辖区'); insert into `idc` (`ID`, `BM`, `DQ`) values('46','130102','河北省石家庄市长安区'); insert into `idc` (`ID`, `BM`, `DQ`) values('47','130103','河北省石家庄市桥东区'); insert into `idc` (`ID`, `BM`, `DQ`) values('48','130104','河北省石家庄市桥西区'); insert into `idc` (`ID`, `BM`, `DQ`) values('49','130105','河北省石家庄市新华区'); insert into `idc` (`ID`, `BM`, `DQ`) values('50','130106','河北省石家庄市郊区'); insert into `idc` (`ID`, `BM`, `DQ`) values('51','130107','河北省石家庄市井陉矿区'); insert into `idc` (`ID`, `BM`, `DQ`) values('52','130121','河北省石家庄市井陉县'); insert into `idc` (`ID`, `BM`, `DQ`) values('53','130123','河北省石家庄市正定县'); insert into `idc` (`ID`, `BM`, `DQ`) values('54','130124','河北省石家庄市栾城县'); insert into `idc` (`ID`, `BM`, `DQ`) values('55','130125','河北省石家庄市行唐县'); insert into `idc` (`ID`, `BM`, `DQ`) values('56','130126','河北省石家庄市灵寿县'); insert into `idc` (`ID`, `BM`, `DQ`) values('57','130127','河北省石家庄市高邑县'); insert into `idc` (`ID`, `BM`, `DQ`) values('58','130128','河北省石家庄市深泽县'); insert into `idc` (`ID`, `BM`, `DQ`) values('59','130129','河北省石家庄市赞皇县'); insert into `idc` (`ID`, `BM`, `DQ`) values('60','130130','河北省石家庄市无极县'); insert into `idc` (`ID`, `BM`, `DQ`) values('61','130131','河北省石家庄市平山县'); insert into `idc` (`ID`, `BM`, `DQ`) values('62','130132','河北省石家庄市元氏县'); insert into `idc` (`ID`, `BM`, `DQ`) values('63','130133','河北省石家庄市赵县'); insert into `idc` (`ID`, `BM`, `DQ`) values('64','130181','河北省石家庄市辛集市'); insert into `idc` (`ID`, `BM`, `DQ`) values('65','130182','河北省石家庄市藁城市'); insert into `idc` (`ID`, `BM`, `DQ`) values('66','130183','河北省石家庄市晋州市'); insert into `idc` (`ID`, `BM`, `DQ`) values('67','130184','河北省石家庄市新乐市'); insert into `idc` (`ID`, `BM`, `DQ`) values('68','130185','河北省石家庄市鹿泉市'); insert into `idc` (`ID`, `BM`, `DQ`) values('69','130200','河北省唐山市'); insert into `idc` (`ID`, `BM`, `DQ`) values('70','130201','河北省唐山市市辖区'); insert into `idc` (`ID`, `BM`, `DQ`) values('71','130202','河北省唐山市路南区'); insert into `idc` (`ID`, `BM`, `DQ`) values('72','130203','河北省唐山市路北区'); insert into `idc` (`ID`, `BM`, `DQ`) values('73','130204','河北省唐山市古冶区'); insert into `idc` (`ID`, `BM`, `DQ`) values('74','130205','河北省唐山市开平区'); insert into `idc` (`ID`, `BM`, `DQ`) values('75','130206','河北省唐山市新区'); insert into `idc` (`ID`, `BM`, `DQ`) values('76','130221','河北省唐山市丰润县'); insert into `idc` (`ID`, `BM`, `DQ`) values('77','130223','河北省唐山市滦县'); insert into `idc` (`ID`, `BM`, `DQ`) values('78','130224','河北省唐山市滦南县'); insert into `idc` (`ID`, `BM`, `DQ`) values('79','130225','河北省唐山市乐亭县'); insert into `idc` (`ID`, `BM`, `DQ`) values('80','130227','河北省唐山市迁西县'); insert into `idc` (`ID`, `BM`, `DQ`) values('81','130229','河北省唐山市玉田县'); insert into `idc` (`ID`, `BM`, `DQ`) values('82','130230','河北省唐山市唐海县'); insert into `idc` (`ID`, `BM`, `DQ`) values('83','130281','河北省唐山市遵化市'); insert into `idc` (`ID`, `BM`, `DQ`) values('84','130282','河北省唐山市丰南市'); insert into `idc` (`ID`, `BM`, `DQ`) values('85','130283','河北省唐山市迁安市'); insert into `idc` (`ID`, `BM`, `DQ`) values('86','130300','河北省秦皇岛市秦皇岛市'); insert into `idc` (`ID`, `BM`, `DQ`) values('87','130301','河北省秦皇岛市市辖区'); insert into `idc` (`ID`, `BM`, `DQ`) values('88','130302','河北省秦皇岛市海港区'); insert into `idc` (`ID`, `BM`, `DQ`) values('89','130303','河北省秦皇岛市山海关区'); insert into `idc` (`ID`, `