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
