title: MySQL's INSERT IGNORE INTO & foreign keys
body: <p>Why in MySQL, <code>INSERT IGNORE INTO</code> does not change the <em>foreign key constraint</em> errors into warnings?</p>
  
  <p>I'm trying to insert a number of records into a table and I expect MySQL to leave out the ones that result in error, any error, and insert the rest. Does anyone have any suggestions?</p>
  
  <p>And the <code>SET FOREIGN_KEY_CHECKS = 0;</code> is not my answer. Because I expect the rows which defy the constraints not to be inserted at all.</p>
  
  <p>Thanks</p>