[vIBIENNYx]

Whenever I need to delete an account for whatever reason, it messes up the MySQL key information and causes the register system to crash, how can I use MySQL to fix the primary key (Account ID) to suit the deleted account?

For example, I have 15 accounts, and I delete the nineth.

I want ten to become nine, eleven to become ten, etc.

How can I do this?