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: [EMAIL PROTECTED]
To: William R. Mussatto [EMAIL PROTECTED]
Subject: Re
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
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
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, my question is if you have defined an INT NOT NULL
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 guess I didn't make myself very clear. Here's what I run:
mysql