[Solved] Autoincrement problem [duplicate]

Question

You received the answer the last time you posted this question. MySQL maintains an internal counter that is incremented every time a new row is inserted into a table with an auto-increment column. The increment value does not go down when a row is deleted.

To make things work the way you want, you will need to avoid using MySQL autoincrement, and implement your own solution to create and increment IDs.

Accepted Answer

You received the answer the last time you posted this question. MySQL maintains an internal counter that is incremented every time a new row is inserted into a table with an auto-increment column. The increment value does not go down when a row is deleted.

To make things work the way you want, you will need to avoid using MySQL autoincrement, and implement your own solution to create and increment IDs.