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
