Duplicate MD5's
Moderator: General Moderators
Re: Duplicate MD5's
So "guid" and item_id were two different columns all along???
Re: Duplicate MD5's
Yeah of course... guid is varchar, item is int
Re: Duplicate MD5's
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:
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
Hmm... This isn't good
#3 - Error writing file '/tmp/MY0vuQXT' (Errcode: 28)