mysql不能 读取自动递增的值_sql-MySql不能使列自动递增

sql-MySql不能使列自动递增

我有一个包含4列的“ Bestelling”表：“ Id”(PK)，“ KlantId”，“ Datum”，“ BestellingsTypeId”，现在我想使列ID为auto_increment，但是，当我尝试这样做时，我 得到这个错误：

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 CHARS