How to make table row id start from 1 even after deleting several rows?

Question

Python

I had a problem that when deleting rows from a table, the id order is violated, how to solve this so that when a row is deleted, the id order is not violated and always starts from 1

Answer 1

No need to delete records, just replace the string with null, then there will be no problems in your case.

Answer 2

You don't have to do that. The whole point of identifiers is their immutability.

Answer 3

the order of id was not violated

The order of id is not violated during autoincrement. Always goes in ascending order.
If you want to renumber rows, it will take a lot of resources to change the numbers of all records if any row is deleted. Yes, and what's the point?