Re: delete duplicate

[Gerald Clark]

Xah Lee wrote:
> 
> Suppose I have a table that has identical rows for some reason. I need to
> delete the duplicates. Can this be done in MySql's SQL?
> 
> Thanks.
> 
> Xah
> xah@stripped
> http://www.best.com/~xah/PageTwo_dir/more.html
> 
Here is one method that uses a temporary unique index to force deletion
of duplicate records.

alter ignore table tablename add unique( field1, field2, ... fieldx )

When you are  through, drop the index MySQL created.