title: Altering a table column using change
body: <p>Altering a table column using <code>change</code> is not working but using <code>modify</code> the same query statement works fine.</p>
  
  <p><strong>With change it fails:</strong></p>
  
  <pre><code>alter table users change name varchar(100);
  </code></pre>
  
  <p><strong>Error Code: 1064</strong>. 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 'varchar(100)' at line 1    0.000 sec</p>
  
  <p><strong>With Modify it works.</strong></p>
  
  <pre><code>alter table users modify name varchar(100);
  </code></pre>