: Tuesday, December 16, 2003 5:48 PM
To: Steven Roussey; [EMAIL PROTECTED]
Cc: 'Matt Lynch'
Subject: Re: Spatial Extension in MySQL 4.1.1-alpha
At 16:03 -0800 12/16/03, Steven Roussey wrote:
You did an insert this way:
mysql insert into geom values(GeomFromText('POINT(1,1)'));
and expected results
Hi,
I am trying out the new GIS capabilities in MySQL 4.1.1-alpha (windows)
and I am trying to follow some of the examples from chapter 10 in the
manual.
Here is a snap shot of my run
mysql create table geom(g geometry);
Query
You did an insert this way:
mysql insert into geom values(GeomFromText('POINT(1,1)'));
and expected results this way:
mysql select AsText(g) from geom;
+---+
| AsText(g) |
+---+
| Point(1 1)|
+---+
1 row in set (0.00 sec)
The formatting of the POINT
At 16:03 -0800 12/16/03, Steven Roussey wrote:
You did an insert this way:
mysql insert into geom values(GeomFromText('POINT(1,1)'));
and expected results this way:
mysql select AsText(g) from geom;
+---+
| AsText(g) |
+---+
| Point(1 1)|
+---+
1 row in