删除myql相同数据只留一条

 

 

DELETE
FROM
publishSheet
WHERE
id IN (
SELECT
dt.id
FROM
(
select id from publishSheet group by publishTitle having COUNT(publishTitle)>1
) dt
)