Mailing List Archive


Back to the month index Back to the list index
Georg Horn (horn@uni-koblenz.de)
Thu, 1 Apr 1999 10:40:13 +0200 (CEST) 

From: Georg Horn <horn@uni-koblenz.de>
Message-Id: <199904010840.KAA02446@flens.uni-koblenz.de>
Subject: Re: Unqiue
Date: Thu, 1 Apr 1999 10:40:13 +0200 (CEST)

Sandeep wrote:

> i am trying to create a unique index in a table, but the problem is that
> there is duplication of a value somewhere,
>
> "ERROR : Non unique value for unique index"
>
> but i cannot trace it, its a large database,thats i have just imported.
> How can i find out the values thats are being repeated.

I once added an option "-f" (force) to msqlimport, which makes it
ignore errors. Unfortunately, this version didn't make it's way into
the official msql release... You may download it from
http://koblenz-net.de/~horn/export/msqlimport.c

You must create the index before importing the data, and then msqlimport
will print the rows that caused an error, but will continue to import
the data.

Bye,
Georg