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 vote194 views1 answer
Ceil upto 2 decimal place mysql
SQL
12 votes200 views10 answers
Google
SQL
0 vote186 views1 answer
Alter domain sql
SQL
0 vote154 views1 answer
Trigger value from maltiple table to single table mysql
SQL
25 votes173 views4 answers
Metadata
SQL
0 vote172 views1 answer
Query for backup a database at another location in file system
SQL
0 vote158 views1 answer
Select sql in descending order
SQL
10 votes159 views2 answers
Show tables in schema oracle
SQL
0 vote165 views1 answer
Big table in mysql
SQL
2 votes235 views2 answers
How to DROP a table in mysql
SQL