ST_PointFromText()

ST_PointFromText creates a POINT geometry from WKT.

Syntax

ST_PointFromText(wkt)

Aliases: None.

Arguments

Argument

Description

wkt

VARCHAR WKT.

Return Value

Returns a GEOMETRY value.

Usage Notes

Examples

DROP DATABASE IF EXISTS geo_io_example;
CREATE DATABASE geo_io_example;
USE geo_io_example;

SELECT ST_AsText(ST_PointFromText('POINT(1 2)')) AS point;

DROP DATABASE geo_io_example;

See Also

ST_PointFromWKB(), ST_GeomFromText().