正向工程MySQL Workbench错误1064 [英] Forward Engineering MySQL Workbench Error 1064
问题描述
我制作了一个EER图,我正尝试对其进行正向工程,但出现此错误,但找不到错误.
I made a EER diagram and I am trying to Forward Engineer it but I get this error and I can't find the mistake.
在服务器中执行SQL脚本错误:错误1064:您在 您的SQL语法;检查与您的MariaDB相对应的手册 用于在'INDEX附近使用的正确语法的服务器版本
fk_User_Wallets1_idx
(Wallets_idWallets
ASC)可见,约束' 在第13行
Executing SQL script in server ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INDEX
fk_User_Wallets1_idx
(Wallets_idWallets
ASC) VISIBLE, CONSTRAINT ' at line 13
SQL代码:
CREATE TABLE IF NOT EXISTS `mydb`.`User` (
`idUser` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(45) NULL,
`email` VARCHAR(45) NULL,
`adress` VARCHAR(45) NULL,
`password` VARCHAR(45) NULL,
`saldo` INT NULL,
`date_start` DATETIME NULL,
`date_end` DATETIME NULL,
`Rolls_idRolls` INT NOT NULL,
`Wallets_idWallets` INT NOT NULL,
PRIMARY KEY (`idUser`, `Rolls_idRolls`, `Wallets_idWallets`),
INDEX `fk_User_Rolls1_idx` (`Rolls_idRolls` ASC) VISIBLE,
INDEX `fk_User_Wallets1_idx` (`Wallets_idWallets` ASC) VISIBLE,
CONSTRAINT `fk_User_Rolls1`
FOREIGN KEY (`Rolls_idRolls`)
REFERENCES `mydb`.`Rolls` (`idRolls`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_User_Wallets1`
FOREIGN KEY (`Wallets_idWallets`)
REFERENCES `mydb`.`Wallets` (`idWallets`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
SQL script execution finished: statements: 11 succeeded, 1 failed
Fetching back view definitions in final form.
Nothing to fetch
推荐答案
您可以添加引擎
ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
这篇关于正向工程MySQL Workbench错误1064的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!