Home  >  Article  >  Backend Development  >  Mysql, in addition to deleting the table, under what circumstances may the record id value span a large span, as shown below

Mysql, in addition to deleting the table, under what circumstances may the record id value span a large span, as shown below

WBOY
WBOYOriginal
2016-08-04 09:20:59906browse

Mysql, in addition to deleting the table, under what circumstances may the record id value span a large span, as shown below

Reply content:

Mysql, in addition to deleting the table, under what circumstances may the record id value span a large span, as shown below

Insertion failed during batch insertion

Changed the self-increasing ID

When the auto-incremented id value is smaller than the id of the batch imported data,
or there is a large gap in the id of the imported data itself, it will also cause

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn