t;[EMAIL PROTECTED]>
Sent: 31 January 2002 01:01
Subject: Re: Batch load of data problems (fwd)
> I'm forwarding this to the list since I can't offer any more advice
> myself. -- Forwarded message --
> Date: Wed, 30 Jan 2002 19:41:32 -0500
> From: [EM
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 "tes
c.
Eurico
"William R. Mussatto" wrote:
> I'm forwarding this to the list since I can't offer any more advice
> myself. -- Forwarded message --
> Date: Wed, 30 Jan 2002 19:41:32 -0500
> From: [EMAIL PROTECTED]
> To: "William R. Mussatto" &
I'm forwarding this to the list since I can't offer any more advice
myself. -- Forwarded message --
Date: Wed, 30 Jan 2002 19:41:32 -0500
From: [EMAIL PROTECTED]
To: "William R. Mussatto" <[EMAIL PROTECTED]>
Subject: Re: Batch load of data problems
I
On Wed, 30 Jan 2002, Eurico de Sousa wrote:
> Date: Wed, 30 Jan 2002 16:56:24 -0500
> From: Eurico de Sousa <[EMAIL PROTECTED]>
> To: mysql post <[EMAIL PROTECTED]>
> Subject: Re: Batch load of data problems
>
> Hi. Resubmitting a post...
>
> Basically, m
Hi. Resubmitting a post...
Basically, my question is if you have defined an INT NOT NULL AUTO_INCREMENT id field
in a table,
and you want to load a data file into the table using the LOAD DATA INFILE command,
must you also
put the ids in the data file? Thanks.
Eurico
*
Hi.
I have a question regarding loading data from text files into tables using the LOAD
DATA statement.
I tried this under Win98 without success. Basically, I have a file called create.tbl
which has
CREATE TABLE statements. The last statements in this file are of the form:
LOAD DATA INFILE "fi
