MySql自动增量无法增量重复位置0条目

Question

我们正在运行查询:

INSERT INTO `macroSet` (`id`,`name`,`createdAt`,`updatedAt`) VALUES (DEFAULT, 'Body Regions NEB-9377','2019-05-22 23:57:38','2019-05-22 23:57:38');

MYSQL 返回键 0 的重复条目。

有一个 id 位置 0 的条目，但它不应该通过设置自动增量来递增，而不是尝试在位置键 0 处插入另一个值吗？

此外，我们的增量值为 32，因此从技术上讲，应该将增量设置为 0 之后的 32，正确吗？

这是我们的宏表的表转储。

CREATE TABLE `macroSet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `subjectiveFolderId` int(11) DEFAULT NULL,
  `objectiveFolderId` int(11) DEFAULT NULL,
  `assessmentFolderId` int(11) DEFAULT NULL,
  `planFolderId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_name_macro_set` (`name`),
  KEY `fk_subjective_folder_id_macro_set` (`subjectiveFolderId`),
  KEY `fk_objective_folder_id_macro_set` (`objectiveFolderId`),
  KEY `fk_assessment_folder_id_macro_set` (`assessmentFolderId`),
  KEY `fk_plan_folder_id_macro_set` (`planFolderId`),
  CONSTRAINT `fk_assessment_folder_id_macro_set` FOREIGN KEY (`assessmentFolderId`) REFERENCES `folder` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_objective_folder_id_macro_set` FOREIGN KEY (`objectiveFolderId`) REFERENCES `folder` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_plan_folder_id_macro_set` FOREIGN KEY (`planFolderId`) REFERENCES `folder` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_subjective_folder_id_macro_set` FOREIGN KEY (`subjectiveFolderId`) REFERENCES `folder` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

任何有关导致此行为的原因的想法将不胜感激!

Answer 1

指针是 32 (AUTO_INCRMENT=32)，没有“默认值”

尝试:

INSERT INTO `macroSet` (`id`,`name`,`createdAt`,`updatedAt`) VALUES (33, 'Body Regions NEB-9377','2019-05-22 23:57:38','2019-05-22 23:57:38');

或

INSERT INTO `macroSet` (`name`,`createdAt`,`updatedAt`) VALUES ('Body Regions NEB-9377','2019-05-22 23:57:38','2019-05-22 23:57:38');