nonexist Posted December 7, 2008 Share Posted December 7, 2008 Well I basically need to get rid of some duplicate rows. They do have a primary key of `id` but the id's don't repeat, other data does. I have this SELECT anValue, count(info) FROM infos GROUP BY info HAVING count( * ) >1 Which shows the duplicates of anValue and gives the number for the duplicated of info. I am wondering how I can delete these using what I have from above, without having to move them to another table. Link to comment https://forums.phpfreaks.com/topic/135963-how-to-delete-duplicate-rows-after-duplicated-are-found/ Share on other sites More sharing options...
fenway Posted December 8, 2008 Share Posted December 8, 2008 You could just add a unique index and filter them that way. Link to comment https://forums.phpfreaks.com/topic/135963-how-to-delete-duplicate-rows-after-duplicated-are-found/#findComment-708946 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.