Re: Bulk insert of geometry types

[Albert Rovira]

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) ;