After mysql deletes a part of the id, how can the subsequent primary keys be sorted by the largest primary key?

  mysql, question

For example, there were originally 10 rows with primary keys 1-15.
Then delete one line and become 1-14
The next time you insert it, the primary key will be 16
How can he be 15?

How to use sql command?

The simplest method is to modify the AUTO_INCREMENT of the table structure
图片描述