mysql>
delete
from
a
-> using demo
as
a, demo
as
b
->
where
(a.id > b.id)
->
and
(a.site = b.site);
参考:http://www.codebit.cn/mysql/deleting-duplicate-rows-in-a-mysql-database.html