http://snipplr.com/users/zingo/tags/mysql Recent snippets posted on Snipplr.com en-us Sun, 07 Sep 2008 08:15:48 GMT http://snipplr.com/view/5761/storing-an-ip-address-in-a-database-table/ You can store an IP address in an INT UNSIGNED (4 bytes) which is of course much more efficient and faster than a CHAR(15). MySQL has two built-in functions: INET_ATON() and INET_NTOA(). These two functions are used allover the place in any TCP/IP stack implementation or even application. The INET_ATON() function converts Internet addresses from the numbers-and-dots notation into a 32-bit unsigned integer, and INET_NTOA() does the opposite.

]]> Wed, 09 Apr 2008 20:31:52 GMT http://snipplr.com/view/5761/storing-an-ip-address-in-a-database-table/ http://snipplr.com/view/4869/differences-between-two-tables/

]]> Fri, 01 Feb 2008 04:26:53 GMT http://snipplr.com/view/4869/differences-between-two-tables/ http://snipplr.com/view/3934/generate-simple-bar-charts-from-a-mysql-prompt/ You can generate a simple bar chart of the values by executing this command...

]]> Fri, 19 Oct 2007 00:40:13 GMT http://snipplr.com/view/3934/generate-simple-bar-charts-from-a-mysql-prompt/