title: How do I delete all the duplicate records in a MySQL table without temp tables
body: <p>I've seen a number of variations on this but nothing quite matches what I'm trying to accomplish.</p>
  
  <p>I have a table, <code>TableA</code>, which contain the answers given by users to configurable questionnaires. The columns are <code>member_id, quiz_num, question_num, answer_num</code>.</p>
  
  <p>Somehow a few members got their answers submitted twice. So I need to remove the duplicated records, but make sure that one row is left behind. </p>
  
  <p>There is no <strong>primary</strong> column so there could be two or three rows all with the exact same data.</p>
  
  <p>Is there a query to remove all the duplicates?</p>