How to modify the primary key in phpmyadmin

How to modify the primary key in phpmyadmin?

phpmyadmin sets the primary key, phpMyAdmin primary key is added

Open the phpMyAdmin application software, enter the database name and login password on the login page, and then click Execute, as shown in the figure below.

Recommendation: "mysql tutorial"

##After successfully logging in to phpMyAdmin, click Database on the navigation on the left. As shown below.

In the phpMyAdmin database, we click to create a new database table, as shown in the figure below.

After opening the phpMyAdmin new database table page, click the drop-down menu in the "Index" of the new table column on the right to select primary. Selecting primary means that the primary key of the table has been set. , and then click Execute, as shown in the figure below.

Add and set the primary key to the built phpMyAdmin table

Find the table to which you want to add the primary key in the database corresponding to phpMyAdmin. Then click on the corresponding "Structure" behind the table, as shown in the figure below.

After opening the phpMyAdmin database table structure, we can see the primary key corresponding to the database table. We click on the primary key to add and set the primary key to the phpMyAdmin table, as shown in the figure below .

OK, phpMyAdmin prompts that the table primary key has been set successfully. At this time, you can see that the key at the primary key changes color, as shown in the figure below.

Code to add and set the primary key of the phpMyAdmin table

I see clicking to open the SQL tab on the phpMyAdmin software, and then in the input box Enter the code to set the primary key of phpMyAdmin, and then click Execute. As shown below.

The above is the detailed content of How to modify the primary key in phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!