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

13 votes120 views2 answers
Oracle all source
SQL
9 votes185 views3 answers
Mysql run sql file
SQL
5 votes173 views1 answer
Oracle nls parameters
SQL
2 votes134 views1 answer
Oracle sql drop column if exists
SQL
0 vote176 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote169 views1 answer
Sql change default collation to utf8
SQL
0 vote185 views1 answer
Add two days to current date in sql when creating tables
SQL
1 vote184 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote185 views1 answer
Mysql date equals to current_date plus days
SQL
3 votes179 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL