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 then i saw in the table NULL values:
> SELECT AsText(g) FROM geom;
> | g |
> --------------------
> | NULL |
> | NULL |
> --------------------
You need 'POINT(1 1)' instead of 'POINT(1,1)'. It's a pity that MySQL
silently does something else instead of complaining loudly if the
input is incorrect.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
