for example, the isolation level of transaction An is repeatable read
my understanding is that a read sql statement of transaction An is the same as the result repeated many times,
regardless of whether or not other transactions have changed the data rows / tables affected by sql
and if the isolation level of transaction An is read committed
, the rows / tables affected by transaction A can only be seen by other transactions after the transaction commits.
so these two isolation levels, one is the influence of other people"s actions on their own reading
, the other is the influence of their own actions on others" reading
feeling is not consistent
because I think it is either the influence of other people"s actions on their own reading
or the influence of their own actions on others" reading
how to understand?
and serializable is even more difficult to understand
if a transaction is serializable, which means that the transaction monopolizes its affected data tables / rows during execution, and operations in any other isolation-level transaction cannot be performed? Or will both transactions affect each other at the serializable isolation level?