consult data:
1. MySQL transactions are isolated, and the intermediate state in the transaction process is not visible;
2. MySQL dirty reading means that a transaction is making changes to a record, and the data of this record is in an inconsistent state before the transaction is completed and committed. At this point, another transaction also reads the same record, and if uncontrolled, the second transaction reads these "dirty" data and makes further processing accordingly, resulting in uncommitted data dependencies.
the question is:
since transactions are isolated, how can you read "dirty" data that other transactions have not committed?