MaxInterview - mysql 8 geo to json

showing results for - "mysql 8 geo to json"

08 Jan 2017

1// second argument is max decimal degits
2mysql> SELECT ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2);
3
4+-------------------------------------------------------------+
5| ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2) |
6+-------------------------------------------------------------+
7| {"type": "Point", "coordinates": [11.11, 12.22]}            |
8+-------------------------------------------------------------+

source

similar questions

jpa generationtype sequence mysql round decimal mysql mysql equivalent decode oracle mysql connection string round one decimal place mysql mysql text to decimal mysql url data type parsing float to int in mysql connection string mysql mysql string position geopoint from json mysql function mysql date to string radius search with point data in mysql convert polygon to text in mysql mysql decimal mysql parse int

queries leading to this page

mysql to geojson mysql 8 geo to json mysql function gonano st asgeojson does not exist geo json from mysql mysql 8 geo to json

mysql 8 geo to json

Solutions on MaxInterview for mysql 8 geo to json by the best coders in the world