title: `MODIFY COLUMN` vs `CHANGE COLUMN`
body: <p>I know, we cannot rename a column using <code>MODIFY COLUMN</code> syntax, but we can using <code>CHANGE COLUMN</code> syntax.</p>
  <p>My question is: what is the main usage of <code>modify syntax</code>?</p>
  <p>For example:</p>
  <pre><code>ALATER TABLE tablename CHANGE col1 col1 INT(10) NOT NULL;
  </code></pre>
  <p>instead of</p>
  <pre><code>ALATER TABLE tablename MODIFY col1 INT(10) NOT NULL;
  </code></pre>
  <br />
  <hr />
  <h1>Edited (question replaced)</h1>
  <ul>
  <li>What is the main usage of <code>MODIFY</code> syntax?</li>
  <li>Why we have to use <code>CHANGE COLUMN</code> instead of <code>MODIFYCOLUMN</code>?</li>
  </ul>