I'm designing a table in mysql that will store a list of users and a Google Maps co-ordinate (longitude & latitude).
Will I need two fields, or can it be done with 1?
I don't know what I use?
what I use float or decimal or GEOMETRY or there is new data type?
what are the pros and cons of the best data type to choose it?
Best Answer
You can use spatial extensions in mysql the datatype is POINT
It will be faster in search , and many features for geographic operation.