mysql update geo point

Question

I have a MySQL table with latitude and longitude values. I want to play around with the spatial stuff in MySQL 5, just to see how it works.

However, I'm having a real problem just getting the point data created from existing values. I was trying something like this, but it fails with syntax errors in every format I've tried. Can someone point out the right way to do this?

UPDATE locationtable a SET geopoint = GeomFromText( POINT() a.latitude a.longitude ) WHERE 1

I've also tried other variations, including:

UPDATE locationtable a SET geopoint = GeomFromText( 'POINT()' a.latitude a.longitude ) WHERE 1

UPDATE locationtable a SET geopoint = GeomFromText( 'POINT() a.latitude a.longitude' ) WHERE 1

And others…

Answer 1

Do you mean to do this?:

UPDATE locationtable AS a
SET a.geopoint = POINT( a.latitude, a.longitude ) 

Answer 2

Try this:

UPDATE locationtable a SET geopoint = GeomFromText( 'POINT(a.latitude a.longitude)' ) WHERE 1