title: Mysql delete order by
body: <p>I have a table and I only display the latest 30 rows by order by ID.</p>
  
  <p>I'm trying to delete any rows after the 30 newest rows by using this query below.</p>
  
  <pre><code>DELETE FROM table WHERE type = 'test' ORDER BY id DESC LIMIT 30, 60
  </code></pre>
  
  <p>I keep getting this error below</p>
  
  <pre><code>#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
  </code></pre>
  
  <p>What am I doing wrong?</p>