Geopoint from json mysql function

Press CTRL+C to copy mysql> SET @json = '{ "type": "Point", "coordinates": [102.0, 0.0]}';
mysql> SELECT ST_AsText(ST_GeomFromGeoJSON(@json));
+--------------------------------------+
| ST_AsText(ST_GeomFromGeoJSON(@json)) |
+--------------------------------------+
| POINT(102 0)                         |
+--------------------------------------+

Source: dev.mysql.com

Similar codes

0 vote417 views1 answer
Pagination with row_number
SQL
0 vote357 views1 answer
Call function sql oracle with output put line
SQL
0 vote358 views1 answer
Why we have to set the password for my sql server
SQL
0 vote340 views1 answer
Get first monday of month sql
SQL
0 vote322 views1 answer
How to check replication lag in mySQL
SQL
0 vote357 views1 answer
Sql select min
SQL
9 votes364 views5 answers
Laravel to sql
SQL
5 votes340 views2 answers
Mysql drop table cascade
SQL
1 vote369 views1 answer
Postgres power
SQL
0 vote372 views1 answer
Renombrar tabla mysql
SQL