2

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

Spartaok
  • 199
  • 3
  • 15
  • It doesn't take a lot of effort to find https://dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html – P.Salmon Nov 22 '18 at 16:19
  • https://stackoverflow.com/a/54340816/2813567 – Channa Sep 27 '21 at 05:27
  • Does this answer your question? [MySQL Workbench: Error in query (1064): Syntax error near 'VISIBLE' at line 1](https://stackoverflow.com/questions/52785125/mysql-workbench-error-in-query-1064-syntax-error-near-visible-at-line-1) – Channa Sep 27 '21 at 05:28

1 Answers1

9

In MySQL Workbench:

Go to:

Edit > Preferences > Modeling > MySQL.

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

Check the screenshot below:

enter image description here

Madhur Bhaiya
  • 28,155
  • 10
  • 49
  • 57