Results 1 to 25 of 44
Thread: Different Duplicate Issue
Jan 1, 2009, 18:36 #1
Different Duplicate Issue
I wasn't thinking when designing the database and forgot to apply UNIQUE to a couple fields (field1, field2). Of course, after a couple thousand records it occurs to me and I want to fix it. However, trying to add UNIQUE at this point gives me the old #1062 duplicate entry error.
The problem is, that some of the records have no value in these fields, and some do, so this query isn't doing the trick.
How do I find the records that have the duplicate(s)?