/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50711
Source Host : localhost:3306
Source Database : rdms
Target Server Type : MYSQL
Target Server Version : 50711
File Encoding : 65001
Date: 2016-07-07 15:10:03
*/
use sppay;
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tab_imsi
-- ----------------------------
DROP TABLE IF EXISTS `tab_imsi`;
CREATE TABLE `tab_imsi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`area_code` varchar(255) DEFAULT NULL,
`mobile_area` varchar(255) DEFAULT NULL,
`mobile_number` varchar(255) DEFAULT NULL,
`mobile_type` varchar(255) DEFAULT NULL,
`post_code` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX phone_index (mobile_number(7))
) ENGINE=InnoDB AUTO_INCREMENT=314884 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tab_imsi
-- ----------------------------
INSERT INTO `tab_imsi` VALUES ('1', '0771', '广西 南宁市', '1330000', '电信CDMA卡', '530000');
INSERT INTO `tab_imsi` VALUES ('2', '023', '重庆', '1330002', '电信CDMA卡', '400000');
INSERT INTO `tab_imsi` VALUES ('3', '023', '重庆', '1330003', '电信CDMA卡', '400000');
INSERT INTO `tab_imsi` VALUES ('4', '010', '北京', '1330010', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('5', '010', '北京', '1330011', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('6', '021', '上海', '1330018', '电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('7', '021', '上海', '1330019', '电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('8', '022', '天津', '1330033', '电信CDMA卡', '300000');
INSERT INTO `tab_imsi` VALUES ('9', '022', '天津', '1330034', '电信CDMA卡', '300000');
INSERT INTO `tab_imsi` VALUES ('10', '021', '上海', '1330050', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('11', '021', '上海', '1330051', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('12', '021', '上海', '1330052', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('13', '021', '上海', '1330053', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('14', '021', '上海', '1330054', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('15', '021', '上海', '1330063', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('16', '021', '上海', '1330064', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('17', '021', '上海', '1330066', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('18', '021', '上海', '1330080', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('19', '021', '上海', '1330081', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('20', '021', '上海', '1330082', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('21', '021', '上海', '1330083', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('22', '021', '上海', '1330084', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('23', '021', '上海', '1330085', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('24', '021', '上海', '1330086', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('25', '021', '上海', '1330087', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('26', '021', '上海', '1330088', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('27', '021', '上海', '1330089', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('28', '021', '上海', '1330098', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('29', '010', '北京', '1330100', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('30', '010', '北京', '1330101', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('31', '010', '北京', '1330102', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('32', '010', '北京', '1330103', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('33', '010', '北京', '1330104', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('34', '010', '北京', '1330105', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('35', '010', '北京', '1330106', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('36', '010', '北京', '1330107', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('37', '010', '北京', '1330108', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('38', '010', '北京', '1330109', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('39', '010', '北京', '1330110', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('40', '010', '北京', '1330111', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('41', '010', '北京', '1330112', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('42', '010', '北京', '1330113', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('43', '010', '北京', '1330114', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('44', '010', '北京', '1330115', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('45', '010', '北京', '1330116', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('46', '010', '北京', '1330117', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('47', '010', '北京', '1330118', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('48', '010', '北京', '1330119', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('49', '010', '北京', '1330120', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('50', '010', '北京', '1330121', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('51', '010', '北京', '1330122', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('52', '010', '北京', '1330123', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('53', '010', '北京', '1330124', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('54', '010', '北京', '1330125', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('55', '010', '北京', '1330126', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('56', '010', '北京', '1330127', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('57', '010', '北京', '1330128', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('58', '010', '北京', '1330129', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('59', '010', '北京', '1330130', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('60', '010', '北京', '1330131', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('61', '010', '北京', '1330132', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('62', '010', '北京', '1330133', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('63', '010', '北京', '1330134', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('64', '010', '北京', '1330135', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('65', '010', '北京', '1330136', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('66', '010', '北京', '1330137', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('67', '010', '北京', '1330138', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('68', '010', '北京', '1330139', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('69', '0517', '江苏 淮安市', '1330140', '电信CDMA卡', '223001');
INSERT INTO `tab_imsi` VALUES ('70', '0515', '江苏 盐城市', '1330141', '电信CDMA卡', '224000');
INSERT INTO `tab_imsi` VALUES ('71', '0523', '江苏 泰州市', '1330142', '电信CDMA卡', '225300');
INSERT INTO `tab_imsi` VALUES ('72', '0523', '江苏 泰州市', '1330143', '电信CDMA卡', '225300');
INSERT INTO `tab_imsi` VALUES ('73', '0514', '江苏 扬州市', '1330144', '电信CDMA卡',
手机imsi号归属地库
1星 需积分: 50 65 浏览量
2020-07-17
16:30:29
上传
评论 4
收藏 1.6MB RAR 举报
clz1314521
- 粉丝: 80
- 资源: 30
最新资源
- 电机控制霍尔传感器和反电动势的关系分析
- 计算机生产实习:OA后台管理(web前端+Java后端)压缩文件包
- greenplum6.10安装时缺失的fpm包
- 缺陷检测-轻量化PCB表面缺陷检测算法实现-工业视觉+六大缺陷检出-优质项目实战.zip
- JAVA 中的Spring框架介绍包括起源、体系结构、核心部分、特点等
- 2024年小米汽车产业链分析及新品上市全景洞察报告
- 基于Qt和C++实现的偏3D风格的异型窗体界面操作+源码(期末大作业&课设&项目开发)
- 基于yolov8的花卉分类系统,包含训练好的权重和推理代码,GUI界面,支持图片、视频、摄像头输入,支持检测结果导出
- 基于图形化编程的单片机教学案例研究
- 基于matlab语音识别的信号灯图像模拟控制技术代码19
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈