中国2014全国ip地址库mysql版
立即下载
资源介绍:
全国ip地址库--mysql.sql文件版(001压缩版),可通过Mysql的ip处理函数inet_aton('ip')查找指定ip段,收录2014年以前全国的所有ip地址,有几十万条数据,有需要的朋友可以下载,后续会继续收录,发出,希望能对大家有所帮助,谢谢,数据库格式如下:
id start_ip end_ip province_city area
443 14.151.0.0 14.151.255.255 广东省广州市 电信
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50045
Source Host : localhost:3306
Source Database : fyt
Target Server Type : MYSQL
Target Server Version : 50045
File Encoding : 65001
Date: 2014-12-07 23:00:47
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for ip_address
-- ----------------------------
DROP TABLE IF EXISTS `ip_address`;
CREATE TABLE `ip_address` (
`id` int(11) unsigned zerofill NOT NULL auto_increment,
`start_ip` varchar(50) default NULL,
`end_ip` varchar(50) default NULL,
`province_city` varchar(50) default NULL,
`area` varchar(255) default NULL,
PRIMARY KEY (`id`),
KEY `index_start_ip` (`start_ip`),
KEY `index_end_ip` (`end_ip`)
) ENGINE=InnoDB AUTO_INCREMENT=444080 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ip_address
-- ----------------------------
INSERT INTO `ip_address` VALUES ('00000000004', '1.0.1.0', '1.0.3.255', '福建省', '电信');
INSERT INTO `ip_address` VALUES ('00000000006', '1.0.8.0', '1.0.15.255', '广东省', '电信');
INSERT INTO `ip_address` VALUES ('00000000008', '1.0.32.0', '1.0.63.255', '广东省', '电信');
INSERT INTO `ip_address` VALUES ('00000000011', '1.1.0.0', '1.1.0.255', '福建省', '电信');
INSERT INTO `ip_address` VALUES ('00000000013', '1.1.2.0', '1.1.7.255', '福建省', '电信');
INSERT INTO `ip_address` VALUES ('00000000014', '1.1.8.0', '1.1.63.255', '广东省', '电信');
INSERT INTO `ip_address` VALUES ('00000000017', '1.2.0.0', '1.2.1.255', '福建省', '电信');
INSERT INTO `ip_address` VALUES ('00000000018', '1.2.2.0', '1.2.2.255', '北京市海淀区', '北龙中网(北京)科技有限责任公司');
INSERT INTO `ip_address` VALUES ('00000000020', '1.2.4.0', '1.2.4.7', '福建省', '电信');
INSERT INTO `ip_address` VALUES ('00000000021', '1.2.4.8', '1.2.4.8', '北京市', '中国互联网络信息中心SDNS服务器');
INSERT INTO `ip_address` VALUES ('00000000022', '1.2.4.9', '1.2.7.255', '福建省', '电信');
INSERT INTO `ip_address` VALUES ('00000000023', '1.2.8.0', '1.2.8.255', '中国', '网络信息中心');
INSERT INTO `ip_address` VALUES ('00000000024', '1.2.9.0', '1.2.127.255', '广东省', '电信');
INSERT INTO `ip_address` VALUES ('00000000026', '1.3.0.0', '1.3.255.255', '广东省', '电信');
INSERT INTO `ip_address` VALUES ('00000000028', '1.4.1.0', '1.4.3.255', '福建省', '电信');
INSERT INTO `ip_address` VALUES ('00000000029', '1.4.4.0', '1.4.4.255', '北京市海淀区', '北龙中网(北京)科技有限责任公司');
INSERT INTO `ip_address` VALUES ('00000000030', '1.4.5.0', '1.4.63.255', '福建省', '电信');
INSERT INTO `ip_address` VALUES ('00000000031', '1.4.64.0', '1.4.127.255', '广东省', '电信');
INSERT INTO `ip_address` VALUES ('00000000035', '1.8.0.0', '1.8.255.255', '北京市海淀区', '北龙中网(北京)科技有限责任公司');
INSERT INTO `ip_address` VALUES ('00000000037', '1.10.0.0', '1.10.9.255', '福建省', '电信');
INSERT INTO `ip_address` VALUES ('00000000039', '1.10.11.0', '1.10.15.255', '福建省', '电信');
INSERT INTO `ip_address` VALUES ('00000000040', '1.10.16.0', '1.10.127.255', '广东省', '电信');
INSERT INTO `ip_address` VALUES ('00000000043', '1.12.0.0', '1.15.255.255', '北京市', '北京北大方正宽带网络科技有限公司');
INSERT INTO `ip_address` VALUES ('00000000048', '1.24.0.0', '1.24.63.255', '内蒙古呼和浩特市', '联通');
INSERT INTO `ip_address` VALUES ('00000000050', '1.24.124.0', '1.24.124.255', '内蒙古巴彦淖尔市', '联通');
INSERT INTO `ip_address` VALUES ('00000000052', '1.24.128.0', '1.24.140.255', '内蒙古鄂尔多斯市', '联通');
INSERT INTO `ip_address` VALUES ('00000000053', '1.24.141.0', '1.24.141.255', '内蒙古鄂尔多斯市达拉特旗', '联通');
INSERT INTO `ip_address` VALUES ('00000000054', '1.24.142.0', '1.24.191.255', '内蒙古鄂尔多斯市', '联通');
INSERT INTO `ip_address` VALUES ('00000000055', '1.24.192.0', '1.25.127.255', '内蒙古包头市', '联通');
INSERT INTO `ip_address` VALUES ('00000000059', '1.25.204.0', '1.25.226.255', '内蒙古包头市', '联通');
INSERT INTO `ip_address` VALUES ('00000000061', '1.25.234.0', '1.25.255.255', '内蒙古巴彦淖尔市', '联通');
INSERT INTO `ip_address` VALUES ('00000000062', '1.26.0.0', '1.26.19.255', '内蒙古赤峰市', '联通');
INSERT INTO `ip_address` VALUES ('00000000063', '1.26.20.0', '1.26.20.255', '内蒙古呼伦贝尔市', '联通');
INSERT INTO `ip_address` VALUES ('00000000064', '1.26.21.0', '1.26.255.255', '内蒙古赤峰市', '联通');
INSERT INTO `ip_address` VALUES ('00000000065', '1.27.0.0', '1.27.15.255', '内蒙古通辽市', '联通');
INSERT INTO `ip_address` VALUES ('00000000066', '1.27.16.0', '1.27.31.255', '内蒙古呼伦贝尔市', '联通');
INSERT INTO `ip_address` VALUES ('00000000067', '1.27.32.0', '1.27.63.255', '内蒙古赤峰市', '联通');
INSERT INTO `ip_address` VALUES ('00000000068', '1.27.64.0', '1.27.87.255', '内蒙古呼伦贝尔市', '联通');
INSERT INTO `ip_address` VALUES ('00000000069', '1.27.88.0', '1.27.111.255', '内蒙古赤峰市', '联通');
INSERT INTO `ip_address` VALUES ('00000000071', '1.28.192.0', '1.28.255.255', '内蒙古包头市', '联通');
INSERT INTO `ip_address` VALUES ('00000000073', '1.32.0.0', '1.32.255.255', '香港', '');
INSERT INTO `ip_address` VALUES ('00000000075', '1.34.0.0', '1.35.255.255', '台湾省', '中华电信股份有限公司');
INSERT INTO `ip_address` VALUES ('00000000076', '1.36.0.0', '1.36.255.255', '香港', '电讯盈科有限公司');
INSERT INTO `ip_address` VALUES ('00000000080', '1.45.0.0', '1.45.255.255', '北京市', '万网志成科技有限公司');
INSERT INTO `ip_address` VALUES ('00000000082', '1.48.0.0', '1.48.255.255', '贵州省贵阳市', '电信');
INSERT INTO `ip_address` VALUES ('00000000083', '1.49.0.0', '1.49.63.255', '贵州省贵阳市云岩区', '电信');
INSERT INTO `ip_address` VALUES ('00000000084', '1.49.64.0', '1.49.76.255', '贵州省贵阳市', '电信');
INSERT INTO `ip_address` VALUES ('00000000085', '1.49.77.0', '1.49.77.255', '贵州省遵义市', '电信');
INSERT INTO `ip_address` VALUES ('00000000086', '1.49.78.0', '1.49.111.255', '贵州省贵阳市', '电信');
INSERT INTO `ip_address` VALUES ('00000000087', '1.49.112.0', '1.49.112.255', '贵州省六盘水市', '电信');
INSERT INTO `ip_address` VALUES ('00000000088', '1.49.113.0', '1.49.117.255', '贵州省贵阳市', '电信');
INSERT INTO `ip_address` VALUES ('00000000089', '1.49.118.0', '1.49.118.255', '贵州省铜仁地区', '电信');
INSERT INTO `ip_address` VALUES ('00000000090', '1.49.119.0', '1.49.166.255', '贵州省贵阳市', '电信');
INSERT INTO `ip_address` VALUES ('00000000091', '1.49.167.0', '1.49.167.255', '贵州省黔西南州兴义市', '电信');
INSERT INTO `ip_address` VALUES ('00000000092', '1.49.168.0', '1.49.188.255', '贵州省贵阳市', '电信');
INSERT INTO `ip_address` VALUES ('00000000093', '1.49.189.0', '1.49.189.255', '贵州省黔南州都匀市', '电信');
INSERT INTO `ip_address` VALUES ('00000000094', '1.49.190.0', '1.49.191.255', '贵州省贵阳市', '电信');
INSERT INTO `ip_address` VALUES ('00000000095', '1.49.192.0', '1.49.255.255', '贵州省安顺市', '电信');
INSERT INTO `ip_address` VALUES ('00000000097', '1.51.0.0', '1.51.119.255', '山东省济南市', '山东大学');
INSERT INTO `ip_address` VALUES ('00000000098', '1.51.120.0', '1.51.127.255', '安徽省合肥市', '合肥师范大学');
INSERT INTO `ip_address` VALUES ('00000000099', '1.51.128.0', '1.51.143.255', '山东省济南市', '山东大学');
INSERT INTO `ip_address` VALUES ('00000000100', '1.51.144.0', '1.51.159.255', '山东省济南市', '山东女子大学');
INSERT INTO `ip_address` VALUES ('00000000101', '1.51.160.0', '1.51
资源文件列表:
ip_address-全国.zip 大约有1个文件
- ip_address.sql 41.58MB