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

2 votes356 views1 answer
How to delete all duplicate items in mysql
SQL
1 vote321 views1 answer
Mysqli connect
SQL
0 vote373 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote341 views1 answer
Varchar format not case sensitive sql
SQL
1 vote342 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote353 views1 answer
Postgres sequence name
SQL
5 votes365 views3 answers
MySql get fields of table
SQL
0 vote350 views1 answer
Firebird where
SQL
0 vote395 views1 answer
Fetching data from mysqldb
SQL
2 votes369 views4 answers
Check timezone of mysql database
SQL