Shulou(Shulou.com)05/31 Report--

Why MySQL self-increasing primary keys are not continuous, in view of this question, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a simpler and easier way.

In our daily use of Mysql, if it is not a special business need, we usually use self-increasing primary key. The benefit of self-increasing primary key can minimize page segmentation and increase the writing efficiency of Mysql when inserting. We sometimes find that the self-increasing primary key is not continuously increasing, why does it sometimes appear the hole of the self-increasing primary key?

Even tables that use self-incrementing primary keys can specify primary keys. Suppose the current self-increasing primary key is X, and the primary key we specify is Y, if Y

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.