title: Delete rows from several tables in one query
body: <p>What is the proper way to delete rows from several tables in one query?</p>
  
  <p>The reason I ask is because I am doing this with PHP.  If I use multiple queries to delete from each table one at a time, PHP has to make multiple trips to the database.  Will there be any effect on performance if I used this method?</p>
  
  <p>I am aware of the <code>ON DELETE CASCADE</code> option, but this does not work on every storage engine. Also, there may be situations where I do not want to remove all of the records from the child tables when I delete the parent record.</p>