How to disable INVISIBLE index option in MySqlWorkbench?
up vote
1
down vote
favorite
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
mysql mysql-workbench
add a comment |
up vote
1
down vote
favorite
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
mysql mysql-workbench
It doesn't take a lot of effort to find dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
– P.Salmon
Nov 22 at 16:19
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
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
mysql mysql-workbench
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
mysql mysql-workbench
mysql mysql-workbench
asked Nov 22 at 16:14
Spartaok
728
728
It doesn't take a lot of effort to find dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
– P.Salmon
Nov 22 at 16:19
add a comment |
It doesn't take a lot of effort to find dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
– P.Salmon
Nov 22 at 16:19
It doesn't take a lot of effort to find dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
– P.Salmon
Nov 22 at 16:19
It doesn't take a lot of effort to find dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
– P.Salmon
Nov 22 at 16:19
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
In MySQL Workbench:
Go to:
Edit > Preferences > Modeling > MySQL.
Then, set the "Default Target MySQL Version" to 5.7
Check the screenshot below:
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
In MySQL Workbench:
Go to:
Edit > Preferences > Modeling > MySQL.
Then, set the "Default Target MySQL Version" to 5.7
Check the screenshot below:
add a comment |
up vote
1
down vote
accepted
In MySQL Workbench:
Go to:
Edit > Preferences > Modeling > MySQL.
Then, set the "Default Target MySQL Version" to 5.7
Check the screenshot below:
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
In MySQL Workbench:
Go to:
Edit > Preferences > Modeling > MySQL.
Then, set the "Default Target MySQL Version" to 5.7
Check the screenshot below:
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 at 16:16
Madhur Bhaiya
19.2k62236
19.2k62236
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53434830%2fhow-to-disable-invisible-index-option-in-mysqlworkbench%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
It doesn't take a lot of effort to find dev.mysql.com/doc/workbench/en/wb-table-editor-indexes-tab.html
– P.Salmon
Nov 22 at 16:19