title: SQL error - Incorrect table definition; there can be only one auto column
body: <p>What is wrong with this SQL,
      -> );
      ERROR 1075 (42000): Incorrect table definition; there can be only one auto column</p>
  
  <p>SQL</p>
  
  <pre><code>CREATE TABLE TABLENAME12
  (
  TAB_ID INT NOT NULL AUTO_INCREMENT,
  
  NAME_FIRST NVARCHAR(200),
  TYPE NVARCHAR(200)
  
  );
  </code></pre>
  
  <p>I am using mysql, how can I solve this. I am trying to create a table. and I get this error</p>