[Level 3] Enhance to save ip address in MySQL

What data type will you define the column for ip values.
Usually I got the answer is char(15).
But should we really have to set char(15)?
Any way to reduce the data size for saving ip data?
Yes, you can use "Int Unsigned" data type to save it!
Int??? Yes just Int!
At the same time you have to use another two stored routine for it, called
"inet_aton()" and "inet_ntoa()".
inet_aton() is the routine to convert the ip address from domain to integer.
inet_ntoa() is the routine to convert the integer to ip address domain value.

my sample as the following:

mysql> create table ip_table (ipaddr int unsigned); Query OK, 0 rows affected (0.01 sec)
mysql>
mysql> insert into ip_table values (inet_aton('127.0.0.1')), (inet_aton('255.255.255.0'));
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql>
mysql> select inet_ntoa(ipaddr) from ip_table;
+-------------------+
| inet_ntoa(ipaddr) |
+-------------------+
| 127.0.0.1         |
| 255.255.255.0     |
+-------------------+
2 rows in set (0.00 sec)
 
mysql>

Wish this helps.

regards,
Stanley Huang

Comments

Post a Comment

Popular posts from this blog

[Level 1] Rar tool for Solaris.

Sometimes we will got a rar compressed file from our friends, but there is no default tool in OpenSolaris to decompress the rar filess. We can got a Solaris Intel version from rarlab . The steps as the following: 1. down load the rar tools from rarlab. http://www.rarlab.com/rar_add.htm 2. uncompressed the source. # gunzip ./unrar-sol-intel.gz 3. move it to the location you used to. # mv /unrar-sol-intel.gz /usr/bin/unrar 4. try to decomprss # unrar x ./test.rar Wish this helps. regards, Stanley Huang
Read more

[Level 2] iif in Python

If you want to implement iif in Python, please refer to the following sample code: #!/bin/env python def iif(b): return 'It\'s True' if b else 'It\'s False' print iif(True) print iif(False) And the following sample, guess what will you get! #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % 'Ture' if b else 'False' Result: $ ./iif.py b: Ture False The second result is "False", not "b: False". Why??? Because the prededence of string concatenation is higher than if. Therefore you need to use () to make it correct. #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % ('Ture' if b else 'False') Wish this helps. regards, Stanley Huang
Read more