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

25 votes147 views4 answers
Import mysql dump command line
SQL
0 vote148 views1 answer
Get last updated row sql server
SQL
0 vote146 views1 answer
How to alter length character varying postgres
SQL
0 vote159 views1 answer
Inner join distinct
SQL
0 vote146 views1 answer
Insert value in identity
SQL
10 votes117 views3 answers
Join multiple tables sql
SQL
2 votes133 views5 answers
Tablespace ORACLE
SQL
0 vote159 views1 answer
Wordpress sql find and replace
SQL
1 vote131 views2 answers
ImportError: No module named mysql.connector
SQL
3 votes178 views1 answer
How to get yesterday date in sql
SQL