title: Why can I not change mysql int value?
body: <p>It seems like a bug because when I set the integer value on a column it says it has been changed successfully but nothing happens and the integer value remains blank.</p>
  <p>I can't use the database because I get the error that all my integer columns have incorrect integer values, but when I try to change them to int(11) e.g. nothing is happening.</p>
  <p>Does anyone know how to fix this?</p>
  <p>I can set columns with varchar datatypes to have values and they work fine.</p>
  <blockquote>
  <p>Fatal error: Uncaught mysqli_sql_exception: Incorrect integer value: '' for column 'topic_id' at row 1 in C:\wamp64\www\mycode\upload2.php on line 32</p>
  <p>mysqli_sql_exception: Incorrect integer value: '' for column 'topic_id' at row 1 in C:\wamp64\www\mycode\upload2.php on line 32</p>
  </blockquote>
  <p>Code:</p>
  <pre><code>ALTER TABLE `topics` CHANGE `topic_id` `topic_id` INT(11) NOT NULL 
  AUTO_INCREMENT; 
  // This isn't changing the int value at all!
  </code></pre>