12.16.3 Functions That Create Geometry Values from WKT Values

These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier (SRID). They return the corresponding geometry.

ST_GeomFromText() accepts a WKT value of any geometry type as its first argument. Other functions provide type-specific construction functions for construction of geometry values of each geometry type.

For a description of WKT format, see Well-Known Text (WKT) Format.

• GeomCollFromText(wkt [, srid]), GeometryCollectionFromText(wkt [, srid])

  ST_GeomCollFromText(), ST_GeometryCollectionFromText(), ST_GeomCollFromTxt(), GeomCollFromText(), and GeometryCollectionFromText() are synonyms. For more information, see the description of ST_GeomCollFromText().

  GeomCollFromText() and GeometryCollectionFromText() are deprecated; expect them to be removed in a future MySQL release. Use ST_GeomCollFromText() and ST_GeometryCollectionFromText() instead.

• GeomFromText(wkt [, srid]), GeometryFromText(wkt [, srid])

  ST_GeomFromText(), ST_GeometryFromText(), GeomFromText(), and GeometryFromText() are synonyms. For more information, see the description of ST_GeomFromText().

  GeomFromText() and GeometryFromText() are deprecated; expect them to be removed in a future MySQL release. Use ST_GeomFromText() and ST_GeometryFromText() instead.

• LineFromText(wkt [, srid]), LineStringFromText(wkt [, srid])

  ST_LineFromText(), ST_LineStringFromText(), LineFromText(), and LineStringFromText() are synonyms. For more information, see the description of ST_LineFromText().

  LineFromText() and LineStringFromText() are deprecated; expect them to be removed in a future MySQL release. Use ST_LineFromText() and ST_LineStringFromText() instead.

• MLineFromText(wkt [, srid]), MultiLineStringFromText(wkt [, srid])

  ST_MLineFromText(), ST_MultiLineStringFromText(), MLineFromText(), and MultiLineStringFromText() are synonyms. For more information, see the description of ST_MLineFromText().

  MLineFromText() and MultiLineStringFromText() are deprecated; expect them to be removed in a future MySQL release. Use ST_MLineFromText() and ST_MultiLineStringFromText() instead.

• MPointFromText(wkt [, srid]), MultiPointFromText(wkt [, srid])

  ST_MPointFromText(), ST_MultiPointFromText(), MPointFromText(), and MultiPointFromText() are synonyms. For more information, see the description of ST_MPointFromText().

  MPointFromText() and MultiPointFromText() are deprecated; expect them to be removed in a future MySQL release. Use ST_MPointFromText() and ST_MultiPointFromText() instead.

• MPolyFromText(wkt [, srid]), MultiPolygonFromText(wkt [, srid])

  ST_MPolyFromText(), ST_MultiPolygonFromText(), MPolyFromText(), and MultiPolygonFromText() are synonyms. For more information, see the description of ST_MPolyFromText().

  MPolyFromText() and MultiPolygonFromText() are deprecated; expect them to be removed in a future MySQL release. Use ST_MPolyFromText() and ST_MultiPolygonFromText() instead.

• PointFromText(wkt [, srid])

  ST_PointFromText() and PointFromText() are synonyms. For more information, see the description of ST_PointFromText().

  PointFromText() is deprecated; expect it to be removed in a future MySQL release. Use ST_PointFromText() instead.

• PolyFromText(wkt [, srid]), PolygonFromText(wkt [, srid])

  ST_PolyFromText(), ST_PolygonFromText(), PolyFromText(), and PolygonFromText() are synonyms. For more information, see the description of ST_PolyFromText().

  PolyFromText() and PolygonFromText() are deprecated; expect them to be removed in a future MySQL release. Use ST_PolyFromText() and ST_PolygonFromText() instead.

• ST_GeomCollFromText(wkt [, srid]), ST_GeometryCollectionFromText(wkt [, srid]), ST_GeomCollFromTxt(wkt [, srid])

  Constructs a GeometryCollection value using its WKT representation and SRID.

  If the geometry argument is NULL or not a syntactically well-formed geometry, or if the SRID argument is NULL, the return value is NULL.

  mysql> SET @g = "MULTILINESTRING((10 10, 11 11), (9 9, 10 10))";
  mysql> SELECT ST_AsText(ST_GeomCollFromText(@g));
  +--------------------------------------------+
  | ST_AsText(ST_GeomCollFromText(@g))         |
  +--------------------------------------------+
  | MULTILINESTRING((10 10,11 11),(9 9,10 10)) |
  +--------------------------------------------+

  ST_GeomCollFromText(), ST_GeometryCollectionFromText(), ST_GeomCollFromTxt(), GeomCollFromText(), and GeometryCollectionFromText() are synonyms.

• ST_GeomFromText(wkt [, srid]), ST_GeometryFromText(wkt [, srid])

  Constructs a geometry value of any type using its WKT representation and SRID.

  If the geometry argument is NULL or not a syntactically well-formed geometry, or if the SRID argument is NULL, the return value is NULL.

  ST_GeomFromText(), ST_GeometryFromText(), GeomFromText(), and GeometryFromText() are synonyms.

• ST_LineFromText(wkt [, srid]), ST_LineStringFromText(wkt [, srid])

  Constructs a LineString value using its WKT representation and SRID.

  If the geometry argument is NULL or not a syntactically well-formed geometry, or if the SRID argument is NULL, the return value is NULL.

  ST_LineFromText(), ST_LineStringFromText(), LineFromText(), and LineStringFromText() are synonyms.

• ST_MLineFromText(wkt [, srid]), ST_MultiLineStringFromText(wkt [, srid])

  Constructs a MultiLineString value using its WKT representation and SRID.

  If the geometry argument is NULL or not a syntactically well-formed geometry, or if the SRID argument is NULL, the return value is NULL.

  ST_MLineFromText(), ST_MultiLineStringFromText(), MLineFromText(), and MultiLineStringFromText() are synonyms.

• ST_MPointFromText(wkt [, srid]), ST_MultiPointFromText(wkt [, srid])

  Constructs a MultiPoint value using its WKT representation and SRID.

  If the geometry argument is NULL or not a syntactically well-formed geometry, or if the SRID argument is NULL, the return value is NULL.

  Functions such as ST_MPointFromText() and ST_GeomFromText() that accept WKT-format representations of MultiPoint values permit individual points within values to be surrounded by parentheses. For example, both of the following function calls are valid:

  ST_MPointFromText('MULTIPOINT (1 1, 2 2, 3 3)')
  ST_MPointFromText('MULTIPOINT ((1 1), (2 2), (3 3))')

  ST_MPointFromText(), ST_MultiPointFromText(), MPointFromText(), and MultiPointFromText() are synonyms.

• ST_MPolyFromText(wkt [, srid]), ST_MultiPolygonFromText(wkt [, srid])

  Constructs a MultiPolygon value using its WKT representation and SRID.

  If the geometry argument is NULL or not a syntactically well-formed geometry, or if the SRID argument is NULL, the return value is NULL.

  ST_MPolyFromText(), ST_MultiPolygonFromText(), MPolyFromText(), and MultiPolygonFromText() are synonyms.

• ST_PointFromText(wkt [, srid])

  Constructs a Point value using its WKT representation and SRID.

  If the geometry argument is NULL or not a syntactically well-formed geometry, or if the SRID argument is NULL, the return value is NULL.

  ST_PointFromText() and PointFromText() are synonyms.

• ST_PolyFromText(wkt [, srid]), ST_PolygonFromText(wkt [, srid])

  Constructs a Polygon value using its WKT representation and SRID.

  If the geometry argument is NULL or not a syntactically well-formed geometry, or if the SRID argument is NULL, the return value is NULL.

  ST_PolyFromText(), ST_PolygonFromText(), PolyFromText(), and PolygonFromText() are synonyms.