MySQL Forums
Forum List  »  GIS

Re: Bulk insert of geometry types
Posted by: Albert Rovira
Date: October 05, 2010 06:12AM

GeomFromText() is an SQL function and it isn't interpreted from data.

You can try with this other file format:

1:Polygon(0 0, 1 1, 2 2, 0 0)
2:Polygon(0 0, 1 2, 2 2, 0 0)


and this load sentence:

LOAD DATA LOCAL INFILE 'myfile.txt' INTO TABLE `testDb`.`testTable` FIELDS TERMINATED BY ':' LINES TERMINATED BY '\n'
(@var1, @var2)
SET
id = @var1,
region = GeomFromText(@var2) ;

Options: ReplyQuote


Subject
Views
Written By
Posted
8526
September 21, 2010 09:42AM
Re: Bulk insert of geometry types
3313
October 05, 2010 06:12AM
3228
January 02, 2011 07:20PM
2923
November 05, 2010 09:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.