> Is there any way to define a column in MySql 4 that is to be unique from
> this point forward. Meaning, there are indeed dupes in the column now,
> those are ok, there is really no repairing that damage as the data was
> inherited from somewhere else. I am constantly having to select the
> to see if there is a dupe entry in it before inserting, I would like to
> having to do this and define the column as unique from this point forward.
> However, in trying this, MySql will not allow me to make it unique until I
> remove all the duplicates.
Well, that should tell you something, right?
What's the point in having data "unique from this point forward" anyway?
If you want it unique, repair it.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL