106 reputation
12
bio website tlvince.com
location
age
visits member for 3 years
seen Dec 22 '11 at 23:01

May
22
awarded  Notable Question
Dec
21
awarded  Popular Question
Dec
22
comment Deleting duplicates with group by and count
It seems to have worked and very quickly at that. However, using a sum on the count field in my query above, I get 3847, whereas your suggestion finds 5500 duplicates. I'll check the results and get back to you. Thanks.
Dec
22
comment Deleting duplicates with group by and count
I added a new column using alter table tbl_fields add unq mediumint not null auto_increment key and left your suggestion running for ~3 hours before killing it. Even with a subset of the table it appeared to hang. Is this to be expected?
Dec
22
awarded  Student
Dec
22
comment Deleting duplicates with group by and count
@Lumpy, if it helps to solve the problem then definitely (but to clarify, nothing currently exists that is unique).
Dec
22
comment Deleting duplicates with group by and count
Unfortunately not. There is an id field, but once upon a time, someone merged similar tables, so there's no guarantee they are unique any more (a quick spot check proves this).
Dec
22
comment Deleting duplicates with group by and count
Tell me about it :)
Dec
22
asked Deleting duplicates with group by and count