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 vote413 views1 answer
Sql doesn't contain
SQL
0 vote337 views2 answers
How to know the character set of an oracle databes
SQL
27 votes335 views4 answers
Get all tables with column name sql
SQL
0 vote333 views1 answer
Mysql two joins
SQL
0 vote388 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
1 vote334 views1 answer
Sql eliminare un record
SQL
0 vote378 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote353 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote321 views1 answer
Find number of entries sql
SQL
0 vote359 views1 answer
Copying query result to excel
SQL