Hello.
Remove coma from 'POINT(1,1)', instead use 'POINT(1 1)';
See:
http://dev.mysql.com/doc/mysql/en/Populating_spatial_columns.html
>I installed mySQL server from Wizard and then i create table:
>create table geom ( g POINT) ENGINE = MYISAM;
>but i can't add any object to the table
In article <[EMAIL PROTECTED]>,
"Rafal K." <[EMAIL PROTECTED]> writes:
> I installed mySQL server from Wizard and then i create table:
> create table geom ( g POINT) ENGINE = MYISAM;
> but i can't add any object to the table. I wrote:
> insert into geom values(PointFromText('POINT(1,1)'));
> and t
I installed mySQL server from Wizard and then i create table:
create table geom ( g POINT) ENGINE = MYISAM;
but i can't add any object to the table. I wrote:
insert into geom values(PointFromText('POINT(1,1)'));
and then i saw in the table NULL values:
SELECT AsText(g) FROM geom;
| g
