How To Find Duplicate Records In MySQL
erics, August 8th, 2012
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
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | |
7 | 8 | 9 | 10 | 11 | 12 | 13 |
14 | 15 | 16 | 17 | 18 | 19 | 20 |
21 | 22 | 23 | 24 | 25 | 26 | 27 |
28 | 29 | 30 |
Copyright © 2005-2024 Eric Michael Stone | Random Thoughts, Whims and Fancies…. Powered by WordPress