2022最新手机号段归属地查询 mysql 47万条数据

SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `tel_dict` -- ---------------------------- DROP TABLE IF EXISTS `tel_dict`; CREATE TABLE `tel_dict` ( `tel` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', `province` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `city` varchar(255) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`tel`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tel_dict -- ---------------------------- INSERT INTO `tel_dict` VALUES ('1300000', '山东', '济南'); INSERT INTO `tel_dict` VALUES ('1300001', '江苏', '常州'); INSERT INTO `tel_dict` VALUES ('1300002', '安徽', '巢湖'); INSERT INTO `tel_dict` VALUES ('1300003', '四川', '宜宾'); INSERT INTO `tel_dict` VALUES ('1300004', '四川', '自贡'); INSERT INTO `tel_dict` VALUES ('1300005', '陕西', '西安'); INSERT INTO `tel_dict` VALUES ('1300006', '江苏', '南京'); INSERT INTO `tel_dict` VALUES ('1300007', '陕西', '西安'); INSERT INTO `tel_dict` VALUES ('1300008', '湖北', '武汉'); INSERT INTO `tel_dict` VALUES ('1300009', '陕西', '西安'); INSERT INTO `tel_dict` VALUES ('1300010', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300011', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300012', '天津', '天津'); INSERT INTO `tel_dict` VALUES ('1300013', '天津', '天津'); INSERT INTO `tel_dict` VALUES ('1300014', '天津', '天津'); INSERT INTO `tel_dict` VALUES ('1300015', '山东', '淄博'); INSERT INTO `tel_dict` VALUES ('1300016', '山东', '烟台'); INSERT INTO `tel_dict` VALUES ('1300017', '山东', '济南'); INSERT INTO `tel_dict` VALUES ('1300018', '天津', '天津'); INSERT INTO `tel_dict` VALUES ('1300019', '天津', '天津'); INSERT INTO `tel_dict` VALUES ('1300020', '上海', '上海'); INSERT INTO `tel_dict` VALUES ('1300021', '上海', '上海'); INSERT INTO `tel_dict` VALUES ('1300022', '上海', '上海'); INSERT INTO `tel_dict` VALUES ('1300023', '上海', '上海'); INSERT INTO `tel_dict` VALUES ('1300024', '上海', '上海'); INSERT INTO `tel_dict` VALUES ('1300025', '江苏', '南京'); INSERT INTO `tel_dict` VALUES ('1300026', '江苏', '南京'); INSERT INTO `tel_dict` VALUES ('1300027', '山东', '烟台'); INSERT INTO `tel_dict` VALUES ('1300028', '江苏', '南京'); INSERT INTO `tel_dict` VALUES ('1300029', '江苏', '南京'); INSERT INTO `tel_dict` VALUES ('1300030', '江苏', '南京'); INSERT INTO `tel_dict` VALUES ('1300031', '江苏', '南京'); INSERT INTO `tel_dict` VALUES ('1300032', '江苏', '南京'); INSERT INTO `tel_dict` VALUES ('1300033', '江苏', '无锡'); INSERT INTO `tel_dict` VALUES ('1300034', '江苏', '无锡'); INSERT INTO `tel_dict` VALUES ('1300035', '江苏', '无锡'); INSERT INTO `tel_dict` VALUES ('1300036', '江苏', '无锡'); INSERT INTO `tel_dict` VALUES ('1300037', '江苏', '无锡'); INSERT INTO `tel_dict` VALUES ('1300038', '江苏', '无锡'); INSERT INTO `tel_dict` VALUES ('1300039', '江苏', '无锡'); INSERT INTO `tel_dict` VALUES ('1300040', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300041', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300042', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300043', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300044', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300045', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300046', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300047', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300048', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300049', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300050', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300051', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300052', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300053', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300054', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300055', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300056', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300057', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300058', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300059', '广西', '南宁'); INSERT INTO `tel_dict` VALUES ('1300060', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300061', '湖北', '荆门'); INSERT INTO `tel_dict` VALUES ('1300062', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300063', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300064', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300065', '山东', '潍坊'); INSERT INTO `tel_dict` VALUES ('1300066', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300067', '浙江', '温州'); INSERT INTO `tel_dict` VALUES ('1300068', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300069', '广西', '南宁'); INSERT INTO `tel_dict` VALUES ('1300070', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300071', '湖北', '武汉'); INSERT INTO `tel_dict` VALUES ('1300072', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300073', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300074', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300075', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300076', '河南', '郑州'); INSERT INTO `tel_dict` VALUES ('1300077', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300078', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300079', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300080', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300081', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300082', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300083', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300084', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300085', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300086', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300087', '甘肃', '兰州'); INSERT INTO `tel_dict` VALUES ('1300088', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300089', '广东', '广州'); INSERT INTO `tel_dict` VALUES ('1300090', '浙江', '宁波'); INSERT INTO `tel_dict` VALUES ('1300091', '吉林', '长春'); INSERT INTO `tel_dict` VALUES ('1300092', '辽宁', '本溪'); INSERT INTO `tel_dict` VALUES ('1300093', '辽宁', '营口'); INSERT INTO `tel_dict` VALUES ('1300094', '辽宁', '大连'); INSERT INTO `tel_dict` VALUES ('1300095', '内蒙古', '包头'); INSERT INTO `tel_dict` VALUES ('1300096', '新疆', '乌鲁木齐'); INSERT INTO `tel_dict` VALUES ('1300097', '黑龙江', '佳木斯'); INSERT INTO `tel_dict` VALUES ('1300098', '黑龙江', '哈尔滨'); INSERT INTO `tel_dict` VALUES ('1300099', '福建', '福州'); INSERT INTO `tel_dict` VALUES ('1300100', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300101', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300102', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300103', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300104', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300105', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300106', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300107', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300108', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300109', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300110', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300111', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300112', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300113', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300114', '北京', '北京'); INSERT INTO `tel_dict` VALUES ('1300115', '北京', '北京'); INSERT INTO `