3311
MySQLERRORNotableSpatial / GISHIGH confidence
Multiple best-match Spatial Reference Systems found
Production Risk
Low — query fails; no data is modified.
How to reproduce
trigger — this will error
trigger — this will error
-- Triggered internally when MySQL resolves SRS by name and finds duplicates.
expected output
ERROR 3311 (HY000): Multiple spatial reference systems match.
Fix
Use the explicit SRID
Use the explicit SRID
SELECT ST_GeomFromText('POINT(0 0)', 4326);Why this works
SRIDs are unique; using the integer ID avoids name-resolution ambiguity.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3311 ER_SRS_MULTIPLE_BEST_MATCHES
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev