在mysql工作台中创建第一个表有一个小问题。当我创建两个表并查看前进的工程进度时,会收到如下消息:
在服务器中执行SQL脚本
错误:错误1064:您的SQL语法有错误;
检查与您的mariadb服务器版本相对应的手册
使用正确的语法
指数
fk_person_has_user_person_idx
(
person_ID
asc)可见,
第8行的“约束”
SQL代码:
-- -----------------------------------------------------
-- Table `customers`.`person_has_user`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `customers`.`person_has_user` (
`person_ID` INT NOT NULL,
`user_person_ID` INT NOT NULL,
PRIMARY KEY (`person_ID`, `user_person_ID`),
INDEX `fk_person_has_user_user1_idx` (`user_person_ID` ASC) VISIBLE,
INDEX `fk_person_has_user_person_idx` (`person_ID` ASC) VISIBLE,
CONSTRAINT `fk_person_has_user_person`
FOREIGN KEY (`person_ID`)
REFERENCES `customers`.`person` (`ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_person_has_user_user1`
FOREIGN KEY (`user_person_ID`)
REFERENCES `customers`.`user` (`person_ID`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
SQL script execution finished: statements: 7 succeeded, 1 failed
Fetching back view definitions in final form.
Nothing to fetch
有人能解释一下吗?