Re: modifying duplicate unique keys with LOAD DATA INFILE

2005-10-06 Thread Gerhard Prilmeier
Dear Michael, thank you for your response. If a duplicate unique key is found when importing with LOAD DATA INFILE, How does that happen? I take it you are adding the imported data into an already populated table. True, that's what I meant to say. Don't alter the keys for the existing d

Re: modifying duplicate unique keys with LOAD DATA INFILE

2005-10-03 Thread Michael Stassen
Gerhard Prilmeier wrote: Hello, I use tables with one primary key (which is the only unique key). I'd like to export data from such a table to a file, and then import it on another machine. If a duplicate unique key is found when importing with LOAD DATA INFILE, How does that happen? I tak

modifying duplicate unique keys with LOAD DATA INFILE

2005-10-03 Thread Gerhard Prilmeier
Hello, I use tables with one primary key (which is the only unique key). I'd like to export data from such a table to a file, and then import it on another machine. If a duplicate unique key is found when importing with LOAD DATA INFILE, MySQL gives me the choice of whether to 1. stop executi