List:General Discussion« Previous MessageNext Message »
From:Kalin Mintchev Date:July 4 2003 6:15am
Subject:terminated by '\r'....
View as plain text  
hi all,

load data infile doesn't work with     escaped by '\\'   line 
terminated by '\r'
the problem is the '\r' . doesn't work with '\r\n' either.
if i replace the \r with \n in the the text file itself then it works 
fine the files i'm trying to load are tab delimited txt files generated 
by xcel...
they dont have '\r\n' at the and of the line - all they have is '\r'...
what should i specify as the end of the line to make it work as a mysql 
command without using sed....

thanks..

Thread
terminated by '\r'....Kalin Mintchev4 Jul
  • DSNless connection from ASP to LinuxDietrich Speer4 Jul
  • DSNless connection from ASP to LinuxDietrich Speer4 Jul