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.
>
