how to remove dublicates from your mysql table
nice mysql syntax for removing dublicates from your tables
strategy as follows
clone your table with
create table a as select * from b
truncate your table
truncate b
create unique index
create unique index u_indx1 on b (x,y,z)
insert all rows back to table with ignore
insert ignore into b select * from a
strategy as follows
clone your table with
create table a as select * from b
truncate your table
truncate b
create unique index
create unique index u_indx1 on b (x,y,z)
insert all rows back to table with ignore
insert ignore into b select * from a
Comments