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