After a while I couldn’t stand anymore the face of Pinal Dave on SQL Authority. I always check a specific thing that I haven’t been able to memorize…(Yes I need that memory allocation for something else, such as dialogs of Star Wars Phantom Menace PC Game) so I copied his article… but OK Pinal I’ll […]

Read More…

Posted in SQL

Ipv4 Addresses on MySQL

Did You know that you can store ip addresses on mysql with no string handling? Well, I did not. 12INSERT INTO ip_table (’ipv4’) VALUES (INET_ATON("")); SELECT INET_NTOA(’ipv4’) FROM ip_table; Well this does the trick, INET_ATON and INET_NTOA function transforms the ip address into his numeric value(Integer) and vice versa. el_avena Off… […]

Read More…