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

1 vote127 views3 answers
How to filter repeated same result using sql query
SQL
1 vote149 views3 answers
How to reset id column in sql server
SQL
0 vote150 views1 answer
How to login to mysql in homestead
SQL
0 vote136 views1 answer
Postgres select except
SQL
4 votes96 views1 answer
And or sql order of operations
SQL
-1 vote144 views3 answers
My sql alter table
SQL
0 vote139 views1 answer
Kill a pid redshift
SQL
5 votes163 views2 answers
Mysql where in array
SQL
2 votes168 views1 answer
Find column in all stored procedures sql server
SQL
0 vote140 views1 answer
See Foreign Key
SQL