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 column to see if there is a dupe entry in it before inserting, I would like to stop 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. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]