deleting duplicated records

[Bastien]

Hi All,

in one of my dbs, a table has managed to duplicate itself, creating 2 entries for each row. this is including the primary key.

how can i remove the one offending row to achieve one unique row for each record?

i could not find anything in the mysql.com site about removing duplicated rows...

TIA



Bastien

cat, the other other white meat

 

[williamu]

Hi Bastien,

You could try using a DELETE FROM ? WHERE (SELECT DISTINCT ...) ; query.

But one thing's for sure you DB is really b0rken, there is NO WAY that the PK should be duplicated. You really need to get to the bottom of this.


William
Software Engineer
ICQ No. 56047340