Index in MySQL tables

To create a unique index for a MySQL table, run this command:

ALTER IGNORE TABLE `table_name` ADD UNIQUE INDEX (`column_name`);

To delete duplicate rows in a table:

DELETE FROM table_name  
WHERE id IN (SELECT *
  FROM (SELECT id FROM table_name
    GROUP BY column_name HAVING (COUNT(*) > 1)
  ) AS A
);