MySQL Forums
Forum List  »  GIS

Re: Help - build table of POINT
Posted by: Koji Okumura
Date: October 23, 2008 12:24AM

It has 2 opening parenthesis, but 3 closing parenthesis. (^^;

Another problem.

'POINT(lat lng)' is a text. Therefore 'lat' means 'lat' string.
It doesn't mean the value of 'cities.lat'.

If you want to set 'cities.coord' from 'cities.lat,cities.lng',
please try:

UPDATE cities SET coord=GeomFromWKB(Point(lng,lat));



Edited 2 time(s). Last edit at 10/23/2008 01:03AM by Koji Okumura.

Options: ReplyQuote


Subject
Views
Written By
Posted
4789
October 19, 2008 07:16AM
Re: Help - build table of POINT
3285
October 23, 2008 12:24AM
2983
October 25, 2008 12:22PM
3201
October 27, 2008 03:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.