What happens if a row is deleted and another inserted. Will the auto-increment fill the cap or not?

Answer 1

no it will not fill the gap...

Answer 2

Auto_Incerment will not filled the gap.

Answer 3

no

Answer 4

maybe

Answer 5

No it does not adjust. But u can reset auto increment counter using ALTER TABLE statement.