From: Robin Bowes
Date: April 30 1999 3:19pm
Subject: Re: duplicates in LOAD DATA INFILE
List-Archive: http://lists.mysql.com/mysql/2702
Message-Id: <3729CA15.982DD320@eoc.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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