Re: Bulk insert of geometry types

[Joseph Luttz]

The following works for me:

Input file:

32342342334 LINESTRING(11347.1232 32322.7576)
32341342234 LINESTRING(12311.2232 32320.3304)

Query:

LOAD DATA INFILE 'c:\myFile.txt'
INTO TABLE `tbl_myTable`
(@var1, @var2)
SET
obj_id = @var1,
obj_geo = GeomFromText(@var2);