Snipplr

(SQL) Calculating distance in Kilometres and Miles from Latitude and Longitude - zingo

Tue, 01 Dec 2009 20:22:06 UTC

Using SQL you can have your database return the distance between 2 sets of Lat and Long points, and using some math functions also take into account the curvature of the earth.

(SQL) Storing an IP address in a database table - zingo

Wed, 09 Apr 2008 20:31:52 UTC

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.

(SQL) Differences between two Tables - zingo

Fri, 01 Feb 2008 04:26:53 UTC

(SQL) Generate Simple Bar Charts From a MySQL Prompt - zingo

Fri, 19 Oct 2007 00:40:13 UTC

You can generate a simple bar chart of the values by executing this command...