zingo

Member since 06/17/2007

Location: Berlin/Germany

5 snippets

9407 profile views

4 Comment(s) Posted

their Tags

svn Bash osx css debug xml mysql database sql find file style data log php cakephp flash convert regex perl template git math htaccess email google filter search login security iphone

Profile

Achievement

zingo's Recent SnippetsTagged mysql

All /

« Prev 1 Next »

SQL Calculating distance in Kilometres and Miles from Latitude and Longitude

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.

mysql

3 1172 posted 14 years ago by zingo

MySQL MySQL table size, number of rows, and size of indexes

Show table size, number of rows, and size of indexes in MySQL.

mysql

1 1142 posted 15 years ago by zingo

SQL 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 s...

mysql

0 1081 posted 16 years ago by zingo

SQL Differences between two Tables

mysql

1 1004 posted 16 years ago by zingo

SQL Generate Simple Bar Charts From a MySQL Prompt

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

mysql

0 895 posted 17 years ago by zingo