![]() |
NB - You need to do this first on a test copy of your table! When I did it, I found that unless I also included |
If you want to keep the row with the lowest id value:
DELETE n1 FROM table_name n1, table_name n2 WHERE n1.id > n2.id AND n1.name = n2.name
How to delete row id from 1 to 1000 in PHPmyAdmin | PHPmyadmin Tutorial |
How to delete all Duplicate Rows except for One in MySQL | PHPmyadmin Tutorial |
How to remove everything after a string by PHPmyadmin | PHPmyadmin Tutorial |
Read Full: | PHPmyadmin Tutorial |
Category: | Web Tutorial |
Sub Category: | PHPmyadmin Tutorial |
Uploaded: | 8 months ago |
Uploaded by: | Admin |
Views: | 406 |
Tested on: | MySQL 5.1 |
Reffered: https://stackoverflow.com/questions/4685173/delete-all-duplicate-rows-except-for-one-in-mysql