Remove duplicate rows from a mySQL db table

To remove the all the duplicate entries from a particular mysql table, use the below mysql query :

Step : 1

What the above query does is, it will create a new table with the filtered data (all duplicate entries were deleted).

Note : replace the whole  [COLUMN TO remove duplicates BY] with your column name

Step 2: After that delete the old table

Step 3 : rename the new table

About the Author: Murtaza Malek

Team Leader at Luutaa Technologies, having experience in different web and mobile technologies. Joined Nov 17th 2010 (U turn of his life). Loves to play with JQUERY, AJAX.