Blog

IT How to Remove duplicate rows from MySQL table using phpMyAdmin

You Have a MySQL Table with Duplicate and repeated entries?

If You Want to remove duplicate entries from MySQL using phpMyAdmin do the following:1- Login to phpMyAdmin

2- select the Database that has the table with the duplicates

3- Click SQL tab in phpMyadmin

Screen Shot 2014-04-04 at 11.28.57 AM

4- In the SQL Text Box write the following as shown in the screenshot below:

ALTER IGNORE TABLE my_table ADD UNIQUE INDEX (my_table_raw);

duplicate_fix

5- Click on Go

Sign up for our newsletter to stay up to
date with tech news!