How does MySQL find out the value of the ID discontinuity?

My id is self-increment, has deleted the record, now I want to find out the discontinuous ID.

Reply content:

My id is self-increment, has deleted the record, now I want to find out the discontinuous ID.

Delete, it is best to add a field to indicate the state, deleted delete is set to 1, the default is 0, so the ID will not be broken, the first method is good

Can I perform other data operations? If you can get the last row of the database and then produce a data table of equal height, and then join and then isnull to judge it almost.

Ask a specific question, and give the scene a proper

