title: Multi statement SQL delete with foreign key constraint
body: <p>I'm using MySQL 5.5 with a complex schema that has foreign key constraints.</p>
  
  <p>I want to execute multiple <code>update</code> and <code>delete</code> SQL statements.</p>
  
  <p>After a subset of these statements have executed there may be foreign key constraint violations.</p>
  
  <p>After all of these statements have executed there shouldn't be foreign key constraint violations.</p>
  
  <p>I know about <code>cascade</code>, I don't want to use it because some of the changes require more complex logic.</p>
  
  <p>My question is, is there a way to combine my multiple statements together (as a multi statement, transaction, etc) such that the foreign key constraints are not checked until after they are all completed?  (And if there is an error than none of them are executed?)</p>