* Podhorski, Adam > If I don't put the tab before the the end of the line in the txt file that > contains the data, mySQL does not properly put the data into table using > LOAD DATA INFILE. [...] > But if there is only a \n at the end of the line (e.g. > 1\tTC446696\tTC27867\n), the data gets corrupted and even the display does > not proerly work (note the wrong vertical column bars for display) > > mysql> SELECT * FROM tigr_mgi_tcs; > +----+----------+------------+ > | ID | TC | TC_Synonym | > +----+----------+------------+ > | | TC446696 | TC27867 > | | TC446696 | TC37198 > | | TC446696 | TC39544 > | | TC446696 | TC70404 > +----+----------+------------+
It seems as your file have \r\n line endings, not only \n. This can happen if the file is produced on a windows machine, or if it has been edited in a text editor and saved on a windows machine. Try using LINES TERMINATED BY '\r\n' -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
