Remove duplicate value on existing mysql databse table

Trying to learn some mysql stuff, again i think i need to note my activity here before i forgot the command syntax.

my case begin with i need to remove huge amount of duplicate data in mysql database table, luckily the solution is easy to find on doctor google.

i use

mysql>alter ignore table table_name add unique key (column_name);

and all my duplicate entry were remove right away....