At 21:57 -0500 1/30/02, [EMAIL PROTECTED] wrote: >I found out why my LOAD DATA INFILE did not work. > >The editor I was using translated the tabs I entered to spaces. >That's why my load data infile didn't work! >I used the following command to load the data successfully: > >load data infile "test.dat" replace into table persons fields >terminated by ' ' terminated by '\r\n'; > >The fields terminated argument in the load command is actually a >single space - I changed my file to have >one single space between the ID-number and the Name instead of a >tab. I have to specify that the lines are >terminated by '\r\n' since I'm running under Windows. The default is >'\n'. I'm not familiar with Windows - >didn't know that the tabs I was entering would be translated. > >Finally got it after trial and error. I wish there were more >examples and detail in the manual on this >topic.
Well ... I sympathize with the problem that you've encountered, but it's not LOAD DATA that is at fault here. Another program mangled your file without telling you. sql,query --------------------------------------------------------------------- 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
