Inserting textfiles into MySQL

[Tigermilk]

Hi!
I've got problems inserting textfiles into a column in a MySQL table. It's only the first line that's inserted.
How should i write the command so that the linebrakes are included?
As it is now, I'm using
LOAD DATA LOCAL INFILE 'C:\loggar\log1.txt' INTO TABLE logs FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FIELD(text);

hope you understand what i mean, I'm a no gooder in english
//Magnus

[Karl]

LOAD DATA LOCAL INFILE 'C:\loggar\log1.txt' INTO TABLE logs FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY "\n" FIELD(text);

that should do the trick for you, notice the " round \n.

[Tigermilk]

Thanks Karl
I found another way...

LOAD DATA LOCAL INFILE 'C:\loggar\log1.txt' INTO TABLE logs FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY "666" (text);

the 666 or whatever number is included as the las chars in the text file.