This text is replaced by the Flash movie.

Archive for the ‘Database’ Category

MySQL Delete Duplicate Entries

October 19th, 2006

This Is the Best way to delete duplicate entries in MySQL

alter ignore table table_name add unique index(column_name);

For example your table_name.column_name has “some” duplicate entries the best way to do is to put unique index on the column_name that has duplicates

Is that simple.