Is it possible to delete duplicate records from a table with out using rowid in MYSQL?

Alter table xyz add unique index (col1,col2,...)