MySQL Duplicates

[kmarsh]

I'd like to remove duplicate entries in a MySQL table, everything is identical except for 'id'... how I can I do this?

[Anon]

This should get you the duplicate ID's.

select a.id, b.id as dup_id
from table1 a, table1 b
where a.field1 = b.field1
and a.field2 = b.field2 // do for as many fields as you have
where a.id != b.id

That should get you the ID's of duplicated records. You should double check this yourself. Once you have the duplicate ID numbers then you can just delete them.