如何在 MySqlWorkbench 中禁用 INVISIBLE 索引选项? [英] How to disable INVISIBLE index option in MySqlWorkbench?

问题描述

我刚刚安装了 MySqlWorkbench 并且我找到了 INVISIBLE index 的实现，它被描述为

I have just installed MySqlWorkbench and I have found the implementation of INVISIBLE index which is described here.

I want disable this feature because the version of MySql which run on my server is older. So when I try to import the script I'll get an error:

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 'INVISIBLE,

is possible disable it? because at the moment I need to remove manually that keyword

解决方案

In MySQL Workbench:

Go to:

Edit > Preferences > Modeling > MySQL.

Then, set the "Default Target MySQL Version" to 5.7

Check the screenshot below:

这篇关于如何在 MySqlWorkbench 中禁用 INVISIBLE 索引选项?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！