MYSQL auot increment

[skwap]

why the mysql auto increment value start from the last added row ?

means suppose i delete the 4th id user & next new user id value will be 5 not 4.

 

Demo table

 

id      user

1        A

2        B

3        C

5        D

[@]

thats because auto increment will never reuse the same increment twice - it enforces referential integrity.

you can reset it by using truncate but that will remove ALL of the data from the table.

[MasterACE14]

thats because auto increment will never reuse the same increment twice - it enforces referential integrity.

you can reset it by using truncate but that will remove ALL of the data from the table.

 

this is true, you can however manually set a records ID to one that doesn't exist.