最全的身份证前6位代码数据库sql资源-CSDN文库

共1个文件

sql：1个

mysql

5星 · 超过95%的资源需积分: 14 46 浏览量 2018-10-17 15:48:34 上传评论 2 收藏 48KB RAR 举报

资源推荐

资源详情

资源评论

收起资源包目录

areas.rar （1个子文件）

areas.sql 609KB

SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for areas -- ---------------------------- DROP TABLE IF EXISTS `areas`; CREATE TABLE `areas` ( `zip` int(11) NOT NULL, `name` varchar(50) NOT NULL, `father_zip` int(11) NOT NULL, `level` int(11) NOT NULL, `abbr_name` varchar(50) DEFAULT NULL, `abbr_letter` varchar(50) DEFAULT NULL, `bdmap_citycode` int(11) NOT NULL, `is_enabled` tinyint(1) NOT NULL, `lng_x` double NOT NULL, `lat_y` double NOT NULL, PRIMARY KEY (`zip`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of areas -- ---------------------------- INSERT INTO `areas` VALUES ('110000', '北京市', '0', '0', '京', 'BJ', '131', '0', '116.395645', '39.929986'); INSERT INTO `areas` VALUES ('110100', '北京市', '110000', '1', '0', '0', '131', '0', '116.395645', '39.929986'); INSERT INTO `areas` VALUES ('110101', '东城区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110102', '西城区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110103', '崇文区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110104', '宣武区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110105', '朝阳区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110106', '丰台区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110107', '石景山区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110108', '海淀区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110109', '门头沟区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110110', '燕山区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110111', '房山区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110112', '通州区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110113', '顺义区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110114', '昌平区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110115', '大兴区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110116', '怀柔区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110117', '平谷区', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110128', '密云县', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110129', '延庆县', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110221', '昌平县', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110222', '顺义县', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110223', '通县', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110224', '大兴县', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110225', '房山县', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110226', '平谷县', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110227', '怀柔县', '110100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110228', '密云县', '110200', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110229', '延庆县', '110200', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('110230', '其它区', '110200', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120000', '天津市', '0', '0', '津', 'TJ', '332', '0', '117.210813', '39.14393'); INSERT INTO `areas` VALUES ('120100', '天津市', '120000', '1', '0', '0', '332', '0', '117.210813', '39.14393'); INSERT INTO `areas` VALUES ('120101', '和平区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120102', '河东区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120103', '河西区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120104', '南开区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120105', '河北区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120106', '红桥区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120107', '塘沽区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120108', '汉沽区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120109', '大港区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120110', '东丽区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120111', '西青区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120112', '津南区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120113', '北辰区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120114', '武清区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120115', '宝坻区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120116', '滨海新区', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120122', '宁海县', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120123', '静海县', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120125', '蓟县', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120221', '宁河县', '120200', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120222', '武清县', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120223', '静海县', '120200', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120224', '宝坻县', '120100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120225', '蓟县', '120200', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('120226', '其它区', '120200', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130000', '河北省', '0', '0', '冀', 'HB', '0', '0', '115.661434', '38.61384'); INSERT INTO `areas` VALUES ('130100', '石家庄市', '130000', '1', '0', '0', '150', '0', '114.522082', '38.048958'); INSERT INTO `areas` VALUES ('130101', '石家庄市', '130100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130102', '长安区', '130100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130103', '桥东区', '130100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130104', '桥西区', '130100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130105', '新华区', '130100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130106', '郊区', '130100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130107', '井陉矿区', '130100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130108', '裕华区', '130100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130121', '井陉县', '130100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130122', '获鹿县', '130100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130123', '正定县', '130100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130124', '栾城县', '130100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130125', '行唐县', '130100', '2', '0', '0', '0', '0', '0', '0'); INSERT INTO `areas` VALUES ('130126', '灵寿县', '130100', '2',

评论收藏

内容反馈