mysql命令删,mysql删除命令由

I have a table and I only display the latest 30 rows by order by ID.

I'm trying to delete any rows after the 30 newest rows by using this query below.

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

I keep getting this error below

#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

What am I doing wrong?

解决方案

Try this one,

DELETE FROM table

WHERE ID IN

(

SELECT ID

FROM

(

SELECT ID

FROM table

WHERE Type = 'TEST'

ORDER BY ID

LIMIT 30,60

) a

)