In addition I would suggest to verify that your text file does not end with a CR or LF character. This happens very often on Windows systems when for instance saving an Excel sheet as a text file.
If you do not remove this last character(s), you risk inserting a blank row in the DB. Ignatius ____________________________________________ ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Sebastian Stan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 4:02 PM Subject: Re: HEPL: LOAD DATA LOCAL skips recors > At 11:50 +0200 3/14/03, Sebastian Stan wrote: > >i have 2 DBFs and i'm doing the same thing on both of them : (i'm > >transforming the DBFs in TXTs) > >(in foxpro) " copy to <file>.txt delimited with '^' with character '#' " > > > >When : > > LOAD DATA LOCAL INFILE '<file>.TXT' into table <table on mysql> fields > >terminated by '#' OPTIONALLY ENCLOSED BY '^'; > >is executed i get 2 different results: > >1. from the 1st .txt file ALL the recors are loded > >2. from the 2nd it loads only the records 1,3,5,7,9 etc. are loaded. (and i > >really need all of them , too :)) ) > > > > > >If the txt files i make are with constant leght and i do "LOAD DATA LOCAL > >INFILE '<file>.TXT' into table <table on mysql> fields terminated by ' ' " > >it works just fine, but i need the first way. > > This is typically a problem of not indicating correctly what the > end of line character sequence is. How do your lines end? Linefeeds? > Carriage returns? Carriage-return/linefeed pairs? > > If it's something other than linefeeds, you'll need a LINES TERMINATED BY > clause. > > > > > > >Please help me. > > > > > >Thank you. > >---------------------------------------------- > > Sebastian Stan > > [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
