title: Delete top row from MySQL database
body: <p>I have a MYSQL database running for some testing, that is getting its values for the table 'results' from a webpage. It contains some rows and columns.</p>
  
  <p>When I try:</p>
  
  <pre><code>select * from results limit 10;
  </code></pre>
  
  <p>It is showing the first 10 lines from the database of some table.</p>
  
  <p>Basically, I want to delete those rows. When I try:</p>
  
  <pre><code>delete from results where (select * from results limit 10) ;
  </code></pre>
  
  <p>It will not delete these rows and it ask this:</p>
  
  <pre><code>delete from results where (select * from results limit 10) ;
  </code></pre>
  
  <p>Also tried to do:</p>
  
  <pre><code>mysql&gt; delete * from results where (select * from results limit 10) ;
  ERROR 1064 (42000): 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 '1 from results where (select * from results l
  imit 10)' at line 1
  </code></pre>
  
  <p>How can I delete these rows? Also how can I select the last 10 rows and delete them?</p>