The solution of self-increasing error in setting id Primary key by phpmyadmin

This article mainly introduces phpmyadmin set id primary key self-increasing error solution, the article is very detailed, has a certain reference value, interested friends must read!

phpmyadmin How to set id primary key self-increment error?

Learn php using phpmyadmin often encountered no way to set up a table from the primary key increase problem.

Only help sql statement, in fact phpmyadmin can be set, drag to the far right when modifying the field to see the self-increasing option.

solution

Login to phpmyadmin Select a table in the database and select the structure.

Find the primary key you want to set to self-increment (click the key button if it is not set yet).

Click Modify.

Drag the browser scroll bar to the far right of the displayed field definition to find the word A_I, which is the automatic increment sign, and tick it.

Click Save, and this time you will have a self-added primary key.

The above is "phpmyadmin set id primary key self-increase error solution" all the contents of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!