IP address stored in Mysql

This article describes how to optimize IP fields in mysql data tables. Create a test table mysqlcreatetablehosts (

This article describes how to optimize IP fields in mysql data tables. Create a test table mysql create table hosts (-'id' int (8) not null auto_increment,-'IP' int unsigned not null,-'hostname' varchar (30) not null, -'desc' varchar (100),-primary key ('id') ENGINE = InnoDB; Q

This article describes how to optimize IP fields in mysql data tables.

Create test table

mysql> create table hosts(  -> `id` int(8) not null auto_increment, -> `ip` int unsigned not null, -> `hostname` varchar(30) not null, -> `desc` varchar(100) ,  -> PRIMARY KEY(`id`)) ENGINE=InnoDB;Query OK, 0 rows affected (0.03 sec)

View table structure

mysql> desc hosts -> ;+----------+------------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+----------+------------------+------+-----+---------+----------------+| id | int(8) | NO | PRI | NULL | auto_increment || ip | int(10) unsigned | NO | | NULL | || hostname | varchar(30) | NO | | NULL | || desc | varchar(100) | YES | | NULL | |+----------+------------------+------+-----+---------+----------------+4 rows in set (0.00 sec)

Insert Test Data

mysql> insert into hosts (`ip`,`hostname`,`desc`) values (inet_aton('192.168.1.106'),'test','this is test host.');Query OK, 1 row affected (0.03 sec)

mysql> select * from hosts -> ;+----+------------+----------+--------------------+| id | ip | hostname | desc |+----+------------+----------+--------------------+| 1 | 3232235882 | test | this is test host. |+----+------------+----------+--------------------+1 row in set (0.00 sec)

Query

mysql> select inet_ntoa(ip) from hosts;+---------------+| inet_ntoa(ip) |+---------------+| 192.168.1.106 |+---------------+1 row in set (0.00 sec)

Original address: the IP address stored in Mysql. Thank you for sharing it with the original author.