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. Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.