title: Remove all duplicate row in mysql and dont keep even one
body: <p>All I found was how to remove the duplicate from a table but keep one. What I want is how to remove all the duplicate and dont even keep one. for example</p>
  
  <pre><code>    name   +   lastname
     ____________________
      a      +   something
      a      +   something
      b      +   something
      c      +   something
  </code></pre>
  
  <p>become</p>
  
  <pre><code>    name   +   lastname
      ____________________
      b      +   something
      c      +   something
  </code></pre>
  
  <p>Thanks for the answers </p>