title: Delete statement in a same table
body: <p>I need to query a delete statement for the same table based on column conditions from the same table for a correlated subquery.</p>
  
  <p>I can't directly run a delete statement and check a condition for the same table in mysql for a correlated subquery.</p>
  
  <p>I want to  know whether using temp table will affect mysql's memory/performance?</p>
  
  <p>Any help will be highly appreciated.</p>
  
  <p>Thanks.</p>