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 ''.

If you want to set 'cities.coord' from ',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

Written By
October 19, 2008 07:16AM
Re: Help - build table of POINT
October 23, 2008 12:24AM
October 25, 2008 12:22PM
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.