title: In MySQL, can I defer referential integrity checks until commit
body: <p>As in <a href="https://stackoverflow.com/questions/1330020/is-it-possible-to-defer-referential-integrity-checks-until-the-end-of-a-transacti">this question</a>, I've been reading PoEAA and wondering if it's possible to defer referential integrity checks until commit in MySQL.</p>
  
  <p>I've run into this problem when wanting to insert a bunch of products and related products in the same commit. Even within a transaction, I get constraint errors when I try to insert into the <code>related_products</code> join table.</p>
  
  <p>If it helps, I'm using PHP PDO for database connections.</p>
  
  <p>I'd appreciate any help you could offer.</p>