mysql - 如何删除除最新的 50 行之外的所有行

Question

我如何删除表 recentposts 中的所有行

DELETE FROM recentposts WHERE recentposts.`userId` = 12 AND recentposts.`Id` 
NOT IN (SELECT * FROM recentposts WHERE `userId` = 12 ORDER BY viewdate LIMIT 50)

我尝试了很多类似的方法，但都没有用。谁能告诉我如何在 Mysql 中执行此操作。

Answer 1

这个呢？

DELETE FROM recentposts
WHERE
    recentposts.`userId` = 12
    AND
    recentposts.`Id` NOT IN (SELECT Id
        FROM recentposts
        WHERE `userId` = 12
        ORDER BY viewdate DESC LIMIT 50)