I have an existing MyISAM table that I want to add a spatial column
to. It originally had two integer columns, lat and lon, and I've
added a new column "location point NOT NULL default ''"
Example data:
select lat, lon, astext(location) from fooloc;
+------+------+------------------+
| lat | lon | astext(location) |
+------+------+------------------+
| 0 | 0 | NULL |
| 10 | -10 | NULL |
| 1 | 5 | NULL |
+------+------+------------------+
Lon and Lat have values, I'm trying to come up with a UPDATE
for the column location that will do something like:
update fooloc set location = geomfromtext('point(lat lon)');
Is there a way to do this with a single update ?
tia
-pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
