CREATE TABLE IF NOT EXISTS `phone_location` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`mobile_number` varchar(20) DEFAULT NULL COMMENT '手机号码号段',
`area_code` varchar(20) DEFAULT NULL COMMENT '区域编码',
`province` varchar(50) DEFAULT NULL COMMENT '省',
`city` varchar(50) DEFAULT NULL COMMENT '市',
PRIMARY KEY (`id`),
KEY `mobile_number` (`mobile_number`)
) ENGINE=InnoDB AUTO_INCREMENT=327676 DEFAULT CHARSET=utf8 COMMENT='电话号码归属地表';
INSERT INTO `phone_location` (`id`, `mobile_number`, `area_code`, `province`, `city`) VALUES
(1, '1300000', '0531', '山东省', '济南市'),
(2, '1300001', '0519', '江苏省', '常州市'),
(3, '1300002', '0565', '安徽省', '巢湖市'),
(4, '1300006', '025', '江苏省', '南京市'),
(5, '1300008', '027', '湖北省', '武汉市'),
(6, '1300010', '010', '直辖市', '北京市'),
(7, '1300011', '010', '直辖市', '北京市'),
(8, '1300012', '022', '直辖市', '天津市'),
(9, '1300013', '022', '直辖市', '天津市'),
(10, '1300014', '022', '直辖市', '天津市'),
(11, '1300015', '0533', '山东省', '淄博市'),
(12, '1300016', '0535', '山东省', '烟台市'),
(13, '1300017', '0531', '山东省', '济南市'),
(14, '1300018', '022', '直辖市', '天津市'),
(15, '1300019', '022', '直辖市', '天津市'),
(16, '1300020', '021', '直辖市', '上海市'),
(17, '1300021', '021', '直辖市', '上海市'),
(18, '1300022', '021', '直辖市', '上海市'),
(19, '1300023', '021', '直辖市', '上海市'),
(20, '1300024', '021', '直辖市', '上海市'),
(21, '1300025', '025', '江苏省', '南京市'),
(22, '1300026', '025', '江苏省', '南京市'),
(23, '1300027', '0535', '山东省', '烟台市'),
(24, '1300028', '025', '江苏省', '南京市'),
(25, '1300029', '025', '江苏省', '南京市'),
(26, '1300030', '025', '江苏省', '南京市'),
(27, '1300031', '025', '江苏省', '南京市'),
(28, '1300032', '025', '江苏省', '南京市'),
(29, '1300033', '0510', '江苏省', '无锡市'),
(30, '1300034', '0510', '江苏省', '无锡市'),
(31, '1300035', '0510', '江苏省', '无锡市'),
(32, '1300036', '0510', '江苏省', '无锡市'),
(33, '1300037', '0510', '江苏省', '无锡市'),
(34, '1300038', '0510', '江苏省', '无锡市'),
(35, '1300039', '0510', '江苏省', '无锡市'),
(36, '1300040', '020', '广东省', '广州市'),
(37, '1300041', '020', '广东省', '广州市'),
(38, '1300042', '020', '广东省', '广州市'),
(39, '1300043', '020', '广东省', '广州市'),
(40, '1300044', '020', '广东省', '广州市'),
(41, '1300045', '010', '直辖市', '北京市'),
(42, '1300046', '010', '直辖市', '北京市'),
(43, '1300047', '010', '直辖市', '北京市'),
(44, '1300048', '010', '直辖市', '北京市'),
(45, '1300049', '010', '直辖市', '北京市'),
(46, '1300050', '020', '广东省', '广州市'),
(47, '1300051', '020', '广东省', '广州市'),
(48, '1300052', '020', '广东省', '广州市'),
(49, '1300053', '020', '广东省', '广州市'),
(50, '1300054', '020', '广东省', '广州市'),
(51, '1300055', '020', '广东省', '广州市'),
(52, '1300056', '020', '广东省', '广州市'),
(53, '1300057', '020', '广东省', '广州市'),
(54, '1300058', '020', '广东省', '广州市'),
(55, '1300059', '020', '广东省', '广州市'),
(56, '1300060', '020', '广东省', '广州市'),
(57, '1300061', '0724', '湖北省', '荆门市'),
(58, '1300062', '020', '广东省', '广州市'),
(59, '1300063', '020', '广东省', '广州市'),
(60, '1300064', '020', '广东省', '广州市'),
(61, '1300065', '0536', '山东省', '淮坊市'),
(62, '1300066', '020', '广东省', '广州市'),
(63, '1300067', '0577', '浙江省', '温州市'),
(64, '1300068', '020', '广东省', '广州市'),
(65, '1300069', '0771', '广西省', '南宁市'),
(66, '1300070', '020', '广东省', '广州市'),
(67, '1300071', '027', '湖北省', '武汉市'),
(68, '1300072', '020', '广东省', '广州市'),
(69, '1300073', '020', '广东省', '广州市'),
(70, '1300074', '020', '广东省', '广州市'),
(71, '1300075', '020', '广东省', '广州市'),
(72, '1300076', '020', '广东省', '广州市'),
(73, '1300077', '020', '广东省', '广州市'),
(74, '1300078', '020', '广东省', '广州市'),
(75, '1300079', '020', '广东省', '广州市'),
(76, '1300080', '020', '广东省', '广州市'),
(77, '1300081', '020', '广东省', '广州市'),
(78, '1300082', '020', '广东省', '广州市'),
(79, '1300083', '020', '广东省', '广州市'),
(80, '1300084', '020', '广东省', '广州市'),
(81, '1300085', '020', '广东省', '广州市'),
(82, '1300086', '020', '广东省', '广州市'),
(83, '1300087', '0931', '甘肃省', '兰州市'),
(84, '1300088', '020', '广东省', '广州市'),
(85, '1300089', '020', '广东省', '广州市'),
(86, '1300091', '0431', '吉林省', '长春市'),
(87, '1300092', '0414', '辽宁省', '本溪市'),
(88, '1300093', '0417', '辽宁省', '营口市'),
(89, '1300094', '0411', '辽宁省', '大连市'),
(90, '1300095', '0472', '内蒙古', '包头市'),
(91, '1300097', '0454', '黑龙江', '佳木斯'),
(92, '1300098', '0451', '黑龙江', '哈尔滨'),
(93, '1300100', '010', '直辖市', '北京市'),
(94, '1300101', '010', '直辖市', '北京市'),
(95, '1300102', '010', '直辖市', '北京市'),
(96, '1300103', '010', '直辖市', '北京市'),
(97, '1300104', '010', '直辖市', '北京市'),
(98, '1300105', '010', '直辖市', '北京市'),
(99, '1300106', '010', '直辖市', '北京市'),
(100, '1300107', '010', '直辖市', '北京市'),
(101, '1300108', '010', '直辖市', '北京市'),
(102, '1300109', '010', '直辖市', '北京市'),
(103, '1300110', '010', '直辖市', '北京市'),
(104, '1300111', '010', '直辖市', '北京市'),
(105, '1300112', '010', '直辖市', '北京市'),
(106, '1300113', '010', '直辖市', '北京市'),
(107, '1300114', '010', '直辖市', '北京市'),
(108, '1300115', '010', '直辖市', '北京市'),
(109, '1300116', '010', '直辖市', '北京市'),
(110, '1300117', '010', '直辖市', '北京市'),
(111, '1300118', '010', '直辖市', '北京市'),
(112, '1300119', '010', '直辖市', '北京市'),
(113, '1300120', '010', '直辖市', '北京市'),
(114, '1300121', '010', '直辖市', '北京市'),
(115, '1300122', '010', '直辖市', '北京市'),
(116, '1300123', '010', '直辖市', '北京市'),
(117, '1300124', '010', '直辖市', '北京市'),
(118, '1300125', '010', '直辖市', '北京市'),
(119, '1300126', '010', '直辖市', '北京市'),
(120, '1300127', '010', '直辖市', '北京市'),
(121, '1300128', '010', '直辖市', '北京市'),
(122, '1300129', '010', '直辖市', '北京市'),
(123, '1300130', '022', '直辖市', '天津市'),
(124, '1300131', '022', '直辖市', '天津市'),
(125, '1300132', '022', '直辖市', '天津市'),
(126, '1300133', '022', '直辖市', '天津市'),
(127, '1300134', '022', '直辖市', '天津市'),
(128, '1300135', '022', '直辖市', '天津市'),
(129, '1300136', '022', '直辖市', '天津市'),
(130, '1300137', '022', '直辖市', '天津市'),
(131, '1300138', '022', '直辖市', '天津市'),
(132, '1300139', '022', '直辖市', '天津市'),
(133, '1300140', '0312', '河北省', '保定市'),
(134, '1300141', '0315', '河北省', '唐山市'),
(135, '1300142', '0335', '河北省', '秦皇岛'),
(136, '1300143', '0316', '河北省', '廊坊市'),
(137, '1300144', '0317', '河北省', '沧州市'),
(138, '1300145', '0319', '河北省', '邢台市'),
(139, '1300146', '0310', '河北省', '邯郸市'),
(140, '1300147', '0318', '河北省', '衡水市'),
(141, '1300148', '0317', '河北省', '沧州