Hi,
LOAD DATA INFILE is capable of loading only the internal representation of
the data.
Hence load the Well-Known Text (WKT) representation as a text column using
LOAD DATA INFILE into a text column and then shift the data geometry column
using an UPDATE.
Hope this will do..
Thanks
ViSolve DB Team
----- Original Message -----
From: "CrazyWind" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Monday, January 08, 2007 7:10 PM
Subject: Re: store spatial data in mysql
Thanks .
I have read these doucments,
but if i want store a .shp file,
How should I do? Convert it ?
Wating~~~
--------------------------------------------------------------------------------------------------------
ViSolve DB Team-2 wrote:
Hi,
More info on spatial data,
http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
http://dev.mysql.com/doc/refman/5.0/en/creating-spatial-columns.html
http://dev.mysql.com/doc/refman/5.0/en/populating-spatial-columns.html
Thanks
ViSolve DB Team
--
View this message in context:
http://www.nabble.com/store-spatial-data-in-mysql-tf2938527.html#a8217966
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
