> ## Documentation Index
> Fetch the complete documentation index at: https://docs.wherobots.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ST_GeomFromMySQL

Construct a Geometry from MySQL Geometry binary.

## Signatures

```sql theme={"system"}
ST_GeomFromMySQL (binary: Binary)
```

## Parameters

<ParamField body="binary" type="Binary" required>
  The binary value.
</ParamField>

## Return type

<ResponseField type="Geometry">
  The resulting geometry.
</ResponseField>

## Example

```sql theme={"system"}
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|
+-------------+----+
```