title: SQL Operation order for 'AFTER' and 'COMMENT'
body: <p>Hello I need to edit a database to add new columns. But I encountered a little problem, because I need to add comments to these new columns and I also need to add them after a certain column in the exist table.</p>
  <p>Is this the correct syntax? :</p>
  <pre><code>ALTER TABLE `table`
  ADD COLUMN `new` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '...' AFTER `secondlastcolumn`;
  </code></pre>
  <p>Or would this be correct? :</p>
  <pre><code>ALTER TABLE `table`
  ADD COLUMN `new` VARCHAR(50) NOT NULL DEFAULT '' AFTER `secondlastcolumn` COMMENT '...';
  </code></pre>
  <p>Or is there another way of doing this?</p>
  <p>I couldn't find a answer with an <em><strong>ADD COLUMN</strong></em>, only for modifying columns.</p>