Skip to content

Latest commit

 

History

History
155 lines (149 loc) · 2.95 KB

mysql.md

File metadata and controls

155 lines (149 loc) · 2.95 KB
Raw

MySQL

Functions

  • Area
  • AsBinary
  • AsText
  • Buffer
  • Contains
  • Crosses
  • Disjoint
  • ST_Disjoint
  • Envelope
  • GeomFromText
  • GLength
  • Intersects
  • LineStringFromWKB
  • LineString
  • MBRContains
  • MBRDisjoint
  • MBREqual
  • MBRIntersects
  • MBROverlaps
  • MBRTouches
  • MBRWithin
  • Overlaps
  • PointFromWKB
  • Point
  • StartPoint
  • ST_Contains
  • ST_Crosses
  • ST_Disjoint
  • ST_Equals
  • ST_Intersects
  • ST_Overlaps
  • ST_Touches
  • ST_Within
  • Touches
  • Within
  • StartPoint

New

  • ST_Area()
  • ST_AsBinary(), ST_AsWKB()
  • ST_AsGeoJSON()
  • ST_AsText(), ST_AsWKT()
  • ST_Buffer_Strategy()
  • ST_Buffer()
  • ST_Centroid()
  • ST_Contains()
  • ST_ConvexHull()
  • ST_Crosses()
  • ST_Difference()
  • ST_Dimension()
  • ST_Disjoint()
  • ST_Distance_Sphere()
  • ST_Distance()
  • ST_EndPoint()
  • ST_Envelope()
  • ST_Equals()
  • ST_ExteriorRing()
  • ST_GeoHash()
  • ST_GeomCollFromText(),ST_GeometryCollectionFromText(),ST_GeomCollFromTxt()
  • ST_GeomCollFromWKB(),ST_GeometryCollectionFromWKB()
  • ST_GeometryN()
  • ST_GeometryType()
  • ST_GeomFromGeoJSON()
  • ST_GeomFromText(), ST_GeometryFromText()
  • ST_GeomFromWKB()
  • ST_InteriorRingN()
  • ST_Intersection()
  • ST_Intersects()
  • ST_IsClosed()
  • ST_IsEmpty()
  • ST_IsSimple()
  • ST_IsValid()
  • ST_LatFromGeoHash()
  • ST_Length()
  • ST_LineFromText()
  • ST_LineFromWKB(), ST_LineStringFromWKB()
  • ST_LongFromGeoHash()
  • ST_MakeEnvelope()
  • ST_MLineFromText(), ST_MultiLineStringFromText()
  • ST_MLineFromWKB(), ST_MultiLineStringFromWKB()
  • ST_MPointFromText(), ST_MultiPointFromText()
  • ST_MPointFromWKB(), ST_MultiPointFromWKB()
  • ST_MPolyFromText(), ST_MultiPolygonFromText()
  • ST_MPolyFromWKB(), ST_MultiPolygonFromWKB()
  • ST_NumGeometries()
  • ST_NumInteriorRing(), ST_NumInteriorRings()
  • ST_NumPoints()
  • ST_Overlaps()
  • ST_PointFromGeoHash()
  • ST_PointFromText()
  • ST_PointFromWKB()
  • ST_PointN()
  • ST_PolyFromText(), ST_PolygonFromText()
  • ST_PolyFromWKB(), ST_PolygonFromWKB()
  • ST_SRID()
  • ST_StartPoint()
  • ST_SymDifference()
  • ST_Touches()
  • ST_Union()
  • ST_Validate()
  • ST_Within()
  • ST_X()
  • ST_Y()

Legacy

These methods are supported for legacy MySQL. MySQL Spatial 5.7.6 depreciates these functions.

  • Area() 
  • AsBinary(), AsWKB()
  • AsText(), AsWKT() 
  • Buffer() 
  • Centroid()
  • Contains()
  • ConvexHull()
  • Crosses()
  • Dimension()
  • Disjoint()
  • Distance()
  • EndPoint()
  • Envelope()
  • Equals()
  • ExteriorRing()
  • GeometryN()
  • GeometryType()
  • GeomFromText(), GeometryFromText()
  • GeomFromWKB()
  • InteriorRingN()
  • Intersects()
  • IsClosed()
  • IsEmpty()
  • IsSimple()
  • LineFromText()
  • LineFromWKB(), LineStringFromWKB()
  • MLineFromText(), MultiLineStringFromText()
  • MLineFromWKB(), MultiLineStringFromWKB()
  • MPointFromText(), MultiPointFromText()
  • MPointFromWKB(), MultiPointFromWKB()
  • MPolyFromText(), MultiPolygonFromText()
  • MPolyFromWKB(), MultiPolygonFromWKB()
  • NumGeometries()
  • NumInteriorRings()
  • NumPoints()
  • Overlaps()
  • PointFromText()
  • PointFromWKB()
  • PointN()
  • PolyFromText(), PolygonFromText()
  • PolyFromWKB(), PolygonFromWKB()
  • X()
  • Y()