How to fill out the table?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
16 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 | 16 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
How to fill out a table using ajax?
asked Apr 13, 2019 by Teshuhack
0 like 0 dislike
2 answers
How to create a table and fill it inside a transaction?
asked Jun 4, 2019 by NubasLol
0 like 0 dislike
1 answer
How to fill out the fields JSON-LD?
asked Jun 4, 2019 by Azami

Most popular tags

javascript php css html jquery wordpress python linux web-development mysql android windows java layout c# computer-networks node.js cpp iron yii vue.js 1C-Bitrix react laravel django nginx system-administration search-engine-optimization api ubuntu the-it-education. ajax sql programming hosting cms design apache google-chrome bootstrap Vkontakte macos google network-administration git laptops algorithms regular-expressions unity-game-engine email angular database network-equipment software wooсommerce debian .net ios information-security video law-in-it browsers books parsing wi-fi game-development career htaccess postgresql telegram mikrotik mobile-development ruby-on-rails the-domain-name-system modx Yandex c json opencart Habr freelance vpn asp.net windows-server symfony bots hard-drives math qt DIY audio frontend payment-system bash electronics gulp.js user-interface docker online-shopping
110,608 questions
257,186 answers
0 comments
35,573 users