Mysql 8 geo to json

// second argument is max decimal degits
mysql> SELECT ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2);

+-------------------------------------------------------------+
| ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2) |
+-------------------------------------------------------------+
| {"type": "Point", "coordinates": [11.11, 12.22]}            |
+-------------------------------------------------------------+

Source: dev.mysql.com

Similar codes

0 vote129 views2 answers
Temp tables in sql server
SQL
6 votes129 views2 answers
Mysqldump password in file
SQL
0 vote145 views1 answer
Add mysql database to power bi web
SQL
0 vote259 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote132 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote130 views1 answer
Sintaxis SELECT sql
SQL
0 vote130 views1 answer
ORA-13717
SQL
0 vote161 views1 answer
Mysql get hour from datetime
SQL
4 votes134 views1 answer
Mysql ip address data type
SQL
5 votes152 views2 answers
Mysql create database charset utf8mb4
SQL