title: Adding multiple columns AFTER a specific column in MySQL
body: <p>I need to add multiple columns to a table but position the columns <strong>after</strong> a column called <code>lastname</code>.</p>
  
  <p>I have tried this:</p>
  
  <pre><code>ALTER TABLE `users` ADD COLUMN
  (
      `count` smallint(6) NOT NULL,
      `log` varchar(12) NOT NULL,
      `status` int(10) unsigned NOT NULL
  ) 
  AFTER `lastname`;
  </code></pre>
  
  <p>I get this error:</p>
  
  <blockquote>
    <p>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 ') AFTER <code>lastname</code>' at line 7</p>
  </blockquote>
  
  <p><br>
  How can I use AFTER in a query like this?</p>