CODEWITHSUNDEEP
mysqlgeolocationgeometry
julio
julio

Reputation: 6748

mysql update geo point

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…

Upvotes: 6

Views: 7213

Answers (2)

ypercubeᵀᴹ
ypercubeᵀᴹ

Reputation: 115630

Do you mean to do this?:

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

Upvotes: 13

dorsh
dorsh

Reputation: 24740

Try this:

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

Upvotes: 0

Related Questions