本文探讨了在并行操作数据库时如何通过不同类型的锁保护数据，包括S锁（用于SELECT语句）、RS锁（用于带WHERE条件的SELECT）、X锁（用于DDL语句）、RX锁（用于SELECT...FOR UPDATE）及RSX等类型。
the lock is aiming to solve the porblem that when parallel minipupating the database,it can protect the data
the lock is divided into the following:
1 S .such as select * from tablename
2 RS .such as select * from tablename where
3 X .such DDL statmtemnets
4 RX such as select * from tablename for update
5 RSX
the lock is divided into the following:
1 S .such as select * from tablename
2 RS .such as select * from tablename where
3 X .such DDL statmtemnets
4 RX such as select * from tablename for update
5 RSX
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
