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.
-----Mensaje original-----
De: Paul DuBois [mailto:[EMAIL PROTECTED]]
Enviado el: Viernes, 14 de Febrero de 2003 04:43 p.m.
Para: [EMAIL PROTECTED]
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?
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
