手机号最新归属地数据，MYSQL版

-- phpMyAdmin SQL Dump -- version 4.4.15.10 -- https://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: 2023-01-27 00:09:43 -- 服务器版本： 5.5.62-log -- PHP Version: 7.2.13 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `ipAddress` -- -- -------------------------------------------------------- -- -- 表的结构 `phone` -- DROP TABLE IF EXISTS `phone`; CREATE TABLE IF NOT EXISTS `phone` ( `prefix` char(4) DEFAULT NULL, `phone` char(8) NOT NULL DEFAULT '', `province` varchar(6) DEFAULT NULL, `city` varchar(9) DEFAULT NULL, `isp` varchar(6) DEFAULT NULL, `post_code` varchar(7) DEFAULT NULL, `city_code` varchar(5) DEFAULT NULL, `area_code` varchar(7) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `phone` -- 数据更新时间：2023-07-20 -- INSERT INTO `phone` (`prefix`, `phone`, `province`, `city`, `isp`, `post_code`, `city_code`, `area_code`) VALUES ('130', '1300000', '山东', '济南', '联通', '250000', '0531', '370100'), ('130', '1300001', '江苏', '常州', '联通', '213000', '0519', '320400'), ('130', '1300002', '安徽', '合肥', '联通', '238000', '0551', '340181'), ('130', '1300003', '四川', '宜宾', '联通', '644000', '0831', '511500'), ('130', '1300004', '四川', '自贡', '联通', '643000', '0813', '510300'), ('130', '1300005', '陕西', '西安', '联通', '710000', '029', '610100'), ('130', '1300006', '江苏', '南京', '联通', '210000', '025', '320100'), ('130', '1300007', '陕西', '西安', '联通', '710000', '029', '610100'), ('130', '1300008', '湖北', '武汉', '联通', '430000', '027', '420100'), ('130', '1300009', '陕西', '西安', '联通', '710000', '029', '610100'), ('130', '1300010', '北京', '北京', '联通', '100000', '010', '110100'), ('130', '1300011', '北京', '北京', '联通', '100000', '010', '110100'), ('130', '1300012', '天津', '天津', '联通', '300000', '022', '120100'), ('130', '1300013', '天津', '天津', '联通', '300000', '022', '120100'), ('130', '1300014', '天津', '天津', '联通', '300000', '022', '120100'), ('130', '1300015', '山东', '淄博', '联通', '255000', '0533', '370300'), ('130', '1300016', '山东', '烟台', '联通', '264000', '0535', '370600'), ('130', '1300017', '山东', '济南', '联通', '250000', '0531', '370100'), ('130', '1300018', '天津', '天津', '联通', '300000', '022', '120100'), ('130', '1300019', '天津', '天津', '联通', '300000', '022', '120100'), ('130', '1300020', '上海', '上海', '联通', '200000', '021', '310100'), ('130', '1300021', '上海', '上海', '联通', '200000', '021', '310100'), ('130', '1300022', '上海', '上海', '联通', '200000', '021', '310100'), ('130', '1300023', '上海', '上海', '联通', '200000', '021', '310100'), ('130', '1300024', '上海', '上海', '联通', '200000', '021', '310100'), ('130', '1300025', '江苏', '南京', '联通', '210000', '025', '320100'), ('130', '1300026', '江苏', '南京', '联通', '210000', '025', '320100'), ('130', '1300027', '山东', '烟台', '联通', '264000', '0535', '370600'), ('130', '1300028', '江苏', '南京', '联通', '210000', '025', '320100'), ('130', '1300029', '江苏', '南京', '联通', '210000', '025', '320100'), ('130', '1300030', '江苏', '南京', '联通', '210000', '025', '320100'), ('130', '1300031', '江苏', '南京', '联通', '210000', '025', '320100'), ('130', '1300032', '江苏', '南京', '联通', '210000', '025', '320100'), ('130', '1300033', '江苏', '无锡', '联通', '214000', '0510', '320200'), ('130', '1300034', '江苏', '无锡', '联通', '214000', '0510', '320200'), ('130', '1300035', '江苏', '无锡', '联通', '214000', '0510', '320200'), ('130', '1300036', '江苏', '无锡', '联通', '214000', '0510', '320200'), ('130', '1300037', '江苏', '无锡', '联通', '214000', '0510', '320200'), ('130', '1300038', '江苏', '无锡', '联通', '214000', '0510', '320200'), ('130', '1300039', '江苏', '无锡', '联通', '214000', '0510', '320200'), ('130', '1300040', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300041', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300042', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300043', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300044', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300045', '北京', '北京', '联通', '100000', '010', '110100'), ('130', '1300046', '北京', '北京', '联通', '100000', '010', '110100'), ('130', '1300047', '北京', '北京', '联通', '100000', '010', '110100'), ('130', '1300048', '北京', '北京', '联通', '100000', '010', '110100'), ('130', '1300049', '北京', '北京', '联通', '100000', '010', '110100'), ('130', '1300050', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300051', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300052', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300053', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300054', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300055', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300056', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300057', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300058', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300059', '广西', '南宁', '联通', '530000', '0771', '450100'), ('130', '1300060', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300061', '湖北', '荆门', '联通', '448000', '0724', '420800'), ('130', '1300062', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300063', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300064', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300065', '山东', '潍坊', '联通', '261000', '0536', '370700'), ('130', '1300066', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300067', '浙江', '温州', '联通', '325000', '0577', '330300'), ('130', '1300068', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300069', '广西', '南宁', '联通', '530000', '0771', '450100'), ('130', '1300070', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300071', '湖北', '武汉', '联通', '430000', '027', '420100'), ('130', '1300072', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300073', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300074', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300075', '河南', '郑州', '联通', '450000', '0371', '410100'), ('130', '1300076', '河南', '郑州', '联通', '450000', '0371', '410100'), ('130', '1300077', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300078', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300079', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300080', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300081', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300082', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300083', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300084', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300085', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300086', '广东', '广州', '联通', '510000', '020', '440100'), ('130', '1300087', '甘肃', '兰州', '联通', '730000', '0931', '620100'