mysql - SQL错误1022 : Can't write; duplicate key in table

Question

我已经阅读了这里所有类似的错误，但仍然无法弄清楚为什么会出现此错误

Executing SQL script in server
ERROR: Error 1022: Can't write; duplicate key in table 'storage'
SQL Code:
    -- -----------------------------------------------------
    -- Table `storehouse`.`storage`
    -- -----------------------------------------------------
    CREATE TABLE IF NOT EXISTS `storehouse`.`storage` (
      `product_id` INT NOT NULL,
      `quantity` INT NULL,
      `storage_room` INT NULL,
      UNIQUE INDEX `product_id_UNIQUE` (`product_id` ASC),
      INDEX `storage_room_idx` (`storage_room` ASC),
      CONSTRAINT `product_id`
        FOREIGN KEY (`product_id`)
        REFERENCES `storehouse`.`product` (`product_id`)
        ON DELETE NO ACTION
        ON UPDATE NO ACTION,
      CONSTRAINT `storage_room`
        FOREIGN KEY (`storage_room`)
        REFERENCES `storehouse`.`space` (`space_id`)
        ON DELETE NO ACTION
        ON UPDATE NO ACTION)
    ENGINE = InnoDB

我已经检查过:所有键都是唯一的

Answer 1

我需要检查数据库中的所有外键和约束名称。一个约束与键同名——这就是 mysql 工作台的工作原理