zingo


Member since 06/17/2007

zingo

Location: Berlin/Germany

5 snippets

1247 profile views

4 Comment(s) Posted

View their favorites

Profile

Achievement

first submission:submitting first snipplet popular snippet:having a snipplet with 20 favorites

zingo's Recent SnippetsTagged mysql



« Prev 1 Next »
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 162 posted 10 years ago by zingo
Show table size, number of rows, and size of indexes in MySQL.
1 209 posted 11 years ago by zingo
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...
0 156 posted 12 years ago by zingo
1 146 posted 12 years ago by zingo
You can generate a simple bar chart of the values by executing this command...
0 127 posted 12 years ago by zingo
« Prev 1 Next »