title: MySQL "ALTER IGNORE TABLE" Error In Syntax
body: <p>I am trying to run the query:</p>
  
  <pre><code>ALTER IGNORE TABLE test_table DROP PRIMARY KEY, ADD PRIMARY KEY(id);
  </code></pre>
  
  <p>test_table is just a temporary table I'm using for testing purposes, and id is a column in it.</p>
  
  <p>The query works fine without the "IGNORE" key word, but when I add it I get the error message: </p>
  
  <blockquote>
    <p>"Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE test_table ADD PRIMARY KEY(id)' at line 1"</p>
  </blockquote>
  
  <p>How do I fix this? Or how can I run that query and ignore any errors that might occur? Thanks!</p>