1 of 1

ST_PointFromText

Constructs a Point value using its WKT representation and an optional SRID.

Syntax

ST_PointFromText(wkt[,srid])
PointFromText(wkt[,srid])

Description

Constructs a POINT value using its WKT representation and SRID.

ST_PointFromText() and PointFromText() are synonyms.

Examples

_{This page is licensed: GPLv2, originally from}

CREATE TABLE gis_point  (g POINT);
SHOW FIELDS FROM gis_point;
INSERT INTO gis_point VALUES
    (PointFromText('POINT(10 10)')),
    (PointFromText('POINT(20 10)')),
    (PointFromText('POINT(20 20)')),
    (PointFromWKB(AsWKB(PointFromText('POINT(10 20)'))));