要存储在mysql数据库中的经度和纬度的数据类型？

Question

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?

Answer 1

You can use spatial extensions in mysql the datatype is POINT

It will be faster in search , and many features for geographic operation.