title: #1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
body: <p>Can the people of the internet help me with MySQL</p>
  
  <p>Error</p>
  
  <p>SQL query:</p>
  
  <pre><code>CREATE TABLE `users` (
  `user_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
  `username` VARCHAR( 32 ) NOT NULL ,
  `password` VARCHAR( 32 ) NOT NULL ,
  `first_name` VARCHAR( 32 ) NOT NULL ,
  `last_name` VARCHAR( 32 ) NOT NULL ,
  `email` VARCHAR( 1024 ) NOT NULL ,
  `active` INT( 11 ) NOT NULL DEFAULT '0'
  ) ENGINE = innodb
  </code></pre>
  
  <p>MySQL said: Documentation</p>
  
  <pre><code>#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key 
  </code></pre>