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 vote276 views1 answer
Mysql backup skip table
SQL
8 votes268 views1 answer
Database backup in mysql server recovery
SQL
5 votes278 views3 answers
Sql max value in column
SQL
1 vote263 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote269 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote269 views1 answer
Oracle procedure chain step
SQL
4 votes264 views1 answer
Adding data to table in sql python
SQL
0 vote281 views1 answer
Sql on-premises
SQL
1 vote265 views1 answer
Oracle list constraints
SQL
0 vote271 views1 answer
Complete date is 1 year or not sql server
SQL