How to automatically reset autoincrement order while deleting a row in a database?

Databases
22

I solved problem by reading concepts of database design and database architecture