How to disable INVISIBLE index option in MySqlWorkbench?

Question

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

It doesn't take a lot of effort to find dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html — P.Salmon
– P.Salmon, Commented Nov 22, 2018 at 16:19
Does this answer your question? MySQL Workbench: Error in query (1064): Syntax error near 'VISIBLE' at line 1 — Shiwangini
– Shiwangini, Commented Sep 27, 2021 at 5:28

Madhur Bhaiya · Accepted Answer · 2018-11-22 16:16:57Z

9

In MySQL Workbench:

Go to:

Edit > Preferences > Modeling > MySQL.

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

Check the screenshot below:

answered Nov 22, 2018 at 16:16

Madhur Bhaiya

28.9k10 gold badges53 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1