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 […]
Category: SQL
SQL Server Trick!
I Found this on the web, so I wanted to share it and keep it for the future… This small SQL script disconnects all users from a given el_avena off… […]
Ipv4 Addresses on MySQL
Did You know that you can store ip addresses on mysql with no string handling? Well, I did not. INSERT INTO ip_table (’ipv4’) VALUES (INET_ATON("127.0.0.1")); 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… […]