network profile
| bio | website | tlvince.com |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 6 months |
| seen | Dec 22 '11 at 23:01 | |
| stats | profile views | 2 |
|
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 |
