Organizational Research By

Surprising Reserch 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

Related Hot Questions

1 Answer

0 votes
answered Sep 22, 2015 by gauravg.gwl