0

Here is my query

CREATE TABLE IF NOT EXISTS `University_Management_System`.`department` (
  `department_id` INT NOT NULL AUTO_INCREMENT,
  `faculty_id` INT NOT NULL,
  `department_name` VARCHAR(45) NULL,
  PRIMARY KEY (`department_id`),
  INDEX `fk_Department_Faculty1_idx` (`faculty_id` ASC) VISIBLE,
  CONSTRAINT `fk_Department_Faculty1`
    FOREIGN KEY (`faculty_id`)
    REFERENCES `University_Management_System`.`Faculty` (`faculty_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB

I got below error

check the manual that corresponds to your mariadb server version for the right syntax to use near

enter image description here

I can't find the error I have checked my syntax I'm using mysql workbench 8.0

Bill Karwin
  • 538,548
  • 86
  • 673
  • 828
raveen
  • 13
  • 3

0 Answers0