从 MySQL 工作台文件导入时出现 MySQL 外键约束问题

Question

SQL查询:

CREATE TABLE IF NOT EXISTS `Rio VAMOOS Database`.`Card` (
  `Card_id` INT(8) NOT NULL,
  `Card_start_date` DATETIME NOT NULL,
  `Card_end_date` DATETIME NOT NULL,
  `State_validity` VARCHAR(8) NOT NULL,
  `Official_Official_id` INT(8) NOT NULL,
  PRIMARY KEY (`Card_id`),
  INDEX `fk_Card_State1_idx` (`State_validity` ASC),
  INDEX `fk_Card_Official1_idx` (`Official_Official_id` ASC),
  CONSTRAINT `fk_Card_State1`
    FOREIGN KEY (`State_validity`)
    REFERENCES `Rio VAMOOS Database`.`State` (`Card_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Card_Official1`
    FOREIGN KEY (`Official_Official_id`)
    REFERENCES `Rio VAMOOS Database`.`Official` (`Official_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

MySQL 说:文档

1215 - 无法添加外键约束

Answer 1

还应该有表Rio VAMOOS Database.State和Rio VAMOOS Database.Official。如果没有这些表，您在尝试运行此查询时将收到错误 1215 (HY000): 无法添加外键约束。

您应该在Rio VAMOOS Database之前检查这两个表是否导入。Card