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
I can't find the error I have checked my syntax I'm using mysql workbench 8.0