MYSQL. To remove the duplicate rows?

CREATE TEMPORARY TABLE tmp_tab AS SELECT DISTINCT * FROM your_table;
\r
DELETE FROM your_table;
\r
INSERT INTO your_table SELECT * FROM tmp_tab;
\r
DROP TABLE tmp_tab;

You can still bzzz ALTER IGNORE TABLE tmp add unique index(column1, column2)

Helped me here is an option:
\rALTER IGNORE TABLE table1 ADD UNIQUE KEY(Name2, Name3);

Add primary key (id) and then:
\r
DELETE FROM table as me, table as clone WHERE me.c1 = clone.c1 AND me.c2 = clone.c2 AND me.id < clone.id
\r
\rIt works if I correctly understood the task.

I like this method:
Create table dst with the same structure, but add the digital field DupCount
\r
do request:
INSERT INTO dst SELECT * FROM src ON DUPLICATE KEY UPDATE dst.DupCount = dst.DupCount +1
\r
DupCount for each row will contain the number of repeats encountered.
\r
You can write a script that will create table dst, copy, thus there is data, delete the original table and rename dst to src.

I can say that DISCINCT it is really a mistake of all databases and glances at him it is always necessary, but in such a simple but not standard tasks is the best option.