title: Insert Ignore Into Mysql with a Primary Key
body: <p>I am trying to use INSERT IGNORE INTO to add a row to a table if it doesn't already exist.<br>
  Here is the statement as it stands right now:</p>
  
  <pre><code>INSERT IGNORE INTO my_table (integer, date) VALUES (11111, CURDATE())
  </code></pre>
  
  <p>However, since I have an auto-incrementing primary key on the table (that is not part of the insert of course), it always does the insert.  Is there a way to disregard the primary key so that if the integer and date are already in the table it will not insert another row with them?</p>