'Find Duplicates' script consumes too much power/time

Okay, so it’s been a long time since I’ve done any php/sql, and when I did, I was a newb.

I have a script that’s supposed to find duplicates in my table. I don’t want to delete them, just want to view them. Lately the script[php]SELECT common, draconic, notes, author
FROM draconic_words
WHERE common in
( SELECT common
FROM draconic_words
BY common
HAVING count(*) > 1 )
ORDER BY common[/php]just lags phpMyAdmin, and doesn’t run. If I wait long enough, it errors out and says maybe I was trying to upload something too big. If I try to cancel it, it still takes quite a while for me to be able to do anything with the database.

I have a friend who knows a little bit of PHP, but all he can advise is that instead of using the SQL box in phpMyAdmin, I write out a php page and separate the queries. I’m trying but I don’t know enough of PHP to have this make much sense, to me or others.

Help! Someone, anyone!

Hi there,

Can you let us know what exactly you are trying to achieve with the SQL statement (along with any criteria that must be met)

Sponsor our Newsletter | Privacy Policy | Terms of Service