文件名称：身份证号对应归属地sql文件
文件大小：522KB
文件格式：SQL
更新时间：2021-04-11 11:09:28
身份证 省市区
DROP TABLE IF EXISTS `bclp_identity_card`; CREATE TABLE `bclp_identity_card` ( `id` int(22) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL COMMENT '身份证前6位', `address` varchar(50) DEFAULT NULL COMMENT '归属地', `create_time` datetime DEFAULT CURRENT_TIMESTAMP, `create_id` varchar(50) DEFAULT NULL, `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `update_id` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3554 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of bclp_identity_card -- ---------------------------- INSERT INTO `bclp_identity_card` VALUES ('2', '110000', '北京市', '2018-03-21 11:05:54', 'sys', '2018-03-21 11:15:19', null); INSERT INTO `bclp_identity_card` VALUES ('3', '110100', '北京市市辖区', '2018-03-21 11:05:54', 'sys', '2018-03-21 11:15:19', null); INSERT INTO `bclp_identity_card` VALUES ('4', '110101', '北京市东城区', '2018-03-21 11:05:54', 'sys', '2018-03-21 11:15:19', null); INSERT INTO `bclp_identity_card` VALUES ('5', '110102', '北京市西城区', '2018-03-21 11:05:54', 'sys', '2018-03-21 11:15:19', null); INSERT INTO `bclp_identity_card` VALUES ('6', '110103', '北京市崇文区', '2018-03-21 11:05:54', 'sys', '2018-03-21 11:15:19', null); INSERT INTO `bclp_identity_card` VALUES ('7', '110104', '北京市宣武区', '2018-03-21 11:05:55',