title: ALTER table - adding AUTOINCREMENT in MySQL
body: <p>I created a table in MySQL with on column <code>itemID</code>.</p>
  <p>After creating the table, now I want to change this column to <code>AUTOINCREMENT</code>.</p>
  <p><strong>How can this be done using ALTER statements</strong>?</p>
  <p>Table definition:</p>
  <p><code>ALLITEMS (itemid int(10) unsigned, itemname varchar(50))</code></p>
  <p>I am using the following code but it is throwing a syntax error</p>
  <p><strong>Error: syntax incorrect</strong>.</p>
  <pre><code>ALTER TABLE allitems
  MODIFY itemid INT(10) UNSIGNED AUTOINCREMENT; 
  </code></pre>