How to set index in navicat

Open Navicat.

Open the database where the data table is located, right-click the database table where you want to add fields, and then click "Design Table".

Now enter the table design interface.

Related recommendations: "Navicat for mysql graphic tutorial"

Click the "Index" tab and enter the index name, Such as newindex.

In the field selection dialog box, select the field to be indexed, such as the code field, and then click "OK".

Select the index type, such as unique.

Select the indexing method, such as hush, and then click "Save" to complete the index creation.

The above is the detailed content of How to set index in navicat. For more information, please follow other related articles on the PHP Chinese website!