How to create 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].

Related recommendations: "Navicat for mysql graphic tutorial"

Enter the table design interface at this time.

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], and the index will be created.

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