Shulou(Shulou.com)06/01 Report--

How does mysql set the conditions for self-increasing id? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Mysql sets the condition of self-increasing id: 1, set the id field as the primary key when establishing the data table; 2, use the "alter table table name modify id int (11) auto_increment;" statement to add the auto_increment attribute to the id field.

When the PHP file executes the MySQL database insert statement, it is often necessary to execute the id self-growing attribute. Otherwise, when the mysqli_insert_id function is executed, it always returns 0.

If you want to achieve id self-increment, you need to set id as the primary key and AUTO_INCREMENT when creating the data table.

Use SQL statements to set self-increment for existing primary key fields

Step 1: add the auto_increment attribute to id

Alter table tablename modify id int (11) auto_increment

Step 2: set the initial value for self-increment

Alter table tablename auto_increment=10000;, thank you for your reading! After reading the above, do you have a general understanding of how mysql sets the conditions for self-increasing id? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.