更新时间:2023-12-01 23:07:16
建议您先尝试备份您的SQL数据库,然后再尝试以下操作。
I advise backing up your SQL database before trying the below.
尝试:
DELETE bad_rows . * FROM ktz3_posts AS bad_rows INNER JOIN (
SELECT post_title, MIN( id ) AS min_id
FROM ktz3_posts
GROUP BY post_title
HAVING COUNT( * ) >1
) AS good_rows ON good_rows.post_title = bad_rows.post_title
AND good_rows.min_id <> bad_rows.id
由于上述代码未经测试,因此可以尝试复制帖子删除器。
As the above code is untested, you could try the Duplicate Post Remover.