- , , . " ", .. , , - , , - , , ( ). , , . - , . - , , . () . , , - , , , .
, :
COMMIT ( ).
ROLLBACK ( ).
.
.
COMMIT . , , .. .
ROLLBACK , , , .. , .
.
, , .. , , . , . , . ( ). . , . . .
, .. . . .. , , , .
|
|
( ) .
SQL . . , ( , ).
SQL 4 :
READ UNCOMMITTED - .
READ COMMITTED - .
REPEATABLE READ - .
SERIALIZABLE - .
( ), . , . SQL , , :
("" , ).
( ).
( - ).
SQL , .. , .
. :
. SQL
READ UNCOMMITTED | |||
READ COMMITTED | |||
REPEATABLE READ | |||
SERIALIZABLE |
SQL,
:
SET TRANSACTION { ISOLATION LEVEL
{ READ UNCOMMITTED
| READ COMMITTED
| REPEATABLE READ
| SERIALIZABLE }
| { READ ONLY | READ WRITE }}.,..