MySQL 错误 1064 语法，但一切似乎都很好 [英] MySQL error 1064 syntax but everything seems fine

问题描述

我正在使用 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 开始在 mariaDb 上使用 mysql 语法?

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 工作台决定添加可见?"

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 语法，但一切似乎都很好的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！