Page 2 of 2

Re: Duplicate MD5's

Posted: Thu Aug 28, 2008 7:18 am
by ghurtado
So "guid" and item_id were two different columns all along???

Re: Duplicate MD5's

Posted: Thu Aug 28, 2008 10:28 am
by GeXus
Yeah of course... guid is varchar, item is int

Re: Duplicate MD5's

Posted: Thu Aug 28, 2008 10:35 am
by ghurtado
I think we were under the impression that your original query was pulling GUIDs, but I guess not.

Please try this and post the results:
SELECT count( * ) AS myCount, guid, item_id
FROM clicks
GROUP BY guid
HAVING myCount >1
ORDER BY myCount desc

Re: Duplicate MD5's

Posted: Thu Aug 28, 2008 4:41 pm
by GeXus
Hmm... This isn't good
#3 - Error writing file '/tmp/MY0vuQXT' (Errcode: 28)