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 vote144 views1 answer
Postgresql create table with timestamp
SQL
0 vote130 views1 answer
Cast for print sql
SQL
0 vote148 views1 answer
Psql show db
SQL
3 votes145 views5 answers
No module named 'MySQLdb'
SQL
5 votes151 views1 answer
Oracle nls instance
SQL
0 vote139 views1 answer
Get substract count sql
SQL
0 vote138 views1 answer
SQL authentication error
SQL
17 votes131 views4 answers
Show tables sql server
SQL
0 vote159 views1 answer
Mysql dump with table query
SQL
0 vote134 views1 answer
Default column value in sql same as other column
SQL