-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 6:55 AM
To: [EMAIL PROTECTED]
Subject: re: RE: load data infile question
Hi!
>On Tuesday 25 March 2003 19:54, Salada Duncan wrote:
>
>> I was able to work around the probl
On Tuesday 25 March 2003 19:54, Salada Duncan wrote:
> I was able to work around the problem by giving "insert" privileges to the
> user for the WHOLE database. This is definitely not optimal because I only
> wish this user to be able to insert into one table in the database. But as
> soon as I
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.
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
admin,
Saturday, August 10, 2002, 6:31:56 AM, you wrote:
a> Many of you suggested that, in regards to my problem with LOAD DATA
a> [LOCAL] INFILE ... , I may have permissions problems. I checked with
a> the host and the reply was, "You have access to do all commands except
a> for the "grant" com
> >>I didn't see any difference between using optionally or not. Any
> solutions to make the two that fails work? (see test case below) Using
> 3.23.41.
>
> That's a problem with your input data. You can't have the character that
> you're using to surround the fields within the f