ST_GeomFromMySQL

Construct a Geometry from MySQL Geometry binary.

Signatures

ST_GeomFromMySQL (binary: Binary)

binary

Binary

required

The binary value.

The resulting geometry.

SELECT
    ST_GeomFromMySQL(geomWKB) AS geom,
    ST_SRID(ST_GeomFromMySQL(geomWKB)) AS srid
FROM mysql_table

+-------------+----+
|         geom|srid|
+-------------+----+
|POINT (20 10)|4326|
|POINT (40 30)|4326|
|POINT (60 50)|4326|
+-------------+----+

⌘I