The difference between phantom reading and non-repeatable reading

The key to non-repeatable reading is to modify:
The same condition that you read the data, read it again and find that the value is different

The focus of Phantom reading is to add or delete
The same conditions, the 1th and 2nd readings of the number of records are not the same
Of course, judging from the overall results, it seems that both of them appear to be inconsistent with the results of two reads.

But if you look at it from the point of view of control, the difference between the two is larger
For the former, only the record that satisfies the condition needs to be locked
For the latter, lock the record that satisfies the condition and its close

Non-repeatable reading focuses on update
The key to Reading is Insert,delete

The difference between phantom reading and non-repeatable reading