MYSQL: remove duplicates from table

Here is one line to remove duplicate records from database. I just run similar query for 6M records.

ALTER IGNORE TABLE mytable ADD UNIQUE INDEX(user_id,name);