title: MySql can't make column auto_increment
body: <p>I have a table "Bestelling" with 4 columns: "Id" (PK), "KlantId", "Datum", "BestellingsTypeId", now I want to make the column Id auto_increment, however, when I try to do that, I get this error:</p>
  
  <pre><code>ERROR 1062: ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'
  
  SQL Statement:
  
  ALTER TABLE `aafest`.`aafest_bestelling` CHANGE COLUMN `Id` `Id` INT(11) NOT NULL AUTO_INCREMENT
  
  
  
  ERROR: Error when running failback script. Details follow.
  
  
  
  ERROR 1046: No database selected
  
  SQL Statement:
  
  CREATE TABLE `aafest_bestelling` (
  
    `Id` int(11) NOT NULL,
  
    `KlantId` int(11) DEFAULT NULL,
  
    `Datum` date DEFAULT NULL,
  
    `BestellingstypeId` int(11) DEFAULT NULL,
  
    PRIMARY KEY (`Id`)
  
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1
  </code></pre>
  
  <p>Anyone got an idea?</p>