I like this method:
Create table dst with the same structure, but add the digital field DupCount
INSERT INTO dst SELECT * FROM src ON DUPLICATE KEY UPDATE dst.DupCount = dst.DupCount +1
DupCount for each row will contain the number of repeats encountered.
You can write a script that will create table dst, copy, thus there is data, delete the original table and rename dst to src.