zingo

Member since 2007

4 snippets

26986 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 sql

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.

3 2785 posted 16 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.

1 2487 posted 17 years ago by zingo

SQL Differences between two Tables

1 2147 posted 18 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...

0 2006 posted 18 years ago by zingo