title: How to use executemany() to insert multiple rows but ignore the erroneous ones?
body: <p>I am using Python MySQLdb to insert data into a mysql database.</p>
  
  <p><code>InsertList</code> contains many rows. All are valid except for a few which violate database integrity rules. 
  If I run the code below, the command returns an error.</p>
  
  <p>Cursor1.executemany(query, InsertList) </p>
  
  <p>How can I force executemany() to insert the rows which are valid but ignore the few which are erroneous? The erroneous ones are caused by duplicate values in the new row. Do I have to use execute() one by one to insert the rows instead?</p>
  
  <p>Thank you for your help.</p>