问题描述
我使用 xampp 控制面板，然后我开始了 apache 和 mysql 的进程.然后我去 mysql 工作台，服务器状态似乎没问题，这是一些信息
Im using xampp control panel and from there i start the process for apache and mysql. Then i go to mysql workbench and server status seems to be ok, here is some info
Host: Windows-PC
Socket: C:/xampp/mysql/mysql.sock
Port: 3306
Version 10.1.31-MariaDB mariadb.org binary distribution
Compiled For: Win32(32)
Configuratin File: unknown
然后每次当我尝试为我的虚拟模式添加外键时:
Then everytime when i try to add the foreign key for my dummy schema like:
ALTER TABLE `puppies`.`animals`
ADD INDEX `Breed_idx` (`BreedID` ASC) VISIBLE;
;
ALTER TABLE `puppies`.`animals`
ADD CONSTRAINT `Breed`
FOREIGN KEY (`BreedID`)
REFERENCES `puppies`.`breeds` (`Breed`)
ON DELETE NO ACTION
ON UPDATE NO ACTION;
我收到以下错误
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
'' at line 2
SQL Statement:
ALTER TABLE `puppies`.`animals`
ADD INDEX `Breed_idx` (`BreedID` ASC) VISIBLE
那么我该怎么做才能让 xampp 开始使用 mysql 语法而不是 mariaDb?
So what can i do so that xampp will start using mysql syntax over mariaDb?
或者如果我对问题的理解有误，那么我应该怎么做才能在使用 xampp 时不再遇到此类问题?
Or if im wrong in my understanding of the problem, then what should i do so that i dont have to face this kind of issues again when using xampp?
推荐答案
问题是VISIBLE这个词，去掉它就可以了.索引默认可见.
Problem is the word VISIBLE, remove it and it will work.Index are visible by default.
您的问题:如果我删除 VISIBLE，它就可以正常工作，那么为什么 mysql workbench 决定添加可见?"
Your question: "If i remove VISIBLE it works just fine, so why did mysql workbench decided to add visible?"
我的回答:将索引标记为不可见的选项尚未在 MariaDB 中实现(afaik！).
My answer: The option to mark index invisible is not yet implemented in MariaDB (afaik!).
更新:
MariaDB 的语法不同，请参阅此参考:https://jira.mariadb.org/browse/MDEV-7317
The syntax for MariaDB is different, please see this reference: https://jira.mariadb.org/browse/MDEV-7317
这篇关于MySQL 错误 1064 语法但一切似乎都很好的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！