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

This article mainly introduces the example analysis of self-increasing id in mysql, which has a certain reference value, and interested friends can refer to it. I hope you will gain a lot after reading this article.

For auto_increment fields, such as:

CREATE TABLE `aa` (

`a`int (11) NOT NULL auto_increment

`b` int (11) NOT NULL

PRIMARY KEY (`a`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

Insert into aa values (1000 and 1)

CREATE TABLE `aa` (

`a`int (11) NOT NULL auto_increment

`b` int (11) NOT NULL

PRIMARY KEY (`a`)

) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8

Update aa set id=id+100

CREATE TABLE `aa` (

`a`int (11) NOT NULL auto_increment

`b` int (11) NOT NULL

PRIMARY KEY (`a`)

) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8

It is found that the auto_increment is still unchanged, or 1001.

Mysql > select * from aa

+-+

| | a | b | |

+-+

| | 1100 | 1 | |

So it can be concluded that for self-increasing id, if you add or subtract some numbers on id, the self-increasing number is the same!

Thank you for reading this article carefully. I hope the article "sample Analysis of self-added id in mysql" shared by the editor will be helpful to you. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.