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 vote243 views1 answer
Sql gap missing values
SQL
0 vote298 views1 answer
Joomla execute raw sql
SQL
0 vote265 views1 answer
How to display value of variable in mysql
SQL
31 votes254 views3 answers
Sql count(*)
SQL
0 vote278 views1 answer
Edit shchima table in sql
SQL
3 votes262 views1 answer
Oracle revoke
SQL
0 vote239 views1 answer
Como leer datos de mysql esp32
SQL
1 vote275 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
1 vote262 views1 answer
Rename table column name in mysql
SQL
4 votes276 views2 answers
Oracle last day of month
SQL