+---------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| user_id | int(11) | NO | UNI | NULL | |
| utm | point | NO | MUL | NULL | |
+---------+---------+------+-----+---------+----------------+
insert into life(user_id, utm) values(99,point(4,4));
ERROR 1416 (22003): Cannot get geometry object from data you send to the GEOMETRY field
views:
179answers:
1
+2
A:
Have you tried:
insert into life(user_id, utm) values(99,PointFromWKB(POINT(4,4)));
f3lix
2010-02-15 15:51:47
According to http://bit.ly/9r97o5, this is only required on MySQL versions prior to 5.1.35. Starting with 5.1.35, you can insert the return value from Point() directly.
Michael Madsen
2010-02-15 15:54:57
Are function names case sensitive in mySQL?
Pekka
2010-02-15 16:05:18
Did you mean MySQL? :D
huff
2010-02-18 16:47:24