How to store Latitude and Longitude in MySQL
CREATE TABLE `test_lat_long` (
`lat_long` POINT NOT NULL,
SPATIAL INDEX `SPATIAL` (`lat_long`)
) ;
`lat_long` POINT NOT NULL,
SPATIAL INDEX `SPATIAL` (`lat_long`)
) ;
INSERT INTO `test_lat_long`
(`lat_long`)
VALUES
(POINT(40.71727401,-74.00898606));
(`lat_long`)
VALUES
(POINT(40.71727401,-74.00898606));
SELECT * FROM test_lat_long;
Tags:
Mysql