在服务器中执行SQL脚本
错误:错误1064:您的SQL语法有错误;请查看与MySQL服务器版本相对应的手册,以获取在“VISIBLE”附近使用的正确语法,
约束
fk_WEEK_WORKOUT
外键(
WORKOUT_IdWorkout
)
'在第12行
SQL代码:
-- -----------------------------------------------------
-- Table `mydb`.`WEEK`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`WEEK` (
`WeekOne` VARCHAR(27) NOT NULL,
`WeekTwo` VARCHAR(27) NOT NULL,
`WeekThree` VARCHAR(27) NOT NULL,
`WeekFour` VARCHAR(27) NOT NULL,
`IdWeek` INT NOT NULL,
`WORKOUT_IdWorkout` INT NOT NULL,
PRIMARY KEY (`IdWeek`),
INDEX `fk_WEEK_WORKOUT_idx` (`WORKOUT_IdWorkout` ASC) VISIBLE,
CONSTRAINT `fk_WEEK_WORKOUT`
FOREIGN KEY (`WORKOUT_IdWorkout`)
REFERENCES `mydb`.`WORKOUT` (`IdWorkout`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
无论我做什么改变,每次我都会得到这个