Not the answer you need?
Register and ask your own question!

Incorrect arguments to st_distance_sphere with request

evgeniy123evgeniy123 EntrantLegacy User Role Beginner
I get an error when I get this request

SELECT patch, x.id, type, geo_address, place_name, x(coordinates) as lat, y(coordinates) as lng, x.updated_at, x.created_at, x.distance FROM
(SELECT * ,(ST_Distance_Sphere(ST_GeomFromText('POINT(2.34 148.86)') , coordinates, 6373)) AS distance FROM `geo` ) x

Normally POINT(LAT LNG) but why I get this error ? Thx
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.