Profile
Achievement


zingo's Recent SnippetsTagged mysql
- All /
« 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
1257
posted 15 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
1141
posted 16 years ago by zingo
You can generate a simple bar chart of the values by executing this command...
0
960
posted 17 years ago by zingo