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