GIS In MySQL Database
"Michael Avila" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
I have a Win32 MySQL database. I want to add GIS information, specifically
latitude and longitude. Reading the MySQL docs online, it seems like the WKT
format can be used to describe this information. If I understand the docs
correctly, it is stored in a blob. (I assume a TinyBlob.) If I wanted to add
the latitude and longitude of a location using SQL, how would I do that?
INSERT INTO tablename (longlat) VALUE('POINT(40.12345 -83.12345)')
where longlat would be a TINYBLOB.
Would that be correct or have I missed the train as it pulled out of the
station?
Thanks.
Mike
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/[email protected]