Mysql删除顺序

Question

我有一张表，我只按 ID 的顺序显示最新的 30 行。

我正在尝试使用以下查询删除 30 条最新行之后的所有行。

DELETE FROM table WHERE type = 'test' ORDER BY id DESC LIMIT 30, 60

我在下面不断收到此错误

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 60' at line 1

我做错了什么？

Answer 1

试试这个，

DELETE FROM table
WHERE ID IN
        (
        SELECT ID
        FROM
            (
                SELECT ID
                FROM table
                WHERE Type = 'TEST'
                ORDER BY ID
                LIMIT 30,60
            ) a
        )