List:General Discussion« Previous MessageNext Message »
From:Robin Bowes Date:April 30 1999 3:19pm
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).

Check the manual.

Look in particular at the "IGNORE" option for LOAD DATA INFILE.

R.
-- 
Robin Bowes - System Development Manager - Room 405A
E.O.C., Overseas House, Quay St., Manchester, M3 3HN, UK.
Tel: +44 161 838 8321  Fax: +44 161 835 1657
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