All geek questions in one place

How to install full text in MySQL Workbench?

I am trying to set the Full Text property for some columns in a table in a MySQL InnoDB .

I can’t find the option in MySQL Workbench, and I tried various searches on Google to find out how, but I couldn’t find anything.

These are my current options:

 PK = Primary Key NN = Not Null UQ = Unique Key BIN = Binary UN = Unsigned ZF = Zero Filled AI = Auto Increment

MW Screenshot of property options

Where can I find the Full Text option in MySQL Workbench?

+7
source share
2 answers

FULLTEXT is an index type, not a column attribute. When you create an index, you can select any of the types INDEX, UNIQUE, FULLTEXT and PRIMARY. See Table Editor on the Index Tab.

enter image description here

+7
source

You can see my photo. It can display the index type FULLTEXT.

  • alte table
  • index sheet
  • index type, you can find FULLTEXT.
-2
source

Source: https://habr.com/ru/post/951169/

More articles:


All Articles