如何删除PHP/Mysql中的所有重复记录
问题描述：
可能重复:
如何删除mysql数据库中的重复记录?
Possible Duplicate:
How to delete duplicate records in mysql database?
在mysql表中有重复的行. 如何找到重复的行并删除它们.
there are duplicate rows in the mysql table. how find the duplicate rows and delete them.
答
DELETE * ,count(*)as n FROM add group by id HAVING n>1.
它将删除所有重复的记录
It will delete all duplicate records