How To Find Duplicate Records In MySQL

SELECT * FROM yourTable GROUP BY yourField HAVING count(yourField) > 1;
SELECT * FROM yourTable GROUP BY yourField HAVING count(yourField) > 1;
Categories: How-To's, Technology Tags: Dupe, Duplicate, Duplicate Records, Duplicate Rows, GROUP BY, GROUP BY HAVING, HAVING, howto, mysql, SQL, tips
|
No comments
Copyright © 2005-2025 Eric Michael Stone | Random Thoughts, Whims and Fancies…. Powered by WordPress