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

This article will explain in detail about mysql self-added deletion, add data id will not be immediately after the solution, Xiaobian think quite practical, so share with you for a reference, I hope you can read this article after harvest.

After mysql self-increment and deletion, add the data id will not be immediately solved: first open Mysql code editing; then after deleting 4, execute the relevant sql statement, the code is [ALTER TABLE_name AUTO_INCREMENT = 1;].

After mysql self-increment and deletion, add data id will not be followed by solution:

Problem: After deleting the self-increasing id data in mysql table, when adding data again, id will not follow.

For example:

auto-increment IDs

1234

Now delete 4, and it becomes

123

At this point, if you add a piece of data, it becomes

1235

5 above is not the result we want, 4 is the ideal id,

The solution is to delete 4 and execute the following sql statement:

ALTER TABLE table_name AUTO_INCREMENT = 1; About mysql after self-addition and deletion, add data id will not immediately share the solution here, I hope the above content can have some help for everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

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.