List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:April 30 1999 2:57pm
Subject:Re: duplicates in LOAD DATA INFILE
View as plain text  
Aurélie Connors wrote:
> 
> Loading data infile stops on indexed duplicates instead of skipping them.
> Is there a way to change that ? I would like to avoid the importation of
> duplicates at this time.
> If it is not possible how may I easily delete from table duplicates (non
> indexed in this case of course).
> 
> Thanks for your advice
> 

Maybe there is a way, but in my opionion it is better to filter the data
before using load data infile with Perl or C if you need to do is fast
and you have a lot of data.

-- 
Sasha Pachev
http://www.sashanet.com
Thread
duplicates in LOAD DATA INFILE(AurĂ©lie Connors)30 Apr
  • Re: duplicates in LOAD DATA INFILESasha Pachev30 Apr
  • Re: duplicates in LOAD DATA INFILERobin Bowes30 Apr