title: How to delete duplicate rows from a MySQL table
body: <p>I have a <code>MySQL</code> table like:</p>
  
  <pre><code>ID, Col1, Col2, Col3, Col4, etc...
  </code></pre>
  
  <p>ID is a <strong><code>primary key</code></strong> and has been working since the table's creation.</p>
  
  <p>What I want to do is delete all but one records where all the other columns are identical.</p>