mysql - MySQL Workbench 模式同步导致错误 1064
问题描述
我正在使用 MySQL Workbench 尝试为我的数据库创建模式。当我尝试将其同步到服务器时,我收到错误 1064。这是完整的日志:
Executing SQL script in server
ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
PRIMARY KEY (`id`),
CONSTRAINT `buildings_rel`
FOREIGN KEY (`bu' at line 10
SQL Code:
CREATE TABLE IF NOT EXISTS `rentals`.`apartments` (
`beds` INT(11) NOT NULL,
`baths` INT(11) NOT NULL,
`area` INT(11) NOT NULL,
`price_min` INT(11) NOT NULL,
`price_max` INT(11) NOT NULL,
`available_now` BIT(1) NOT NULL,
`building_id` INT(11) NULL DEFAULT NULL,
`id` INT(11) NOT NULL AUTO_INCREMENT,
INDEX `buildings_rel_idx` (`building_id` ASC) VISIBLE,
PRIMARY KEY (`id`),
CONSTRAINT `buildings_rel`
FOREIGN KEY (`building_id`)
REFERENCES `rentals`.`buildings` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
我真的不知道 SQL,所以我很难弄清楚这里到底出了什么问题。我希望工作台能够创建正确的代码,但我有点惊讶它似乎出现了这种故障。任何帮助表示赞赏,谢谢。
解决方案
知道了!正如一些评论者所说,我必须在 MySQL Workbench 设置中设置不同的目标版本。谢谢!
推荐阅读
- python - very weird question for object nesting of python
- mysql - How do I add dynamic data to a database table?
- python - PyTorch: Error>> expected scalar type float but found double
- node.js - websocket node.js module "ws" not working - infinite load
- javascript - Shared tooltip on multiple charts not formatting correctly
- android - Request from the database during activity creation
- kotlin - Kotlin:在构造函数中访问非最终属性名称
- android - 将新 ns 映射到旧 ns
- authentication - NextJS 静态 SSG 认证
- c++ - 数组结束时指针不应该指向 nullptr 吗?