DELETE * ,count(*)as n FROM add group by id HAVING n>1.

它将删除所有重复的记录

It will delete all duplicate records