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

5 votes119 views2 answers
Ranking functions in sql
SQL
2 votes113 views1 answer
Apex execute batch job
SQL
8 votes107 views1 answer
Oracle find text in functions
SQL
2 votes100 views1 answer
Wait delay in sql server
SQL
0 vote121 views1 answer
How to run mysql on terminal mac
SQL
0 vote121 views1 answer
Mysql show create db
SQL
0 vote103 views1 answer
SQL SELECT-Klausel
SQL
0 vote107 views1 answer
Can't connect to postgresql mac os
SQL
26 votes114 views2 answers
Mysql workbench download
SQL
3 votes117 views4 answers
Postgresql change timezone on timestamp without timezone
SQL