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 vote193 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
2 votes196 views3 answers
Postgres create view
SQL
0 vote196 views1 answer
Materialized view redshift
SQL
0 vote230 views1 answer
How to use sqlcommand
SQL
1 vote182 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote180 views1 answer
Max mysql
SQL
3 votes195 views1 answer
Get current month last date in sql server
SQL
0 vote177 views1 answer
Docker export psql sql
SQL
1 vote189 views1 answer
Postgres left join
SQL
0 vote179 views1 answer
Mysql add comment to column
SQL