Sql

Search

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]}            |
+-------------------------------------------------------------+

Comment

PREVIOUS	NEXT

Code Example
Sql :: get yesterday date ISO in psql
Sql :: groupby error in mysql
Sql :: oracle convert run duration to number
Sql :: sql convert date format
Sql :: mysql auerries to find the name starting with vowel letter
Sql :: postgresql parse json array
Sql :: mysql ilike
Sql :: FIND AVERAGE SALARY EARNER IN SQL
Sql :: sql find table by name
Sql :: oracle nvl
Sql :: unique key in ms sql server
Sql :: sql integer to serial
Sql :: SQL Duplicates by Composite
Sql :: SQL COUNT() With HAVING Clause
Sql :: alter or change postgresql sequence counter
Sql :: show table info mysql
Sql :: sql count how many times a value appears
Sql :: mysql biginteger size
Sql :: Get all index postgres
Sql :: sql column name
Sql :: eliminar ultimo carcacter mysql
Sql :: get triggers by query
Sql :: sql online
Sql :: oracle create table as select
Sql :: order by multiple columns
Sql :: convert html to plain text in sql server
Sql :: nth highest salary in sql
Sql :: SQL COUNT() with GROUP BY
Sql :: insert select
Sql :: psql check if value in array

Search

SQL

mysql 8 geo to json

ADD CONTENT