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 vote308 views1 answer
Sqlalchemy _in array sqlite
SQL
18 votes281 views3 answers
Find column name in database
SQL
0 vote259 views1 answer
Sqldf change user
SQL
0 vote302 views1 answer
Get only one row in mysql
SQL
1 vote292 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote256 views1 answer
Oracle index hint multiple tables example
SQL
0 vote290 views1 answer
Postgresql show owner of database
SQL
0 vote288 views1 answer
Ver usuarios mysql
SQL
0 vote272 views1 answer
Mariadb maximum left join
SQL
15 votes293 views5 answers
Show tables in oracle
SQL