How to set the default value of primary key in phpMyAdmin

When phpmyadmin creates a data table, the default value of the primary key is set as follows. At first we enter 30, then the field stu_id will increase automatically from 30

Click to execute

Insert another piece of data, let’s make the value empty

Click Insert

and you can see that Zhang San’s ID is 31, which is incremented based on the previous one (that is, starting from 30). If you do not set the default value of the primary key, it will increase automatically from 1.

It is recommended to study "phpmyadmin".

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