How to use SQLyog to modify the index type of a database table-SQLyog usage tutorial

Time: 2020-09-23Source: Huajun Software TutorialAuthor: Ai Xiaomo

Don’t you know how to use SQLyog to modify the index type of a database table? This section introduces the operation content of using SQLyog to modify the index type of a database table. Friends who don't know yet can follow the editor to learn. I hope it will be helpful to you.

Open the SQLyog software, open the database connection, and the created database will be displayed.

1.jpg

Expand all tables under the database to be operated on

2.jpg

Right-click the table you want to operate and select [Change Table]

3.jpg

The table editing interface is displayed.

4.jpg

Click the [Index] tab

5.jpg

Click the [Index Type] drop-down list and select another index type.

6.jpg

Click [Save] and the index type will be modified.

7.jpg

The above explains the operation process of using SQLyog to modify the index type of a database table. I hope friends in need can learn it.

Related articles更多>>

Popular recommendations