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

10 votes252 views6 answers
Mysql set root password
SQL
10 votes216 views2 answers
Sql rtrim
SQL
0 vote218 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote205 views1 answer
Changer un mot de passe mysql
SQL
0 vote236 views1 answer
Ms sql print more than 1 variable
SQL
0 vote224 views1 answer
How to run mysql on terminal mac
SQL
0 vote245 views1 answer
Prisma transaction
SQL
2 votes212 views1 answer
Oracle number to percentage
SQL
12 votes215 views2 answers
Delete entries in postgresql
SQL
1 vote235 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL