Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


mysql latitude and longitude table setup


mysql latitude and longitude table setup  using -'mysql,spatial,latitude-longitude'

I want to store latitude and longitude values of places in a mysql database table. With the future in mind I will want to be able to find these places within a certain radius of a specific location. Having said that, what datatypes should I store the latitude and longitude values in? Please could you provide me with a create table script for columns like so:

place_id  |  lat  |  long


Is there perhaps a column I am missing in the above table that will provide me with additional information that I may not see I need at the current time?

Thanks for any help.
    

asked Sep 22, 2015 by thiru
0 votes
14 views



Related Hot Questions



Government Jobs Opening


...