List:General Discussion« Previous MessageNext Message »
From:Eduardo Arino de la Rubia Date:April 19 1999 8:40pm
Subject:Re: LOAD DATA Question
View as plain text  
for a table containing:

field a
field b
field c

where a is autonumber, when you just want to append try a perl program to
just strip out that column, then:

load data infile 'FILE_NAME' into table TABLE_NAME (b, c);

Ed

p.s. this was in the manual under load data

-------------------------------------------------------------------------------
1 + 1 = 3, for large values of 1. |     ed@stripped    | arino@stripped
-------------------------------------------------------------------------------

On Mon, 19 Apr 1999, Balthasar Indermuehle wrote:

> Hi all,
> 
> I'm trying to bulk load data on a regular schedule from a file. The
> problem is this: The first column contains an index number which is
> generated by the data output mechanism "on the other side" which I
> cannot change. Every data file starts again with index 1. My table is
> defined as having the first column an auto_number; LOAD DATA IGNORE
> drops all new records, LOAD DATA REPLACE replaces what's already
> there... what can I do to have the new records just appended, the first
> column ignored and inserted as defined in the table, namely as
> auto_number?
> 
> 
> thanks!
> 
> - Balthasar
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread2082@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
> 

Thread
LOAD DATA QuestionBalthasar Indermuehle20 Apr
  • Re: LOAD DATA QuestionThimble Smith20 Apr
    • Re: LOAD DATA QuestionThimble Smith20 Apr
  • Re: LOAD DATA QuestionEduardo Arino de la Rubia20 Apr
  • Re: LOAD DATA QuestionPaul DuBois20 Apr