Answers for "substr function in sqlite"

SQL
0

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)                         |
+--------------------------------------+
Posted by: Guest on May-19-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language