http://snipplr.com/users/zingo/tags/database Recent snippets posted on Snipplr.com en-us Thu, 16 Oct 2008 18:00:20 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/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/