title: Does MySQL still issues deadlock errors when using IGNORE in a query?
body: <p>I've used <code>IGNORE</code> before in <code>mysql</code> queries and I generally use this to avoid <code>mysql</code> returning errors when you try and insert a <code>duplicate key</code>, however I am not sure how this works - does mysql just ignore errors when using <code>IGNORE</code> or does it only ignore the <code>duplicate key</code> error?</p>
  
  <p>So, for example, if a <code>deadlock</code> occurred would it still issue the error when using <code>IGNORE</code> in the query?</p>
  
  <p><strong>Edit:</strong></p>
  
  <p>Doing some more reading and found this info:</p>
  
  <blockquote>
    <p>If you use the IGNORE keyword, <strong>errors that occur while executing the INSERT statement are ignored.</strong> For example, without IGNORE, a row that duplicates an existing UNIQUE index or PRIMARY KEY value in the table causes a duplicate-key error and the statement is aborted. With IGNORE, the row is discarded and no error occurs. Ignored errors may generate warnings instead, although duplicate-key errors do not. </p>
  </blockquote>
  
  <p>Well I guess that mean deadlock errors only will generate warnings then?</p>