Well I figured out what was going on, MS uses a LF,CR instead of just a Line feed. The was corrupting the first column. I added a LINES TERMINATED BY statement and put in the '\r\n'. Now everything works fine.
Thanks again. ----- Original Message ----- From: "upscope" <[EMAIL PROTECTED]> To: "MySql AB" <[EMAIL PROTECTED]> Sent: Thursday, September 18, 2003 6:52 AM Subject: LOAD DATA > I am using the following command to load a table: > LOAD DATA LOCAL INFILE "email.txt" INTO TABLE email; > The command works and the second and third column go in correctly. But the > first column is not loading correctly. I am using Notepad on WIN ME to > generate the txt file. > > John Doe [EMAIL PROTECTED] > > The problem appears to be the enter key that allows me to go to the next > line. The last line where I donot use the enter key works fine. Has anyone > experienced this problem or know a fix. I am manual executing the load data > from a DOS window. I have mysql server 4.0.14 - max -debug and client > 4.0.14. > > Thanks for any help in advance. > > upscope > > This email scanned by NAV2004 > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]