At 16:53 -0600 2/14/03, Webmaster MBT wrote:
>Haven't been able to identify it yet... I'm attaching the file so maybe
>someone can help me with this.
Well, it's your data file. You should know what the line terminators are.
>BTW, how do I tell the command what is the ending symbol?
Add a LINES TERMINATED BY clause at the appropriate spot in the LOAD
DATA statement. Common ones are:
For newlines (common on Unix):
LINES TERMINATED BY '\n'
For carriage returns (common on Mac OS):
LINES TERMINATED BY '\r'
For carriage return/linefeed pairs (common on DOS/Windows):
LINES TERMINATED BY '\r\n'
Note that you may need to double the \ characters to get them passed
through PHP properly to MySQL.
>Thanks in advance.
>De: Paul DuBois [mailto:paul@stripped]
>Enviado el: Viernes, 14 de Febrero de 2003 04:43 p.m.
>Asunto: Re: Re: Load Data Infile problem.
>>The thing is that it will import one, and skip one full record each time.
>>But the one it inserts, is correctly inserted with the ; and the decimal
>>point correct. Any idea why it might be pasing one row and adding one?
>This is typically a problem of not having the line-ending terminator
>specified correctly. What's the line-ending sequence that you're
>using in your file?