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 - 无法添加外键约束
也应该有表格Rio VAMOOS Database
.State
和Rio VAMOOS Database
.Official
.如果没有这些表,您将在尝试运行此查询时ERROR 1215 (HY000): Cannot add foreign key constraint
。
您应该在Rio VAMOOS Database
之前检查这两个表是否导入。Card