| 1234567891011 |
- -- The point_test table is created with the single ST_Point column pt1.
- CREATE TABLE point_test (pt1 ST_Point);
- -- The ST_PointFromText function converts the point text coordinates
- -- to the point format before the INSERT statement inserts the point
- -- into the pt1 column.
- INSERT INTO point_test VALUES(
- ST_PointFromText('point(10.01 20.03)', 1000)
- );
|
