Why does mysql skip some auto increment ids?

Why does mysql skip some auto increment ids?



1.Why does mysql skip some auto increment ids? - Stack Overflow

Description:I have seen many explanations why mysql skips some auto
increment values (and that it is not a bug as mysql never states that they
should be consecutive).



2.MySQL :: auto increment primary key skips numbers

Description:$_Refererid = mysql_insert_id(); ... Why are some numbers
being skipped? ... auto increment primary key skips numbers: 1339:



3.php - MYSQL insert records skipping ids (Auto Increment ...

Description:I am kind of guessing what the code will look like, since I am
too working with PayPal APIs now, but here is a way to let the
auto_increment do it's job



4.MySQL :: insert values with ID being auto increment

Description:... you have an error in your SQL please check MySQL server
... Could some one please let me know what the ... insert values with ID
being auto increment: 33476:



5.MySQL Bugs: #47933: auto_increment

Description:... load data operation will skip some auto increment ... 0
thank 0 bye mysql> create table test(id int auto ... does if he is not a
MySQL ...



6.MySQL Bugs: #6287: Slave skips auto_increment values in ...

Description:... some values in an auto_increment column when ... MySQL
first runs SET INSERT_ID ... It is not reviewed in advance by Oracle and
does not necessarily ...



7.MySQL :: MySQL 5.0 Reference Manual :: 3.6.9 Using AUTO ...

Description:The AUTO_INCREMENT attribute can be used to generate a unique
identity for new rows: CREATE TABLE animals ( id MEDIUMINT NOT NULL
AUTO_INCREMENT ...



8.MySQL Lists: mysql: RE: Reset auto_increment

Description:... , AUTO_INCREMENT = 1; But why do this? MySQL doesn't care
if the sequence has holes in it or not. ... that is the "Id" starts form 1
and does not skip >the number.



9.MySQL Lists: mysql: why not set GLOBAL SQL_SLAVE_SKIP ...

Description:... my problem is why not SET GLOBAL SQL_SLAVE_SKIP ... that
use AUTO_INCREMENT or LAST_INSERT_ID() ... by Oracle and does not
necessarily ...



10.Auto-increment IDs from the Course MySQL Essential Training

Description:Auto-increment IDs From: MySQL Essential Training ...
Auto-increment IDs. ... We've moved some things around, ...