title: MySQL: How to solve syntax error on ALTER TABLE statement during change type of column
body: <p>When running </p>
  
  <pre><code>ALTER TABLE my_table modify column my_column int(10) NOT NULL DEFAULT 0;
  </code></pre>
  
  <p>I've got the error message: </p>
  
  <pre><code>Error: 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 'int(10) NOT NULL DEFAULT 0' at line 1.
  </code></pre>
  
  <p>How can this issue being fixed?</p>