Remove Duplicate Rows in MySQL

Easiest way to do this is to add a UNIQUE index on the column. When you write the ALTER statement,