Wednesday, 21 November 2012

Delete duplicate rows in mysql table

It is Possible to DELETE duplicate rows in MYSQL table based on Particular Field (Coloumn)

the SQL Query is

ALTER IGNORE TABLE table_name ADD UNIQUE INDEX(coloumn_name); 

Share This!

No comments:

Post a Comment

Here We Write The Problems we face at different situations and Solutions to those problems.