Why are "all" (50350), the last AUTO_INCREMENT id from (59922) and COUNT(*) (59717)?
There is a table InnoDB.
the last AUTO_INCREMENT id from (59922)
and COUNT(*) (59717)
Why such a difference in the count and is this normal ?
asked March 20th 20 at 11:51
The fact that the AUTO_INCREMENT function is used to generate a unique ID, which will characterize the new (insert string)
A COUNT function to get the number of rows in the sample.
AUTO_INCREMENT ID from the last inserted row is the same as the result from the COUNT function only in case if table is not deleted no rows with data.
The answer to your question:
If they differ, then made deleting rows from a table.
Specifically in your example were removed 59922 - 59717 = 205 records.
Find more questions by tags MySQL