How to set up auto_increment in phpMyAdmin?

Question

PHP

Good evening! auto_increment in phpMyAdmin works well, I would say properly, but as soon as I delete a line, when new information is entered, auto_increment assigns the next id at the moment when the previous (deleted) ID is free. How to fix such a defect and fill in free id?

Answer 1

and NAFIGA?
Do you think there is not enough space?
And if you still haven't changed your mind - befused.com/mysql/reset-auto-increment

Answer 2

This is normal behavior. The id field should only be used as a row identifier.
And if you want to make a beautiful output of numbers in order, say in a table, make a query like this:
select id, @i:[email protected]+1 as beauty_number from table