How to fill out the table?

0 like 0 dislike
13 views
There is a table

joxi.ru/8An6qjRsjDvMqA

id auto_increment

When operating on the site, and remove the row with id=9

There is a possibility in MYSQL what would the next data is added to this database, the data was in the row =9 ? Next at 11, 12, 13, etc.
Well, that is the correct seeding, that would have been the order of 1,2,3,4, etc.
And it turns out 1,2,5,6,7,10,11 etc.
by | 13 views

1 Answer

0 like 0 dislike
AUTO_INCREMENT guarantees only that the id of the next inserted row will have more than id of any other row in the table. Gaps when you delete a row and failed inserts is quite a normal situation, to deal with it makes no sense.
by

Related questions

0 like 0 dislike
2 answers
asked Apr 13, 2019 by Teshuhack
0 like 0 dislike
2 answers
0 like 0 dislike
1 answer
110,608 questions
257,186 answers
0 comments
33,949 users