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..
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
